Advanced marker import: every column
Choose a CSV file or paste an Excel table into the Postcodes box. You can also paste the columns individually. Up to 500 rows are supported; CSV files must be smaller than 2 MB.
Watch tutorial video Opens YouTube · some videos show an earlier layoutSee it on the map
Real map artwork · example settings
Load a CSV / Download sample CSV
The sample provides the expected column order. CSV files may have a recognised heading row; paste separate columns without headings. Loading a file fills the dialog for review before Import to map. Multi-line spreadsheet cells are joined with spaces.
Postcodes and Labels
Use a full UK postcode on each row and its matching label beside it. Postcodes are required; labels can be blank. A whole tab-separated Excel table pasted into Postcodes is spread across the columns.
Text size
Sets the size for each marker, from 0.1 to 100. A blank setting uses 5. Enter one value on its own to use it for all postcodes, or supply one value per row for different sizes.
Callout length
Accepts 0 to 500; the default is 10. Zero hides the callout line. Use a larger value to separate a label from a dense cluster of locations.
Text colour and Box colour
Use a colour name, a supported palette name such as teal400, or a hex value such as #E8AC25. Blank settings use black text and a white box. One colour value can apply to all rows.
Position and Callout
Position accepts above or below. Callout accepts line or arrow. Defaults are above and line. These control the marker’s annotation, not the postcode coordinates.
London inset
Use auto to detect London postcodes, true to use the inset, or false to use the main map. The legacy numeric forms 1 and 0 are also accepted. Make sure the London inset is visible if you choose to put markers there.
One value or a complete column
An optional column can contain one shared value or one value for every postcode row. Other column lengths are rejected so rows do not silently shift. Blank optional cells use the defaults. Read the status message if a value or row needs correcting.
Show/hide, download and delete
Open Manage marker boxes on this map. Show/hide changes visibility and Delete all markers from map removes the collection. Download your marker data exports the current column contents, which can include edits you have not imported yet. Clear columns only empties the draft fields.
Import to map / Close / Clear columns
Import to map validates and replaces the current markers with the imported collection. Check any unavailable postcode results. Close leaves the current artwork alone if you have not imported; it also stops an in-progress import. Clear columns clears the draft fields, not the markers already on the map.