How to create a map from a list of addresses

If you have a list of postcodes that you’d like to see on a map, but don’t want to plot them all out individually, there are tools that can do it for you without programming knowledge.

I’ve tried a few of these and they used to be clunky, but Batchgeo is a very fast and accurate tool which just requires the skills to paste from a spreadsheet. Although it prefers as much information as possible, I’ve tried it with some addresses without postcodes and it found these too.

I’m grateful to David Foord who included Batchgeo in a tutorial on exporting a spreadsheet of addresses to Google maps.

And if you’re wondering why you would possibly want to do such a thing, Batchgeo has a handy list of reasons for everyone from the business-owner who wants to create a ‘branch finder’ map to the paper boy who needs a route map.

As usual, be cautious about uploading any personally identifiable information onto the public web.

This short video shows a really quick city map being created from information on Wikipedia.

I work part-time for Talk About Local, mainly trying to develop resources that will help make new bloggers’ journey smoother and widen awareness of the range of free tools at our fingertips and the clever ways people use them. I also help out with unconferences, webinars and workshops. I’m passionate about the communities that are sometimes left voiceless and love discovering the small, the hidden and the new.
clare white
View all posts by clare white
Clare's website

Possibly Related Posts:

One comment

  1. I’ve used BatchGeo for exactly the examples given above (locations of events, and dealer locations). I’d be really interested to hear form anyone that’s had joy with anything more specific than postal sector level (e.g. BS1). When I had multiple locations more granular than that it tended to group them on one point (rather than split it out and locate individually.) But for general location planning, it’s top.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

  • TAL Newsletter

    Sign up for our Newsletter