Excel Postcodes To Location

In my work with Customer data sometimes it’s useful to get customers’ location and County from their postcodes. Due to variations in how people enter their address, town, city location etc, it can make the data a little messy. However with postcodes there is little variation in how they are entered. Thus it can make a cleaner data set if you use this.

Here’s an excel doc I put together to assist me with this that I thought i’d share. Simply paste your full postcodes in the spreadsheet to see the location and county they are from. Then copy this back into your data.

Just click the link to download it below:

About BeetleJeremy

Spend most of my time working and researching SEO and have an interest in everything Digital. Particularly SEO, PPC and Digital Marketing. But have a particular penchant for doing Magento SEO within our Magento Development Company. Check out my Google + profile:
This entry was posted in Uncategorized. Bookmark the permalink.

One Response to Excel Postcodes To Location

  1. Looking for the same.. Thanks for Sharing..

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>