Put the postcode in its own column
Kanon Maps reads a single column of postcodes from your file. That column can be called anything you like, but the postcode has to stand on its own — it can't be mixed in with the rest of the address.
The one rule
Each cell in your postcode column should contain a postcode and nothing
else — for example SW1A 1AA.
The column doesn't have to be called “Postcode”; you'll point Kanon Maps
at the right column during the import. What matters is that the postcode is on its
own, not tucked inside a longer piece of text.
The most common mistake
Many address lists keep the whole address in a single column, like this:
| Name | Address |
|---|---|
| Jordan Ellis | 12 High Street, Anytown, AB12 3CD |
Kanon Maps can't pull the postcode out of a full address like that. It checks each
cell as a whole, and 12 High Street, Anytown, AB12 3CD
isn't a valid postcode — so every row would be rejected.
The same file works perfectly once the postcode has its own column:
| Name | Street | Postcode |
|---|---|---|
| Jordan Ellis | 12 High Street, Anytown | AB12 3CD |
Splitting the postcode out
If your postcodes are currently mixed into an address column, you have a few ways to separate them:
- Export it separately. Most CRMs and membership systems store the postcode as its own field, even when they display the address as one block. When you export, look for an option to include a dedicated postcode column.
- Use Excel's Text to Columns. If each address is separated by commas, select the column, choose Data → Text to Columns, split on the comma, and the postcode will land in its own column.
- Copy them by hand. For a short list, it's often quickest to add a new column and type or paste each postcode into it.
Whichever route you take, only the postcode column is ever read — and, for the cleanest and most private import, that's the only column you need to keep. See preparing your spreadsheet for how to trim a file down to just its postcodes.
What happens to the rest
Blank postcode cells are skipped, and anything that isn't a valid UK postcode is listed back to you after the import so you can correct it and re-upload just those rows. Every other column in the file is ignored.