GBMAPS.COMThe map maker’s handbook

Bring in your data

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 the related tutorial Opens YouTube · some videos show an earlier layout
Import Excel: postcode territories — current GBMaps controls 1 2 3 4 5 6 7 8
The current panel, with its options expanded where useful. Select a numbered circle to read its explanation.
  1. 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.

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

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

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

  5. 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.

  6. 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.

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

  8. 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.

Panel detail

Select a number to read its explanation. For small text, choose Actual size and scroll across the picture.