How to colour a postcode map from a spreadsheet
Use Import Excel when your spreadsheet lists postcode areas, districts or sectors beside territory names. Matching polygons receive the territory colours and the map key is built for you. For numerical sales or population figures, use Additional Data or Heat Maps instead.
Watch tutorial video Opens YouTube · some videos show an earlier layoutPrepare a clean table
Use one row per postcode polygon with its territory name beside it. Remove headings from the copied selection. Check that the postcode level matches the map and that the names are consistent.
Choose automatic or supplied colours
Use Import Excel for automatic colours. Use Import with colours if the spreadsheet already contains the desired colour names. Keep all columns aligned.
Inspect the result
Compare a few known territories against the spreadsheet. Investigate unexpected extra key entries or blank areas before changing the design. The key should represent the intended groups.
Prepare the page
Add a title, make the key readable and choose useful map details. Hide unassigned areas if only the imported territories should be shown. Save with a meaningful name and export the required format.