You can upload a spreadsheet in several common formats, including Excel spreadsheets (.xls), comma-separated spreadsheets (.csv), and tab-separated spreadsheets (.tsv).
A few helpful things to know about formatting your spreadsheet:
- Your spreadsheet must have headers
- You can name the header columns anything you like. During the upload process, you'll get to choose which columns contain the address components
- One column or multiple: You can put the address in a single column or split the address into separate columns (note, street number and name must be in the same column).
Now that your spreadsheet is formatted, go ahead and upload it!
PS. A few things to be aware of:
- We don't support Canadian postal codes. Canadian postal codes are proprietary to Canada Post and are not supported. This means you cannot geocode Canadian postal codes, and postal codes will not be returned with addresses. You can include them in your file, but we will ignore them in the geocoding process.
- Uploading a file you've downloaded from somewhere else: If your completed file doesn't appear to have any latitude/longitude columns added, scroll all the way over to the right and see if they've been placed there. If you've exported your spreadsheet from another piece of software, like a CRM, occasionally these programs insert blank cells into the spreadsheet.
- Excel quirk: make sure the first cell is not named "ID." If the first cell is named "ID", Excel will get confused and not be able to open your file. This is a rare error, but you might encounter it if, for example, you downloaded a CSV from your CRM, uploaded it to Geocodio, then tried to upload it in Excel. If you rename it "id" or "Id", it will work.
- Country must be specified when doing non-US geocoding. If any addresses in your list are in Canada, you need to have a country column and label them "Canada." (Abbreviations, such as CA or CAN, will not work.)
Here are a few examples of ways you can format your spreadsheet.
One column for the entire address
Multiple address columns
You can also geocode just cities.
The latitude/longitude will be a central point.
Or zip/postal codes:
Note: Canadian postal codes can currently not be geocoded as they are proprietary to Canada Post.