The following tutorial explains how to work with Google Refine and NIFSTD (NIF standard ontology) to align terms in your data.
Step 1: Download Google Refine
Step 2: Load Google Refine
Step 3: Find your file and Create Project (upper right hand side)
Step 4: Find the column that you would like to refine (Note: it is very useful to have a duplicate column because refine will replace the text in the refined column). To start, click the column header and open the popup box.
Step 5: Select “start reconciling” data, and select the service that you want to reconcile to. To reconcile to NIFSTD ontology, use the Add Standard Service option (bottom left).
Step 6: Add service for NIF http://nif-services.neuinfo.org/ontoquest/reconcile
Step 7: Reconcile against no particular type (bottom middle button). Choose the column to reconcile.
Step 8: Select Start Reconciling and wait until Google Refine and the NIF service come to a reasonable agreement as to your data.
Step 9: Look at your data and export it back to Excel (or text). Google refine will allow you to align terms that are not aligned at this point by creating a new topic for all unaligned terms (just click on the two checkmarks to align all instances of your term in your data to some new label that you choose).
Step 10: Rejoice for you are (at least partially) reconciled with NIFSTD!
Trick to breaking the term and id:
NIF Version: 5.1
Ontology Version: 2.5
Level 2.5/3.0 Resources: 889
Registry Entries: 6,339
Total Records: 356,197,652