Creating Google Maps from Postcode Data

Following the recent merger of the Career Development Divisions with local CILIP Branches I am now the Communications Officer for the West Midlands Members Network. In our first committee meeting it was suggested that instead of a big summer social, which was a long-standing tradition of the CDG WM group, we could hold smaller socials across the region to help us promote the new Regional Member’s Network. We asked CILIP for a list of our member’s postcodes which they very helpfully provided, however this left me with a list over 700 postcodes with no other way to determine where these members might be living (the rest of the address data had been removed).

I used the starting letters of the postcodes to give us a rough breakdown, but this wasn’t very specific and in some cases a bit misleading (some postcodes are to the nearest major town, even if it’s across the county border). Obviously a map would be the easiest way to see, at a glance, where our members are all located – and therefore help us pick which towns to focus our social events in.

Having previously played with – I mean done some web development work with – Google Maps as part of my Masters course I knew it was possible to plot multiple points on a Google map, but it had been several years since I studied and decided that a quick Google search would be more helpful than hunting out my old notes! I very quickly found this article: which makes use of a Google Docs feature called Fusion Tables. This feature is, very helpfully, still available in the new look Google Drive, but as some of the buttons have moved a little I thought it might be worth a blog post to help others who are trying to do this!

1. Open and select ‘Create’ on the red button on the left

2. Select ‘Connect more apps’ and select Fusion Tables from the (many) options (I used the search feature!) If you have used Fusion Tables before they will appear in the shortlist under ‘Create’ in future.

3. If your data is currently in a spreadsheet you can import it from this initial screen:

Image 3

Or you can build your table from a Google Spreadsheet or from an empty table.

4. You will be taken through a setup process to convert the Excel spreadsheet into a Fusion Table. One to confirm if the column titles are in the spreadsheet and another to name the Table.

5. You will then see this:

Image 6

Which is your Table! I’m using the postcodes of some local public libraries for this example – but you could use any postcode or address data.

7. On the column showing the data you want to map (either Postcodes or Long./Lat. data) click the drop down option and select ‘Change’:

Image 7

8. Change the data type to Location (as opposed to Text or Number):

Image 8

9. Then select File > Geocode for the Fusion Table to process the data:

Image 9 Image 11

This will obviously take a while if you have a lot of data! I can’t remember how long it took to process the 700+ records I mapped for WMMN, but it didn’t take a massive amount of time!

10. Then open a new tab. Select the ‘+’ tab and then ‘Add Map’:

Image 12

(I’m not sure why it’s highlighted my data – it’s certainly not a necessary step!)

11. Select which Location Data column you want to use for your map:

Image 13

12. There’s your map!

Image 14

As with any Google map you can zoom and move around the map – and you can share the document with other people the same way you can any Google Drive document.

If you want to embed the map on a webpage you can publish the map using the drop down on the ‘Map 1’ tab:

Image 15 Image 16

Which will give you embed codes to add to your website:

The Content Management System that CILIP uses currently prevents me from embedding the WMMN Member’s Map on our webpages, although it’s hoped an upcoming software upgrade will allow this. I have temporarily uploaded a screenshot of the map as an image, but for the WMMN Committee to use it’s fine to just share the document for now!

I hope you have found the article interesting, if not useful. It seems like a lot of steps, but it’s actually very easy – I did the above example a few weeks after reading the instructions and without looking at the original article for prompts!



Filed under Misc

27 responses to “Creating Google Maps from Postcode Data

  1. Meic

    This was really useful! Thanks!

  2. Pingback: Changes, lots of changes! | Lisa in the Health Library

  3. Ross Chase

    Thank you very much for this article. Immensely useful!

  4. Great article, long time since I’ve created a Google Map with postcodes and the process is so much easier now.

  5. Graham

    Thanks very much for that it was really useful and very comprehensively explained. Well done.

  6. Peter

    Thank you very much for this, most helpful.

  7. Michael

    Thank you! Worked even easier than described in June 2015.

  8. Karen

    Thank you very much, very well explained, much appreciated

  9. Graham

    Wow just found this and used it. It was excellent. Plotted all my customers postcodes on a map. Will save me so much time. Thank you.

  10. Lisa, you are diamond. What an amazing blog entry this is. It is unusual to look for some information on the web, find something that looks like it might be what you are after and then bingo, 100% spot on. Thank you and congratulations on presenting such a clear and easy to ready blog. Also, thank you to Google, what a service!

  11. Viola

    Very helpful article! Thank you very much.

  12. sharon

    Thank you brilliant article, well done.

  13. Wow. Brilliant article LIsa. Absolutely solved a problem for me at no cost at all! Many thanks indeed for posting it.

  14. This is awesome. Thank you so much for taking the time to post this. Easy to follow and a huge time saver.

  15. Oli

    This was very useful. I was contemplating making some complicated HTTP POST request to the Google Maps API via an MS Access database I’m building for a client – just to produce a one off map. Then I stumbled across this. Perfect!

  16. Reid

    Awesome! What a treat to find something so helpful so quickly. And so easy to follow. Thank you Lisa!

  17. Abbas

    Thanks very much Lisa, this was very helpful though a lot has changed on Google Drive as well as Fusion app. Much appreciated.

  18. S W

    Hello thanks for this just wondering does anyone know if there is the facility for the map to not place pointer but to outline the whole postcode?

  19. Dave Plummer

    Thanks Lisa, this was just what I was looking for!

  20. Pingback: Plotting postcode data on google maps –

  21. Andrew Stevens

    This was a great help. Love the heat map.

  22. Dave

    Much appreciated, just the tool I was looking for – thank you 🙂

  23. Hamid

    Great article. It saved me hours of research, a huge thank you.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s