The Ultimate Guide to Geocoding Tools

First of all, what is geocoding?

Good question! Well, geocoding is the process of turning an address into a coordinate that specifies its latitude and longitude values. This is called Forward Geocoding.

There is also reverse geocoding. Which allows you to convert latitude and longitude values into an address.

Geocoding allows us to easily locate addresses on a map and is often used for mapping, geographic analysis, spatial analysis, etc.

A typical forward geocoding process

Hmm, ok… So what’s this article about?

I have analyzed and prepared a list of of several no-code tools and applications that don’t require any technical knowledge to Geocode.

All you need is a list or spreadsheet of addresses.

These tools accept lists of addresses, often in spreadsheets or csv files, and either do Forward Geocoding or Reverse Geocoding, or often both.

This article will let you compare and contrast between several geocoding tools!

Without further ado, in no particular order, here are the best no-code Geocoding tools

1. Geocodio

Image for post
Image for post

Price: Free base plan, premium plans start at $0.50 for 1,000 requets

Coverage: US and Canada only

Pros: Easy UX, Automatic address parsing, Excel and CSV support, Robust Documentation, Good value for price

Cons: No International coverage

This website is very similar to Clean Spreadsheets in the case that it also reads addresses in any format, cleans it up for you, and fills in missing information. The difference in this tool is that it is primarily a geocoding tool, so it doesn’t help the user to reformat any other types of data.

However, it does make up for that by providing more information for each address, such as timezones and Congressional districts. In addition, they also let you view all your addresses in a map.

The thing I don’t like about the map is that their preview of your data is only in map form, but I’d like to have a preview of the geocoded values in a spreadsheet as well before I download it.

In addition, another downside is that this site only covers locations in the US and Canada. Despite those negatives, I still think that this is a great tool with a really easy-to-use website.

There is a free subscription to this site that allows for 2,500 lookups daily and then there are paid subscriptions after that, which cost $0.50 for every 1,000 lookups or $1,000 a month for unlimited lookups.

2. Clean Spreadsheets

Image for post
Image for post

Price: Free trial, pay as you go pricing starting at $1 for 1,000 addresses

Coverage: International

Pros: Easy UX, Automatic address parsing, International coverage, Excel and CSV support, Good value for price

Cons: Lacking robust support documentation

Clean Spreadsheets is our tool that along with geocoding, helps you reformat and clean up names, dates, company names.

The tool will automatically arrange your address components if they are split amongst different columns (you can rearrange to form your address string too!). And also does auto parsing for incomplete addresses.

It also provides you with a pretty nice preview of your results, which include a lot of metadata, so that you can go back and make edits as necessary.

It can geocode addresses internationally and has a free trial starting with 250 credits. Like many other sites, this operates on a pay as you go pricing after the free trial starting at $1 for 1,000 addresses.

The documentation is lacking in completeness and users sometimes need to use the chat support to get answers.

3. Smarty Streets

Image for post
Image for post

Price: Free trial, subscriptions starting at $50 a month for 5000 US addresses and $7 a month for 100 International addresses

Coverage: US and/or International

Pros: Easy UX, Automatic address parsing, International coverage, Robust documentation

Cons: Expensive subscription, No Excel or CSV support

Smarty Streets is an extremely user-friendly tool that requires a subscription that allows single address input in both field by field inputs or as a single line (which is a feature I love in these tools).

They also help you correct and autocomplete your address which is helpful.

Speaking of which, this also has a batch geocoding option but your spreadsheet must be formatted in a specific manner, which is fine for a free tool but, like for the last geocoder, is disappointing for a paid tool.

Going into that, the price is where I believe this tool is the weakest; US geocoding is free up to 250 lookups a month and plans start at $50 a month or $460 a year after that.

They also have international geocoding plans starting at $7 a month or $70 a year.

4. Batchgeo

Image for post
Image for post

Price: Free base plan, premium plans starting at $15 a month

Coverage: International

Pros: International coverage, Good value for price, Good documentation

Cons: No Excel or CSV Support, Poor UX, No automatic address parsing

Similar to Geocodio, Batchgeo actually maps out all of your addresses for you and gives you an option to save your map. However, they don’t return you an actual spreadsheet of geocoded coordinates.

The website is relatively easy to use but I did run into some annoyances. They allow you to copy and paste spreadsheet data into their input box in any format (though it is most accurate when in the format they provided), but I really wish they just had an upload file option.

In addition, I didn’t like that they ask you to save your map to your email before you even see the final result.

They start out with a free subscription and you can upgrade into Lite for $15 a month or Pro for $99 a month to receive additional features, such as password protection and PDF exporting. Most countries are included in their map, so it is international.

5. CSV2GEO

Image for post
Image for post

Price: Free trial, pay as you go starting at $5 for 5000 or subscription starting at $49 a month

Coverage: International

Pros: International coverage, Good documentation, CSV File Support, Good value for Price, Automatic address parsing

Cons: Poor UX, No Excel file support

I would call this website a less visually appealing version of Clean Spreadsheets or Geocodio.

It’s another batch geocoding website that receives a spreadsheet in any format and returns coordinates along with a map.

The only difference about this website is that it won’t automatically clean up addresses and they ask you to select what is included (such as “City”) in each column. However, that wasn’t too big of a hassle.

For pricing, there is a free trial that provides you up to 100 conversions a day and then options to perform more geocoding. They have a pay as you go option starting at $5 for 5000 locations or $49 a month, with increasing prices as you geocode more addresses.

Like most of the batch geocoding options I listed, this is also a worldwide tool.

6. LocalFocus Batch geocoder for journalists

Image for post
Image for post

Price: Free

Coverage: International

Pros: Easy UX, Automatic Address Parsing, International coverage, Free

Cons: No Excel or CSV Support, Lacking robust documentation, feature deficient

This batch geocoder may not have a lot of features but I really liked it, particularly because it’s completely free. Similar to Batchgeo, you paste in your addresses (both plain text and spreadsheet data works), verify the locations on a map, and then (unlike Batchgeo) you can copy and paste the final coordinates back onto a spreadsheet.

I wish there was an upload and download option but they made the copy and pasting process so clean that I didn’t miss that too much. Like most other batch geocoders here, they also help to fill in your missing address information if you are missing something (like a zip code).

Furthermore, since they read information based on a single line, you don’t need to confine your data to a specific format in regards to spreadsheet columns.

7. MapLarge

Image for post
Image for post

Price: Free trial, pay as you go pricing starting at $10 for 2,500 requests

Coverage: International

Pros: International coverage, Excel & CSV File Support, Good value for price

Cons: No automatic address parsing, Poor UX, Lacking robust documentation

MapLarge is another international geocoder with really simple features. You simply upload your spreadsheet (in any format, as long as it’s one address a row) and download the final spreadsheet with added coordinates. There aren’t any previews so it’s pretty straight to the point.

The downside to this site is that, for the few amount of features it has, it is a lot more expensive than some of the other sites on this list. It does have a free trial but only for the first 100 requests that you make. Along with that, the website isn’t as clean as some of the others on this list so, like CSV2GEO, it’s another less visually appealing version of Clean Spreadsheets and Geocodio.

8. US Census Bureau Geocoder

Image for post
Image for post

Price: Free

Coverage: US only

Pros: Great value for price, Good documentation, Excel and CSV support

Cons: No international coverage, Poor UX, No automatic address parsing

This is a popular choice for Geocoding US addresses.

Under the “Find Locations Using…” option, users are able to find the geocode of one address or a spreadsheet/batch of addresses (but those must be formatted in a specific manner).

For spreadsheets, up to 10,000 addresses can be processed at a time. This website uses addresses collected through the US census, so the data inside of this geocoder consists mainly of residential addresses.

This means that some US commercial areas may have limited ranges. However, this tool and relatively easy to understand and use, despite the website seeming a bit dated and confusing at first.

9. Texas A&M Geoservices

Image for post
Image for post

Price: Free trial for batch geocoding, pay as you go starting at $10 for 500 lookups

Coverage: US only

Pros: Good documentation, Good value for price

Cons: Poor UX, No automatic address parsing, No international coverage, Lacking good documentation

Texas A&M Geoservices is another popular choice and, like the US Census Bureau, it uses US census data and only covers addresses within the US.

There’s a batch option that also requires data in a specific format. However, only the single address lookup is free while batch geocoding requires a subscription.

These subscriptions start out with 2500 free credits (or just 2500 address lookups) and you can buy more credits as you go, which range from $10 for 500 credits to $1200 for 1,000,000 credits.

I personally prefer using the US Census Bureau geocoder over this, especially due to the pricing and similar results.

10. Map Developers

Image for post
Image for post

Price: Free

Coverage: International

Pros: Good value for price, International Coverage

Cons: No spreadsheet or CSV option, Poor UX, No automatic address parsing, Lacks good documentation

Map Developers is an international geocoding tool and uses information from Google Maps in order to retrieve data.

The great feature of this website is the batch geocode tool under “Map Tools”, which allows you to geocode several addresses by separating each address by one line.

It’s a really simple, easy-to-understand text field that works great for a small batch of locations.

Unfortunately, you can’t upload your spreadsheets to this website, but the website is completely free (though it consists of many advertisements).

11. Geocode XYZ

Image for post
Image for post

Price: Free single address lookup; batch geocoding starts at $2.50 for 1,000 requests or $225 a month

Coverage: International

Pros: Easy UX, International Coverage, CSV File Support, Decent value for price

Cons: No Excel support, No automatic address parsing

Geocode XYZ is an international geocoder that’s extremely easy to use. The input does have to be formatted a specific way which can be a bit confusing at first (for instance, the worldwide geocode input shouldn’t include the state name) but is easy to get used to.

The single geocode option is completely free, but the batch geocode option and geocode API does require a subscription, which is $2.50 per 1,000 requests or about $225 a month for unlimited requests.

The batch geocode option also requires spreadsheet data to be in a specific format, which I think is disappointing for a paid tool.

What about if I want to use a tool that lets you Geocode using programming?

Geocoding using programming requires tools that have REST APIs. Here are some APIs you can use to Geocode.

  1. Open Cage Data
  2. Geocodio
  3. MapQuest
  4. LocationIQ
  5. PositionStack
  6. TomTom
  7. Geocode.xyz
  8. Geocodeapi
  9. Geocode Earth
  10. MapLarge
  11. MapTiler
  12. Loqate

Wrapping Everything Up

Woah, you made it to the end of this article. That means that you now have a pretty good idea about the no-code geocoding tools out there!

If you have any further questions don’t hesitate to reach out at info@lovespreadsheets.com!

Products and resources that magically simplify hard spreadsheet tasks. Check us out at www.lovespreadsheets.com

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store