Map Extract
Free tool

Clean up company names for emails, CRMs and mail merges

Registry exports shout in capitals, scraped lists add Ltd. with a stray full stop, and "Hi HOLLIN BAKERY SUPPLIES LIMITED" is no way to open an email. Paste a column of company names and get each one tidied for the job in hand, with a note of what changed and a flag on names that turn out to be duplicates once cleaned.

Runs in your browser. Nothing you enter is uploaded.

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.

Input
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
Result
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

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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

JobPresetHollin Bakery Supplies Limited becomes
Email greeting or subject lineFor email greetingsHollin Bakery Supplies
CRM account nameFor a CRMHollin Bakery Supplies Ltd
Contracts, invoices, formal lettersLegal namesHollin Bakery Supplies Limited
Keep the wording, just tidy itTidy spacing and case onlyHollin 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

Top