Import Excel: postcode territories
Use this panel when a spreadsheet already tells you which postcode belongs to which territory. The data is matched to polygons in the selected map.
Watch tutorial video Opens YouTube · some videos show an earlier layout
Postcodes column
Copy the postcode column from Excel and paste it here, one postcode per row and without a heading. Use codes that exist at the selected map’s level. Keep codes such as leading-zero ZIP codes as text in your spreadsheet.
Zone names column
Paste the matching territory names in the same row order. Repeated names put several postcodes into the same territory. Leaving the entire column blank uses Zone 1. For a meaningful multi-territory map, supply a name for every postcode.
Clear each column
The Clear button below a column empties that input. It does not act as a general “clear my map” command. Clear and replace both columns together when importing a different table.
Reverse order
Reverses both columns together and updates the map from the reversed data. It is useful for changing the order in which names appear in the key. It is an action on the import, not just a cosmetic sort of one text box.
Colour range
Choose the family of colours to use when the importer assigns colours to territories, or choose Random. Related shades can suggest a series, but clearly different colours are usually better for unrelated sales teams.
Import to map
Processes the paired columns and colours the matching polygons. Check any feedback and inspect the result: a district code cannot create missing sector geometry. Save a separate version before importing over a map you may need again.
Import with colours
Opens the larger dialog with a third column for your chosen colours and an optional table for extra key text. Use it for a repeatable colour scheme across several maps.
Sample data
Open the sample chooser to see prepared examples. Selecting a sample imports it immediately, so save your current work before experimenting. Samples are useful for learning the required data structure.