Map Extract
Free tool

Group a list by UK postcode area, district or sector

Paste a CSV or a plain list of addresses and the grouper picks out each postcode, tidies it, and counts how many rows fall in each area (BL), district (BL1) or sector (BL1 4). You get a counts table and a copy of your rows with three new columns.

Runs in your browser. Nothing you enter is uploaded.

Eight Greater Manchester prospects, counted by district

This is a short plain list, one business per line, with postcodes typed in different ways and one row that has no postcode at all. With Input has a CSV header unticked, the grouper looks for a postcode anywhere in each line.

Seven rows have a valid postcode, so the shares are worked out of seven. Bolton's BL1 holds three of them, the obvious first stop for a visit or a mailing. The garage without a postcode is listed in red underneath rather than silently dropped.

Input
Ashworth Joinery, 4 Mill Yard, Bolton BL1 4QR
Brookside Vets BL1 8TU
Copperleaf Florist, bl3 2ab
Dene Valley Plumbing, Wigan WN1 1XX
Easton Bakery, WN1 2DD
Fairfield Opticians, M14 5RQ
Greenway Garage (no postcode yet)
Holt & Daughter Solicitors, BL1 1RU
Result
District  Rows  Share  Main post town  Region
BL1       3     42.9%  Bolton          North West
WN1       2     28.6%  Wigan           North West
BL3       1     14.3%  Bolton          North West
M14       1     14.3%  Manchester      North West

No valid postcode in: Greenway Garage (no postcode yet)

How to group your list

  1. Paste the list

    Paste a CSV export with its header row, or switch off Input has a CSV header and paste one address or business per line. Postcodes in lower case or without the space are fine.

  2. Point it at the postcode column

    For a CSV, type the header of the column that holds postcodes, such as postcode or gm_postcode. Leave the box blank and every column is searched, which helps when the postcode sits inside a full address field.

  3. Choose the level

    Area gives the one or two letters (BL, M), District the outward code (BL1, M14) and Sector the outward code plus the first digit of the inward code (BL1 4). Districts suit most sales planning; sectors help inside one town.

  4. Read the counts

    The summary shows total rows, rows with a valid postcode, number of groups and rows with no valid postcode. The table lists each group with its row count, share, the main post town of the area and the region.

  5. Download what you need

    Download counts CSV gives the summary table. Download rows with groups gives your original rows with the tidied postcode and the area, district and sector added, ready to sort or filter in a spreadsheet.

The parts of a UK postcode

Every full postcode splits the same way, so grouping needs no lookup. Using BL1 4QR as the example:

LevelExampleRoughly coversGood for
AreaBLA large town and its surroundingsRegional splits and territory planning
DistrictBL1Part of a town, or a group of villagesRoute planning, local mailings, rep patches
SectorBL1 4A smaller cluster of streetsDoor-to-door drops and checking coverage within one district
Full postcodeBL1 4QRA street or part of oneAddressing only; too fine for counting

Why count prospects by district

A scraped list of trades or shops rarely spreads evenly. Grouping shows where the density really is: a lead list for a wholesaler might have forty cafés in one city centre district and two in each of the outlying ones. That decides which areas are worth a sales day, which get an email first, and where your search was thin and needs another pass.

It is also a quick quality check on a search. If you asked for businesses in Bolton and a fifth of the rows land in M or WN districts, the source returned results outside the area you meant. Spotting that before you export saves you calling or writing to firms you cannot serve.

Questions people ask

What is the difference between a postcode district and a sector?

The district is the outward code, the part before the space, such as BL1. The sector adds the first character of the inward code, so BL1 4 is one sector inside the BL1 district. Districts usually cover part of a town; sectors are smaller and are often used to plan door-to-door leaflet drops.

Can it find the postcode inside a full address?

Yes. With the CSV header option off, each line is searched for something shaped like a UK postcode. With a CSV, leave the column box blank and every cell in the row is searched. Lower case and missing spaces are tidied, so ls16dt becomes LS1 6DT before it is grouped.

Why does every district in an area show the same town?

The town shown is the main post town of the postcode area as a whole, worked out from the letters alone. It is a convenient label, not a lookup, so outlying districts may actually be nearer another town. For the local authority of each row, use a postcode lookup service.

What happens to rows without a postcode?

They are counted in the summary as having no valid postcode and listed under the table, so you can fix or remove them. In the rows download they stay in place with the new postcode columns left empty, which keeps your file the same length as the one you pasted.

Where your data goes

Grouping is worked out from the postcode letters and digits on this page. No postcode or business name is sent to a lookup service, and both downloads are created in your browser.

Checked against the tool on

Top