Download Now

How to plot several postcodes on Google Maps

Caroline Robertson
posted by Caroline Robertson on July 16, 2018
Find me on: Caroline Robertson on LinkedInCaroline Robertson on Twitte

Sometimes we come across a handy tool or top tip that can be quite useful, especially when used in conjunction with your Infor CRM system. Here’s one we came across recently – the ability to plot several UK postcodes on to Google Maps. So if you’re planning to visit your prospects and/or customers, or if you just want to know where a group of addresses are located, then try using this tool – and it’s free too! Please note though that this tool it’s not supported – it’s simply something we liked and wanted to share with you.

Plotting your UK postcodes onto Google maps

Infor CRM comes with Contour Proximity Search (from 8.4 Update 4 upwards), which you can use to view contacts or accounts geographically. However, it currently requires a Google API key (which you have to purchase) in order to use it. Infor are investigating whether they can include the Google API in a future update of Infor CRM. In the meantime, you can use this free tool to plot your UK postcodes onto Google maps.

To start with, go to your Infor CRM Accounts or Contacts list and use a layout that includes the Postal Code column – for example:

Next, click on Export in the Common Tasks pane:

Note: The more records you include, the longer the export and plotting will take, so you may want to use a subsection of data.

Now, copy the postcodes from the Excel spreadsheet and paste them into the Postcodes box on this website: https://www.doogal.co.uk/BatchGeocoding.php

Then, click on the Geocode button and you’ll see the address pins on the map. It may look something like this:

It’s a simple little tool, but sometimes simple is the best… Go on, give it go!

 

  • Leave a Reply

    About Collier Pickard

    Collier Pickard has been trading since 2004. The core team, however, has been together for more than 20 years – which means we have a great deal of experience as an independent CRM consultancy.

    Head Office

    Collier Pickard Limited
    The Old Calf House
    Chevening Road
    Sundridge
    Kent
    TN14 6AB
    United Kingdom

    t: +44 (0)1959 560410