| 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.