# How to colour a postcode map from a spreadsheet

Official GBMaps guide for the classic map maker. VectorMaps has a different interface.

Source: https://www.gbmaps.com/mcs/map-help.php?topic=spreadsheet-recipe
Updated: 2026-09-29

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](https://www.youtube.com/watch?v=QXFxOiq1m-A)

Some videos show an earlier layout. The written instructions below describe the current controls; this is a guide, not a video transcript.

## 1. Prepare 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.

[Open this step](https://www.gbmaps.com/mcs/map-help.php?topic=spreadsheet-recipe#spreadsheet-recipe--prepare)

## 2. 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.

[Open this step](https://www.gbmaps.com/mcs/map-help.php?topic=spreadsheet-recipe#spreadsheet-recipe--import)

## 3. 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.

[Open this step](https://www.gbmaps.com/mcs/map-help.php?topic=spreadsheet-recipe#spreadsheet-recipe--inspect)

## 4. 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.

[Open this step](https://www.gbmaps.com/mcs/map-help.php?topic=spreadsheet-recipe#spreadsheet-recipe--finish)

## Related guides

- [Import Excel: postcode territories](https://www.gbmaps.com/mcs/map-help.php?topic=excel)
- [Excel import with your own colours](https://www.gbmaps.com/mcs/map-help.php?topic=excel-colours)
- [Get a spreadsheet ready for import](https://www.gbmaps.com/mcs/map-help.php?topic=import-checklist)
- [Save, open & keep a separate copy](https://www.gbmaps.com/mcs/map-help.php?topic=save)