With Geocodio, you can easily turn US and Canadian addresses on your spreadsheet into latitude and longitude, or turn latitude and longitude into addresses. You can also geocode zip codes (US only) and city/state pairs.
At the same time, you can also get Congressional districts, timezones, state legislative districts, and school districts for the addresses.
Our upload tool can be used for bulk geocoding a spreadsheet or list. The file size limit is 1 GB, which in many cases means you can geocode a spreadsheet of over 10 million rows in one upload.
You can also bulk reverse geocode a spreadsheet, or turn latitude/longitude pairs into approximate addresses.
If you have a list larger than 10 million rows, please reach out to us -- we can spin up additional resources and manage the upload for you to make it easier and faster. (You can still split it into multiple smaller lists if you'd like.)
What you'll get
When you upload a spreadsheet to Geocodio, we'll give you:
- A downloadable CSV of addresses turned into lat/lon, or lat/lon turned into addresses, plus any additional data you've requested
- A link to a map of your addresses, which you can privately or publicly share if you'd like
- Parsed and standardized addresses
- Accuracy scores and types for each result
Cost and Processing Time
We encourage you to test out the tool before uploading a large list. You can bulk geocode a list of up to 2,500 addresses free per day without a credit card required.
When you upload a list, you'll see a bar on the bottom that will estimate the cost and processing time.
You can also use our pricing calculator to estimate how much you'll be charged and how long the upload process will take. Volume discounts automatically kick in at 250,000 lookups.
You'll be charged via credit card for your uploads on the first of the following month. Volume discounts will be applied based on your usage for the entire calendar month.
We suggest doing a little pre-upload grooming before geocoding your list. You'll want to:
- Make sure your spreadsheet has headers
- Clearly mark countries, if applicable (Canadian addresses must be accompanied by a country column stating "Canada")
1. Uploading the spreadsheet
After uploading the spreadsheet, you will be asked to select the appropriate columns to geocode.
Selecting column values
We'll try to pre-select the columns that we think that you might want to use for geocoding, and we encourage you to double-check this to make sure our mapping is what you intended.
You can modify the column selections using the individual dropdowns. You can also manually set the value for an address component for the entire list by clicking the pencil icon.
In this example, we specify that all addresses in the list are located in Virginia.
Geocoding a single column
If your address is in a single column, you can click the following link:
This will present you with just a single dropdown:
2. Previewing your list
Next, you'll be able to preview the results of your list. This maps a small sample of the addresses on your spreadsheet so you can make sure the results are as expected.
Note, this map is just for visualization purposes. When your spreadsheet has completed geocoding, you will receive a link to a shareable map with the results as well as a downloadable CSV.
3. Additional data
If you'd like, you can also add additional data. Options include:
- Finding Congressional districts for addresses
- Finding state legislative districts (upper and lower) for addresses
- Finding timezones for addresses
- Finding school districts for addresses
- Census data for addresses
Each additional data field counts as an additional lookup. So, for example, if you have a list of 2,500 addresses and you'd like to find the Congressional districts for those addresses, the total number of lookups will be 5,000. Volume discounts apply to additional fields.
4. Review & Finalize
Before you upload your list, you'll see a summary of the upload, the cost, and the estimated processing time.
If you have any questions about your upload, you can always open the chat window in the lower right hand corner. We'll help you as soon as we can.
5. Tracking upload progress
After you upload the file, you'll be taken to the Geocodio Dashboard. Here, you'll be able to see the progress of your file in real time. (Note, if the progress bar doesn't seem to be moving, please try refreshing the page.)
Note that you don't need to keep this page open during the upload. We'll send you an email when the file is complete.
6. Getting your completed file
When your file has completed geocoding, we'll send you an email with a link to a downloadable CSV of your addresses and a link with the addresses displayed on a map.
7. Viewing and sharing your map
When your spreadsheet has completed geocoding, you'll get a link to a map with your addresses.
You can share the map if you'd like.
8. Deleting the file
Your file will be securely stored on our servers unless you delete it. You can permanently delete it from our servers on the dashboard.
If you have any questions about geocoding a spreadsheet, please reach out via the chat window or email. We'll help you out as soon as we can!