One scruffy address, tidied
This is the kind of address that arrives from a web form or a quick copy and paste: all lower case, abbreviations, a county and a postcode with no space.
With the default settings the formatter capitalises each line, expands st to Street, recognises Stockport as the post town and Cheshire as a county, drops the county (Royal Mail does not need it when the postcode is present) and spaces the postcode. You also get the one-line version for a CRM field.
unit 7, the old tannery 22 bridge st stockport cheshire sk14ab
Unit 7 The Old Tannery 22 Bridge Street STOCKPORT SK1 4AB One line: Unit 7, The Old Tannery, 22 Bridge Street, STOCKPORT, SK1 4AB
Using the formatter
Pick a mode
One address shows an envelope layout, a single line and a breakdown of the parts. Many addresses takes one address per line, or blocks separated by a blank line, and builds a table.
Paste the text
Commas, line breaks or a mix of both are fine. A trailing UK, United Kingdom, England, Scotland, Wales or Northern Ireland is recognised as the country.
Set the options
Choose whether to expand Rd, St, Ave and similar, put the post town in capitals, keep the county and keep the country line. In many mode you can also split each address into building, number, street and locality columns.
Check the warnings
A missing postcode, a postcode in the wrong shape, no post town, or more than three lines before the town are flagged. In many mode the count of addresses with warnings appears above the table.
Copy or download
Copy the envelope block or the single line, or in many mode copy one address per line or download a CSV with address lines, post town, county, postcode and country.
What changes and what does not
| Input | Output | Rule |
|---|---|---|
| 12 high st | 12 High Street | Street types expand only as the last word of a line |
| mill ln | Mill Lane | Ln, Rd, Ave, Cres, Cl, Gdns, Terr and others expand |
| riverside ind est | Riverside Industrial Estate | Ind, Est, Hse, Bldg and Apt expand anywhere |
| st marys ave | St Marys Avenue | St at the start of a name is left alone |
| stockport | STOCKPORT | The line before the postcode is taken as the post town |
| sk14ab | SK1 4AB | The postcode is checked for UK shape and spaced |
| newcastle upon tyne | Newcastle upon Tyne | With capitals off, small words such as upon stay lower case |
Where it can go wrong
The formatter follows fixed rules; it does not look anything up. A county written in full, such as Cheshire or West Yorkshire, is recognised and can be dropped. An abbreviation such as N Yorks is not, so in 9 albert rd, harrogate, n yorks, hg1 1aa it is taken as the post town and Harrogate becomes a locality line. Write counties out in full, or delete them before pasting.
Because nothing is checked against the Postcode Address File, the formatter cannot tell you whether the address exists or whether the post town really belongs to that postcode. For a lead list, that check matters more than neat capitals: a business with a registered office in one town and a shop in another will look tidy either way.
Questions people ask
What is the correct way to write a UK address?
Royal Mail asks for the recipient, then the building and street lines, the locality if there is one, the post town in capitals and the postcode on its own final line. A county is not needed when the postcode is present. This formatter produces that layout and lets you keep the county or country if your own system expects them.
Can I format a whole spreadsheet of addresses?
Yes. Switch to many addresses and paste one address per line, or separate multi-line addresses with a blank line. Up to 5,000 are formatted at once. Download the CSV for address line columns, or tick the split option for separate building, house number, street and locality columns before downloading.
Does it check that the address exists?
No. Formatting runs on fixed rules in your browser and nothing is matched against Royal Mail's address file. It flags a missing or badly formed postcode, but a correctly shaped postcode on the wrong street will pass. Use a postcode lookup if you need the local authority or coordinates.
Why is my county showing as the post town?
The formatter recognises counties written in full from a built-in list. Abbreviations such as Lancs, N Yorks or Glos are not on it, so the line is read as the town. Spell the county out or remove it, then format again, and the post town line will be the one before the postcode.
Where your data goes
Addresses are reformatted by rules that run in this browser tab. Nothing you paste is looked up or uploaded, and the CSV is put together on your device.
Checked against the tool on