Clean

Standardize legal entity suffixes and strip punctuation across corporate names

Harmonize company name variations, legal suffixes, and capitalization across your account list.

🛡️ Your rows never leave your browser.

Why Onfyt: Distinguishes between corporate suffixes at the end of a company name and words that happen to look like suffixes inside the name.

Interactive Sample Data

id	raw_company
1	Acme Industrial Technologies, INC.
2	acme industrial technologies llc
3	Globex Corporation, Ltd.

How this tool works

Across a B2B sales pipeline, the same company might appear as Acme Corp, ACME Corporation, Inc., acme corp., and Acme. Each variant creates a separate record in a CRM, fragments deal history, and produces inflated account counts in revenue reports. Normalizing company names—lowercasing, stripping legal suffixes like Ltd/LLC/Inc, collapsing repeated whitespace, removing trailing punctuation—collapses these variants into one canonical form before the import step. Normalizing company names requires several coordinated cleanup operations: stripping trailing punctuation like periods and commas before legal suffixes, converting haphazard casing into standard Title Case, and either removing or harmonizing legal entity types. Common entity markers include Incorporated (Inc, Inc.), Limited Liability Company (LLC, L.L.C.), Limited (Ltd, Ltd.), Corporation (Corp, Corp.), and international variants like GmbH, S.A., and Pty Ltd. DataFix applies configurable dictionary rules to detect legal suffixes regardless of casing or punctuation, allowing you to either trim them off completely for clean marketing brand matching or standardize them into canonical corporate representations. Removing legal suffix variants merges customer records that would otherwise split financial balances across separate accounts.

Things that usually go wrong

'Apple Inc' and 'Apple' become the same after normalisation — but 'Apple Records' and 'Apple' also become 'Apple'. Always review the output.
International suffixes (GmbH, S.A., Pty Ltd) are stripped if present in the suffix list.

Edge cases we tested

🧪 Punctuation variations ('L.L.C.', 'LLC.', 'LLC')

Normalized to a single unified representation or cleanly stripped.

🧪 Suffix words in the middle of a name ('Corporation Bank of Ohio')

Preserved intact; only trailing legal markers are modified.

🧪 Multiple stacked suffixes ('Acme Corp, Inc.')

Both redundant suffixes detected and handled without leaving orphaned commas.

Frequently Asked Questions

What suffixes are stripped?

Inc, LLC, Ltd, Limited, Corp, Corporation, Co, Company, GmbH, S.A., Pty Ltd, PLC, and their variants with and without punctuation.

Does this do fuzzy matching?

No — use Find Similar Duplicates after normalising for fuzzy deduplication.

Related tools

Clean

Split Full Name into First and Last

Separate full name columns into dedicated first_name and last_name columns in CSV and Excel spreadsheets.

Open Tool →

Clean

Combine First and Last Name

Merge separate first and last name columns into a single clean full_name column, trimming extra spaces.

Open Tool →

Clean

Remove Duplicate Rows

Eliminate duplicate rows across your entire dataset or based on specific unique key columns.

Open Tool →