Company legal form extractor: split Inc, LLC, GmbH and Ltd into their own column
In short: Upload a list, pick the company column, and the legal form and its usual region go into new columns while the name is left clean. Limit: Only the end of a name is read; a form in the middle of a name is left alone.
Upload a CSV or .xlsx file, or paste it with a header row, and pick the company column. The legal form at the end of each name, such as Inc, LLC, Ltd, GmbH or Pty Ltd, is moved into a Legal form column with the region where it is usually used, and the name is left without it. Names with no form are left alone. Download the file.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
Five example companies lose their legal form into a column: Acme (Inc), Müller (GmbH), Globex (Pty Ltd) and Hooli (LLC); Initech has none.
- Names split
- 4
- Forms found
- 4
- Blank cells
- 0
What this means for you
A legal form does not show which addresses exist; a check does.
- Inc, LLC, Ltd, GmbH
- Pty Ltd, SA, BV, AB
- Usual region shown
- At least one word kept
- Legal form
- Company
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Company names split? Check the addresses before you send.
- Download the file, or use the check button under the result, which carries its addresses across.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I extract the legal form from company names?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Pick the company column; a header such as Company or Organization is picked for you.
- Choose whether Co and Company count as legal forms, and whether to replace the cell or add a column.
- Check the forms found and the examples, then download the file.
Example
- You enter
- Five companies: Acme Inc., Müller GmbH, Globex Pty Ltd, Initech and Hooli Corporation LLC, with Co and Company not counted.
- You get
- 4 names split: Acme (Inc), Müller (GmbH), Globex (Pty Ltd) and Hooli (LLC); Initech has no legal form. Hooli also lost Corporation, as the LLC came off first.
- Limits
- Runs in your browser; nothing is uploaded. The region is where a form is usually used, not where the company is.
What does it add to the file?
A Legal form column with the form it found, such as Inc, LLC or GmbH, and a Region of form column with where that form is usually used. By default a column with the name left over, with no legal form, is added beside them; you can replace the company cell instead.
Only the end of a name is read, and at least one word of the name is always kept, so a company called Limited or Inc is not emptied.
How is this different from cleaning company names?
The company name cleaner strips suffixes to make a name read well in an email. This tool keeps the legal form as data. It is useful for splitting a list by entity type, spotting which companies are probably in Germany or Australia, or checking a vendor list.
Run both if you need a clean name and the form: extract here, then clean casing with the cleaner.
Why is the region only a hint?
A form shows where a company was registered, not where it sells or where the contact lives. Ltd is used in the United Kingdom, India, Ireland, Nigeria and elsewhere, so the region reads United Kingdom and others. Treat it as a way to sort, not a fact.
Short forms that are also ordinary words, such as AS, AB and PC, count only when typed in capitals.
Who uses this tool, and for what?
- Sales operations
- Split a list by entity type, such as GmbH companies only, before building a campaign.
- Agencies
- Pull the legal form into a column for a client who needs it in their CRM.
- Procurement teams
- Check which vendors are Pty Ltd and which are Inc in an exported supplier list.
What can’t this tool tell you?
- Only the end of a name is read; a form in the middle of a name is left alone.
- The region is where a form is usually used, not where the company or contact is.
- Forms not in its list are not recognised.
- Only the first sheet of a workbook is read.
Common questions
- Which legal forms does it know?
- Inc, LLC, LLP, LP, Corp, Ltd, PLC, Pty Ltd, Pte Ltd, Sdn Bhd, GmbH, AG, UG, SA, SAS, SARL, SRL, SpA, BV, NV, AB, AS, ApS, Oy, Sp. z o.o., s.r.o., KK and several more.
- Will it empty a name that is only a legal form?
- No. At least one word of the name is always kept, so Limited or Inc stays as typed.
- What about Co and Company?
- They are off by default because many brands include them. Tick the option to treat them as legal forms.
- Does the region show where the contact is?
- No. It shows where the form is usually used, so treat it as a hint for sorting.
- Are dots and commas handled?
- Yes. Inc., L.L.C. and Co., Ltd. are read the same as Inc, LLC and Co Ltd.
- Is my file uploaded?
- No. It is read in your browser and goes nowhere.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.