Address to Coordinates Converter
Turn addresses into latitude and longitude, or coordinates back into addresses. One line or a whole list, anywhere in the world, with a CSV download.
No limit on US addresses.
Looking it up
US addresses go to the Census Bureau, the rest to Google Maps.
| # | You entered | Latitude | Longitude | Address found |
|---|
Need coordinates for a whole list in Excel?
Address Formatter is an Excel add-in that adds Latitude and Longitude columns to every row, next to the street, city, state, ZIP code and county. It works in any country, reads typos and half addresses the way Google Maps does, and takes 25,000 rows in one run. One-time purchase.
Get the add-in- Free, no sign-up
- Any country
- Coordinates to addresses too
- Decimal or DMS
Where the coordinates come from
Every line is matched by a real geocoder, and the result says which one.
US addresses
Matched by the US Census Bureau's geocoder, straight from your browser. Free, and there is no daily limit.
Everywhere else
Addresses in other countries, landmarks and place names are matched by Google Maps. Up to 20 in a list, three lists a day.
Coordinates to addresses
Paste coordinates instead and you get the nearest address back. Decimal and degrees, minutes and seconds both work, even mixed in one list.
Online converter or Excel add-in?
Use this page for a quick answer or a short list. Use the add-in when the addresses already sit in a spreadsheet.
| This page, free | Excel Address Formatter add-in | |
|---|---|---|
| Addresses at once | 20 | 25,000 rows in a single run |
| Daily limit | None for US addresses, three lists for the rest | As many as your Google quota allows |
| What you get | Latitude, longitude and the matched address | 13 fields: coordinates plus street, city, state, ZIP, county and more |
| Where it runs | This page | In the workbook you already have |
| Formulas | None | =GEO.LAT and =GEO.LNG, like any Excel function |
| Google key | Not needed | Your own, 10,000 free lookups a month |
| What you install | Nothing | A Microsoft Marketplace add-in, no macros |
Frequently asked questions
Paste the address into the box, one per line, and click Get coordinates. US addresses are matched by the US Census Bureau's geocoder and everything else by Google Maps, and every line comes back with its latitude, its longitude and the address that was matched. Download the list as a CSV, or copy it straight into Excel.
Yes. Put coordinates in the box instead of an address, such as 40.7128, -74.0060, and you get the nearest street address back. That is called reverse geocoding. Decimal degrees and degrees, minutes and seconds both work, and you can mix coordinates and addresses in one list.
Latitude. In 40.7128, -74.0060 the first number is the latitude, how far north or south of the equator a place is, and the second is the longitude, how far east or west of Greenwich. South and west are negative. On a map, longitude is the x axis and latitude the y axis, which is why some software asks for them the other way round.
They are two ways of writing the same position. Decimal degrees use one number per axis, such as 40.7128. Degrees, minutes and seconds split it like a clock, 40°42'46"N, where a minute is a 60th of a degree and a second a 60th of a minute. Switch between them with Show coordinates as; the CSV always has both.
For a full street address, usually to the building or to within a few houses. The Census geocoder places a US address along its stretch of street, and Google Maps often has the building itself. A ZIP code, a city or a landmark on its own gives the center of that area, so add the street and house number when precision matters.
Up to 20 lines at a time. US addresses have no daily limit; addresses in other countries and coordinates go through Google Maps, three lists a day. For more, the Excel Address Formatter add-in converts 25,000 rows in one run with your own Google key.
Yes. Addresses in other countries, landmarks and place names are matched by Google Maps, anywhere in the world. Only US addresses use the Census geocoder, because that is where it has data.
No. US addresses go straight from your browser to the US Census Bureau. Everything else passes through my server to Google Maps and comes straight back. Nothing is saved or shared.
For a short list, click Copy for Excel on this page and paste into your sheet. For a whole list, the Excel Address Formatter add-in adds Latitude and Longitude columns to every row, and it has formulas too: =GEO.LAT(A2) and =GEO.LNG(A2).
Yes, for US addresses: the free county lookup returns the county, the state and the FIPS code for up to 50 addresses, ZIP codes or coordinates at a time.
Get Latitude and Longitude for Your Whole Excel List
The Excel Address Formatter add-in fills in the coordinates for every row, with the street, city, state, ZIP code and county next to them.
Get the add-inOne-time price. Excel on Windows, Mac and the web.
US geocoding by the US Census Bureau, which does not endorse this site. Google Maps is a trademark of Google LLC and Excel a trademark of Microsoft Corporation; neither is affiliated with this tool.