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.
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
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
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.
Point it at the postcode column
For a CSV, type the header of the column that holds postcodes, such as
postcodeorgm_postcode. Leave the box blank and every column is searched, which helps when the postcode sits inside a full address field.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.
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.
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:
| Level | Example | Roughly covers | Good for |
|---|---|---|---|
| Area | BL | A large town and its surroundings | Regional splits and territory planning |
| District | BL1 | Part of a town, or a group of villages | Route planning, local mailings, rep patches |
| Sector | BL1 4 | A smaller cluster of streets | Door-to-door drops and checking coverage within one district |
| Full postcode | BL1 4QR | A street or part of one | Addressing 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