How to import data from Microsoft Excel into GEOLocate

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.   

*NOTE: Our web based file client now supports the generation of uncertainty radii.
If you wish to generate and record uncertainty radii for your records using this client, your spreadsheet must also include an additional column to store that data. In this case you would need at least 11 columns for your data instead of 10. Using uncertainty radii is optional, so you can ignore this, if you choose not to utilize that option.