Convert a Spreadsheet of Lat/Lon Coordinates to Addresses
How to convert coordinates to addresses by uploading a spreadsheet. Store them in a database, use them in an application, or resell them as part of your services.
Quick Answer
Upload a CSV or Excel file of US and Canadian lat/lon coordinates to Geocodio and download the results with addresses added as new columns. No coding required, and no usage restrictions on storing or using the results.
Geocodio can find approximate addresses for US and Canadian latitude/longitude coordinates (GPS coordinates, lat/lon) directly from a spreadsheet.
This can be useful in a wide variety of situations, such as fleet/asset tracking, logistics, and advertising.
Unlike many geocoders, Geocodio does not have any usage restrictions, so you are free to store the addresses in your database, use them in an application or on your website, or even resell them as part of your own services.
Turn a Spreadsheet of Latitude/Longitude Coordinates into Addresses
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 coordinates you want to convert to addresses in a spreadsheet
The first step is to put the coordinates in a consistent format: latitude and longitude can be in separate columns, or they can be combined into one column.
Multiple column format:
| Latitude | Longitude |
|---|---|
| 38.8859111 | -76.9965694 |
| 45.5045128 | -73.621345 |
One-column format:
| Latitude and Longitude |
|---|
| 38.8859111,-76.9965694 |
| 45.5045128,-73.621345 |
However, the formats cannot be mixed, as below:
| Latitude Longitude | |
|---|---|
| 38.8859111 | -76.9965694 |
| 45.5045128,-73.621345 |
You can 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. 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.
If you're just testing out Geocodio, it's likely you'll use our pay-as-you-go plan. If your file was over 2,500 lookups and you use our pay-as-you-go plan, you will be charged on the first of the following month for the upload. For example, if you upload the file on May 15th, you will be charged on June 1.
Related Resources
Convert Coordinates via API
Prefer to integrate programmatically? Use the Geocodio API to convert lat/lon coordinates to addresses in real time.
Upload a Spreadsheet
Upload a spreadsheet of coordinates and turn them into approximate addresses
API Documentation
You can use the Geocodio API to turn latitide/longitude coordinates into addresses.
Data Appends
All of our data appends, including time zones, Census data, and political districts are available with reverse geocoding as well.
Fleet Management & Asset Tracking
Many geocoders, like Google, prohibit fleet management, asset tracking, and logisitics companies from using their services. Not Geocodio.
By the time you finish reading this page, the Geocodio API will have processed 5.3 million lookups.
Your data could be next...