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.