Bulk Latitude and Longitude Finder — Excel & CSV Spreadsheet

Do you have a list of addresses that you need to quickly find the latitude/longitude coordinates for?

With Geocodio, you can upload a spreadsheet and get the results emailed to you—often within minutes.

(Note that Geocodio only works for the US, Canada, and Mexico.)

Unlike the majority of geocoding services, Geocodio does not have any usage restrictions, so you are free to store the latitude/longitude in your database, use them in an application or on your website, or even resell them as part of your own services.

Do you want to bulk find latitude/longitude via API or spreadsheet upload?

Perhaps the addresses you need latitude/longitude for are in a spreadsheet. Or, perhaps you have a program that needs to ingest and convert addresses on a regular basis, and would prefer to use an API.

Geocodio has tools to upload a spreadsheet and an API. You can even process a CSV spreadsheet via API!

Many people do both. For example, you may need to batch convert your current database of addresses into latitude/longitude coordinates and then have more coming in on a regular basis. In that case, you might upload a CSV or Excel file of coordinates, put the coordinates into your database, and then integrate the API for your ongoing needs.

Find Latitude/Longitude Coordinates in Bulk (Excel/CSV Spreadsheet)

Alternatively, you may have a spreadsheet of latitude/longitude coordinates that you want to convert into approximate addresses.

Note that we do not remove any data from spreadsheets. We simply add columns. You can download an example results file here.

Organize the addresses you want to convert to latitude/longitude in a spreadsheet

The first step is to put the coordinates in a consistent format: the address can be broken up into separate columns, or it can be combined into one column. But it must be consistent.

Multiple-Column Format with Addresses

(Note for Canadian addresses: A country column with "Canada" given exactly is required.)

Single-Column Format with Addresses

However, the formats cannot be mixed, as below:

See more and download example files here.

Upload the spreadsheet of coordinates to Geocodio for processing

Next, go to the Geocodio upload tool and upload the spreadsheet. After you confirm the columns, you'll be shown a preview of the results to make sure everything looks as expected.

We will only add columns to your spreadsheet—we won't remove anything.

Next, you can add additional data, such as Census FIPS codes, time zones, Congressional districts, and more.

Download the completed file with addresses added to your coordinates

After you press Submit, your spreadsheet will be automatically processed. You do not need to stay on the dashboard in order for the file to process.

We will send you an email when processing is done, and you will be able to download a CSV directly from the email.