This article walks you through how to turn US and Canadian latitude/longitude coordinates (GPS coordinates, lat/lon) into approximate addresses.
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.
Geocodio has a reverse geocoding API and also the ability to upload a spreadsheet of addresses.
Many people do both. For example, you may need to convert your current database of coordinates into addresses and then have more coming in on a regular basis, in which case you might upload a CSV or Excel file of coordinates, put the addresses into your database, and then integrate the API for your ongoing needs.
The Geocodio API can turn US and Canadian latitude/longitude coordinates into approximate addresses.
The first step is to create an account and then create an API key. Creating an account and an API key are both free, with no credit card or other payment information required at set-up. You can run up to 2,500 lookups for free per day.
You can do single requests or batches of up to 10,000 lookups.
You can see our documentation for reverse geocoding here.
In the same request, you can also add other data you might need, like time zones, Congressional districts, Census FIPS codes, Census household income data, or other information. You can see the full list of available appends in our documentation.
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.
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.
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.
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 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.