Table of Contents

Spreadsheet formatting

In order to ensure your spreadsheet is geocoded properly, you need to check three things before uploading: whether it has headers, formatting the addresses consistently in either single column or multiple-column format, and including country (if geocoding Canadian addresses).

You can upload .xls, .xlsx, .csv, .tsv, and .zip files for geocoding. Download a sample list: .XLS (shows all acceptable formats), .CSV (shows multiple-column format only).

When you upload a file, we only add columns -- we won't delete any information from your spreadsheet. You can see an example geocoded file here.

1. Make sure your spreadsheet has 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

Examples of headers on a spreadsheet

2. Consistently format the addresses in one column or multiple columns

  • You can put the address in a single column or split the address into separate columns
  • The street number and name must be in the same column
  • Addresses do not need to be complete; see here for a list of acceptable addresses
  • If your spreadsheet includes addresses in both formats, you will need to split them into different lists

Acceptable format: multiple-column
Address data (street, city, state, ZIP) are split into multiple columns, and all addresses are formatted in the same way.

Addresses formatted in multiple columns

Acceptable format: single-column
All of the address data is in a single cell, and all addresses are formatted the same way.

Addresses formatted in a single column

NOT acceptable: Mixed format
Some addresses are formatted in a single cell, and some are spread across multiple cells. This would not process correctly. If your spreadsheet looks like this, you should split it into two spreadsheets. You can do this by filtering for addresses that have a blank second column and copy/pasting them into another spreadsheet.

Example with addresses combined in two formats, which is not acceptable

3. If your spreadsheet includes addresses in Canada, include a country column

  • With Canadian addresses, a Country column must be present and it needs to say "Canada" exactly (no abbreviations)
  • If no country is given, USA will be assumed

Example of a country column