Map Spreadsheet Locations To Google Maps

Martin Brinkmann
Apr 30, 2010
Updated • Sep 14, 2016

Batchgeo is a free online service that maps spreadsheet locations to Google Maps.

This can be useful for several purposes including creating a store finder, creating a map, calculating distances, house or apartment buying, finding the best route to visit several locations and more.

All that needs to be done to map the locations is to paste the spreadsheet information into the form on the Batchgeo website.

The online service will automatically use the first row as identifier which means that users need to make sure that it contains those.

Identifiers such as zip, address or city can be linked to the right columns in case the automatic detection does not do that correctly.


Batchgeo creates a Google Maps map with the location of the spreadsheet displayed on the map.

It is then possible to save, print and share the map that has been created, download Google Earth KML data, or download the geocoding results again.

All Google Maps view modes are available (map, satellite, hybrid and terrain).

There does not seem to be an option to directly embed the mapped information on a website, only to create a static url on the batchgeo website. The blog mentioned a button to create the embed code but the button is nowhere to be found on the site.

Batchgeo can be a handy program, especially for users who need to create a map from location information stored in a spreadsheet.

Update: The core service is still freely available on the Internet. The developers have added a professional option to their website some time ago, that is offering faster geocoding, password protection, street view integration and pdf support among other features.

The service is ideal for brokers, and people who are looking to buy an apartment or house. It may also be useful for anyone who wants to display a list of locations on a map.

Free users can still use the service directly without registering for an account or signing in to one. All you need to do is paste the spreadsheet data into the form on the main Batchgeo website, and click on the "validate & set options" button afterwards.

This lists the identified fields and provides you with options to correct those that the service may not have identified correctly. You may display advanced options on top of that that list additional data fields and options. This allows you to select the default map view or switch between miles and kilometers. Also, you may change the map style, markers, and colors.

One all that is done, hit the make map button and wait for the data to be analyzed and processed by Batchgeo. A map preview is displayed afterwards that you may use to drag and drop markers to other locations if they are misplaced.

You may publish the map publicly, or keep it unlisted. You do need to provide an email address though for that. This email address is also the key to editing the map at a later point in time.


Map Spreadsheet Locations To Google Maps
Article Name
Map Spreadsheet Locations To Google Maps
Batchgeo is a free online service that you may use to map spreadsheet location data to Google Maps to get an overview of all locations on a map.
Ghacks Technology News

Tutorials & Tips

Previous Post: «
Next Post: «


  1. ilev said on August 4, 2012 at 7:53 pm

    Doesn’t Windows 8 know that www. or http:// are passe ?

    1. Martin Brinkmann said on August 4, 2012 at 7:57 pm

      Well it is a bit difficulty to distinguish between domains and files for instance.

    2. Leonidas Burton said on September 4, 2023 at 4:51 am

      I know a service made by google that is similar to Google bookmarks.

  2. VioletMoon said on August 16, 2023 at 5:26 pm

    @Ashwin–Thankful you delighted my comment; who knows how many “gamers” would have disagreed!

  3. Karl said on August 17, 2023 at 10:36 pm


    The comments section under this very article (3 comments) is identical to the comments section found under the following article:

    Not sure what the issue is, but have seen this issue under some other articles recently but did not report it back then.

  4. Anonymous said on August 25, 2023 at 11:44 am

    Omg a badge!!!
    Some tangible reward lmao.

    It sucks that redditors are going to love the fuck out of it too.

  5. Scroogled said on August 25, 2023 at 10:57 pm

    With the cloud, there is no such thing as unlimited storage or privacy. Stop relying on these tech scums. Purchase your own hardware and develop your own solutions.

    1. lollmaoeven said on August 27, 2023 at 6:24 am

      This is a certified reddit cringe moment. Hilarious how the article’s author tries to dress it up like it’s anything more than a png for doing the reddit corporation’s moderation work for free (or for bribes from companies and political groups)

  6. El Duderino said on August 25, 2023 at 11:14 pm

    Almost al unlmited services have a real limit.

    And this comment is written on the dropbox article from August 25, 2023.

  7. John G. said on August 26, 2023 at 1:29 am

    First comment > @ilev said on August 4, 2012 at 7:53 pm

    For the God’s sake, fix the comments soon please! :[

  8. Kalmly said on August 26, 2023 at 4:42 pm

    Yes. Please. Fix the comments.

  9. Kim Schmidt said on September 3, 2023 at 3:42 pm

    With Google Chrome, it’s only been 1,500 for some time now.

    Anyone who wants to force me in such a way into buying something that I can get elsewhere for free will certainly never see a single dime from my side. I don’t even know how stupid their marketing department is to impose these limits on users instead of offering a valuable product to the paying faction. But they don’t. Even if you pay, you get something that is also available for free elsewhere.

    The algorithm has also become less and less savvy in terms of e.g. English/German translations. It used to be that the bot could sort of sense what you were trying to say and put it into different colloquialisms, which was even fun because it was like, “I know what you’re trying to say here, how about…” Now it’s in parts too stupid to translate the simplest sentences correctly, and the suggestions it makes are at times as moronic as those made by Google Translations.

    If this is a deep-learning AI that learns from users’ translations and the phrases they choose most often – which, by the way, is a valuable, moneys worthwhile contribution of every free user to this project: They invest their time and texts, thereby providing the necessary data for the AI to do the thing as nicely as they brag about it in the first place – alas, the more unprofessional users discovered the translator, the worse the language of this deep-learning bot has become, the greater the aggregate of linguistically illiterate users has become, and the worse the language of this deep-learning bot has become, as it now learns the drivel of every Tom, Dick and Harry out there, which is why I now get their Mickey Mouse language as suggestions: the inane language of people who can barely spell the alphabet, it seems.

    And as a thank you for our time and effort in helping them and their AI learn, they’ve lowered the limit from what was once 5,000 to now 1,500…? A big “fuck off” from here for that! Not a brass farthing from me for this attitude and behaviour, not in a hundred years.

Leave a Reply

Check the box to consent to your data being stored in line with the guidelines set out in our privacy policy

We love comments and welcome thoughtful and civilized discussion. Rudeness and personal attacks will not be tolerated. Please stay on-topic.
Please note that your comment may not appear immediately after you post it.