How to import data from Microsoft Excel into GEOLocate for Georeferencing

Create a blank spreadsheet within Excel.  Add the following to the first row of columns in your spreadsheet:

Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Column 7 Column 8 Column 9 Column 10   
Row1 locality string country state county latitude longitude correction status precision error polygon multiple results

After the 10th column, you may add the names of other fields in your dataset that you would like to include (field number, localityID, remarks etc.) but you must be certain that each entry in the first row is unique.

Copy and paste your data from its original source to the appropriate columns starting at row 2 (alternatively, you could modify an existing spreadsheet to conform to the above format).

Select Save As... from the file menu in Excel.  Enter a filename for your file, select CSV (comma delimited) (*.csv) from the drop down box labeled Save as type, and click the save button.  Exit Microsoft Excel.

You now have a file that can be used with GEOLocate.

From the GEOLocate file menu, select Import -> CSV, and select the file you just created to import.