Example: names from a registry export and a scraped list
A web agency merged a Companies House export with names collected from websites and wanted a version safe to drop into email greetings. Using the For email greetings preset, capital letters were fixed (including the Mc in McKenzie), the legal suffixes were removed, the trading name was used where a t/a was given, and a leading The and a place in brackets were dropped.
The fourth line turned out to be the same business as the first once cleaned, so it was marked as the same as line 1. The agency kept the original names in a separate column for anything formal.
HOLLIN BAKERY SUPPLIES LIMITED pike & daughter joinery ltd. Northgate Dental Care Ltd t/a Northgate Smiles Hollin Bakery Supplies Ltd The Oakfield Veterinary Centre (Bury) Ltd McKENZIE & SONS PLC brightline bookings llp
Before After What changed HOLLIN BAKERY SUPPLIES LIMITED Hollin Bakery Supplies "LIMITED" removed, capitals fixed pike & daughter joinery ltd. Pike & Daughter Joinery "ltd" removed, capitals added Northgate Dental Care Ltd t/a Northgate Smiles Northgate Smiles trading name used Hollin Bakery Supplies Ltd Hollin Bakery Supplies same as line 1 The Oakfield Veterinary Centre (Bury) Ltd Oakfield Veterinary Centre (Bury) "Ltd" removed, "The" removed McKENZIE & SONS PLC McKenzie & Sons "PLC" removed, capitals fixed brightline bookings llp Brightline Bookings "llp" removed, capitals added
Cleaning a list
Pick what the names are for
For email greetings strips names down to how people say them. For a CRM keeps a short Ltd and both trading and legal names. Legal names writes Limited in full and keeps the legal name. Tidy spacing and case only changes nothing else.
Paste the names
One per line, straight from a spreadsheet column; up to 50,000. If you paste several columns, only the first is used.
Fine-tune the options
Legal suffix (remove, Ltd, Limited or as written), capitals (fix, Title Case or keep), trading as (keep both, trading name or legal name), and whether to drop a leading The or a place in brackets.
Check what changed
Figures show names, changed, duplicates after cleaning and unchanged. The table shows before, after and what changed. Tick Hide duplicates to keep one of each.
Export
Download CSV, Excel or JSON with original, cleaned, changes and duplicate-of line, or copy the cleaned names to paste back beside the originals.
Which preset for which job
| Job | Preset | Hollin Bakery Supplies Limited becomes |
|---|---|---|
| Email greeting or subject line | For email greetings | Hollin Bakery Supplies |
| CRM account name | For a CRM | Hollin Bakery Supplies Ltd |
| Contracts, invoices, formal letters | Legal names | Hollin Bakery Supplies Limited |
| Keep the wording, just tidy it | Tidy spacing and case only | Hollin Bakery Supplies Limited |
Capitals are harder than they look
Fix capitals does more than turn everything into Title Case. It keeps short words such as and or of in lower case, gets Mc names right (McKENZIE becomes McKenzie) and keeps some common abbreviations, such as IT, in capitals. It cannot know everything: ABC PLUMBING comes out as Abc Plumbing and MACDONALD as Macdonald. Look over the changed rows, particularly initials and brand names deliberately written in an unusual way.
The duplicate flag only catches names that become identical after cleaning. For near matches with typos or different wording, such as Harbour Cafe and Harbor Café, use the fuzzy name de-duplicator afterwards.
Questions people ask
How do I remove Ltd from company names in Excel?
Formulas such as SUBSTITUTE work for one exact spelling but miss variations like LTD., Limited, plc and LLP, and do nothing about capitals. Paste the column here instead, choose Remove Ltd, PLC, and paste the cleaned column back next to the original. The export keeps the original beside the cleaned version.
Should I use the legal or the trading name in a cold email?
Use the name the business uses with customers, usually the trading name shown on its website and signs. Opening with a full legal name such as Northgate Dental Care Ltd when everyone knows it as Northgate Smiles reads like a database talking. Keep the legal name for contracts and invoices.
What does t/a mean in a company name?
Trading as. It joins a legal name to the name the business trades under, such as Northgate Dental Care Ltd t/a Northgate Smiles. The cleaner recognises it and lets you keep both, use only the trading name or use only the legal name.
Will it merge duplicate companies?
It marks names that become exactly the same after cleaning and can hide the extra copies, but it does not merge the rows of your spreadsheet. Use the duplicate-of line number in the export to decide which record to keep, then remove the others in your own file.
Where your data goes
Company names are cleaned by rules running in your browser. The list is not uploaded or saved.
Checked against the tool on