Create a map based on postal codes


1. Mind the data type

this is an image

A postal code column in a data set can be stored in a text or number column. Keep this in mind when you are joining the postal codes from your Excel file to a postal code boundary file. You are only able to join data sets with the same column type.

2. Make your Excel geocode-ready

this is an image

To make sure the Spotzi Geocoder can process your CSV/Excel well, please create a file where you give as much information as possible. The more information you give the better the Spotzi Geocoder will determine the right location.

3. Check for postal codes starting with a zero

this is an image

Got postal code areas that are starting with a 0? That might cause a problem, because a number column might cut off the first zero. In this case, we recommend to use a text (string) type.

4. Save time with our postal code data

this is an image

Spotzi offers lots of data that is also segmented by postal code. We offer data with more information about demographics, disposable income and consumer behavior. Data you can use to enrich your map based on the same postal code.

5. Analyze postal codes within a certain range

this is an image

Do you only want to visualize the postal code areas that lay within a certain radius of a business location? Use the buffer functionality of our GIS app in combination with our Filter app.

Related blog posts

Access the Free Spotzi Explorer

Gain access to our free catalog of maps and dashboards. Find Postal Codes, learn more about global income differences or just get inspired by our community maps. Spotzi Explorer is our free solution for every marketer, researcher, student and beyond. Available as a stand alone solution and part of our price plans.

Get free access to Spotzi Explorer Read more

Ready to turn your data into insights?

Spotzi’s platform streamlines the process of geomarketing research & analysis by providing you with a one-stop-shop for all of your mapping and location data needs.

Are you ready to take your campaigns to the next level? Contact us to learn more about our Mapping, Profiling, and Targeting plans.

Contact us


Spotzi North America
  • 125-720 King Street West
  • Toronto ON M5V 3S5
  • Canada
Spotzi Europe
  • Joulehof 9
  • 4622 RG Bergen op Zoom
  • The Netherlands