For one company, read its filings or its registry entry; for a list, enrich the column. In 2022 I mailed 180 “new” accounts and got a furious reply from a procurement lead. Three of them belonged to an existing customer. Two owned each other.
Quick disclosure: I work at CUFinder, so the add-on later is ours. But the free ways to find company subsidiaries come first, because they’re often enough.
Let’s get into it.
📌 TL;DR: To find company subsidiaries for ONE company, the free routes work: the Exhibit 21 list in a US annual report, a registry like Companies House, OpenCorporates for cross-border names, or the company's own brand pages. But 200 accounts at 20 minutes each is over 60 hours. Company hierarchy data stores parent, child, and ultimate-parent links as fields, so one run fills a subsidiaries column for the whole list.
What Counts as a Subsidiary?
A subsidiary is a company that another company controls, usually by owning most of its shares. Four words get confused with it constantly:
- Affiliate: related, but not controlled. Usually a minority stake.
- Division: part of the parent company, not a separate legal entity.
- Branch: an office of the same entity, often abroad.
- Joint venture: a new company that two parents own together.
I’ve already written the definitional piece on what company subsidiaries are, with examples. So read that one for the concepts. This page is about the spreadsheet.
How Do You Find a Company’s Subsidiaries for Free?
Public filings, national business registries, and the company’s own reports. All free, all public.
So can you find company subsidiaries free? Yes, one company at a time. Here’s the honest version of each route.
SEC Filings and the Exhibit 21 List
Companies that file an annual report with the SEC attach a list of their subsidiaries to it. That attachment has a name: Exhibit 21.
It’s a plain list of entity names, usually with the state or country each is organized in. For a US-listed group, that’s the richest free source there is.
To reach it, search the filings yourself with EDGAR full-text search, the SEC’s own database of company filings. Open the latest 10-K (that’s the annual report) and scroll to the exhibit index at the end.
Three catches, though. It covers US registrants only. It lists “significant” subsidiaries, so smaller ones get left off. And it’s a yearly snapshot, so last month’s acquisition isn’t in there yet.
🔍 Did You Know? Companies that file an annual report with the SEC attach a list of their subsidiaries to it as an exhibit. It's free to read through the SEC's own filing search, and most sales teams have never opened one.
National Business Registries
Every country keeps a register of its companies, and many are free to search. In the UK, the government’s Companies House service gives you filings, officers, and accounts for any registered company.
In the US, registration happens state by state: fifty secretary of state databases, one per state.
Here’s the catch that costs the most time. A registry records entities, not always relationships. You’ll find the company. You won’t always find who owns it.
OpenCorporates and Cross-Border Digging
When a group spans countries, tracing names is the whole game. OpenCorporates pulls records from registers worldwide into one search, the best free place to chase an entity name across borders.
But coverage follows what each register publishes. Some countries publish ownership links. Others barely publish an address.
Annual Reports, Brand Pages, and News
For a private group, the fastest free route is often the company’s own website. Check the “our brands” page, the footer, the press releases.
The catch is predictable. Marketing pages show the brands people recognize, and they quietly skip the holding companies that actually own things.
Want the proper reading list? The Library of Congress guide to subsidiaries and branches is the standard one. And let me say this plainly: the library research guides ranking for this question are GOOD. Librarians wrote them, they’re accurate, and with university database access they beat most paid tools for one company.
That’s how to find subsidiaries of a company by hand, and I’ve covered how to find child companies method by method elsewhere. This page picks up where that one stops: at row 50 of your spreadsheet.
Why Doesn’t the Manual Method Scale?
Each company takes 15 to 30 minutes of reading, and account lists have hundreds of rows.
So let’s do the arithmetic out loud, because nobody on this topic does. 200 accounts × 20 minutes = 4,000 minutes. That’s over 66 hours. Nearly two working weeks, for ONE list, before a single email goes out.
Then comes the second problem, and it’s worse. The answer keeps changing. Groups buy, sell, merge, and rename constantly, so a map you build in March is already wrong when the campaign ships in May.
That’s exactly what caught me in 2022. My 180 accounts were “new” according to my spreadsheet. According to the procurement lead who replied, three reported up to a company we’d invoiced for two years, and two of those three owned each other. I made the apology call myself.
📌 Example: My 2022 file: 180 "new" accounts, three of them owned by an existing customer, two of them owned by each other. One mapped column would have caught all five before a single email left the building.
Now I map the corporate family before every campaign. Every single one.
What Is Company Hierarchy Data?
Company hierarchy data is structured parent, child, and ultimate-parent links between company records.
Plain version: instead of 200 unrelated names, you get a shape. This one owns that one. That one reports up to a group you already sell to. And the company at the very top, the one nobody owns, is the ultimate parent.
Why should a revenue team care about corporate structure? Five reasons:
- Deduplicate the account list before anyone builds a campaign.
- Avoid pitching an existing customer’s subsidiary as if it were cold.
- Find whitespace: divisions inside a group that nobody has touched yet.
- Route the right rep to the right entity, not three reps to one buying group.
- Size the group honestly: 200 employees at the child company, 12,000 across the family.
Hierarchy data sits right next to firmographic data: the company-level facts like industry, size, and location that databases hold on every business. And if you run account-based selling, the corporate family tree basically IS your account definition. Get it wrong and two reps work the same buyer without knowing.
Now the honest part: company hierarchy data is opinionated. Providers disagree about ownership thresholds (is 30% control?) and about long-dissolved entities that still sit in a register.
So treat any map as a strong lead, not a legal document. When money or contracts depend on the answer, go read the filing.
How Do You Map Subsidiaries for a List in Google Sheets?
Put your parent companies in one column and run a child-companies enrichment across the range. The tool I use for that is CUFinder, which is my employer. So read this as a walkthrough from the inside, not a neutral review. Step by step:
- Install the add-on. Grab the CUFinder add-on from the Google Workspace Marketplace. New to add-ons? Google’s help page explains how they install and where they show up.
- Copy your API key. Open your CUFinder dashboard and copy the API key from there.
- Enter the key in the add-on. Paste it once and you’re connected.
- Pick the child-companies service. Open the add-on from the Google Sheets menu. It opens as a right panel listing all the enrichment services. Choose Find Child Companies, which takes a parent company and returns the companies underneath it.
- Map columns, set the range, run. Set the input column (your parent companies), the output column (where the subsidiaries land), and the row range (rows 2-181 for my 180-account file). Then run it.
Before you run anything, spend two minutes on input hygiene. It changes the match rate more than any setting does. My pre-run checklist:
- Legal names beat trading names: “Calderwood Group Ltd,” not “Calderwood.”
- A domain disambiguates better than a name: two groups can share a word, never a domain.
- One company per row. Split “Northmoor and Silverfern” into two rows.
- Duplicates removed: Sheets handles this natively under Data → Data cleanup → Remove duplicates.
That second point is the one people skip. If your rows carry names but no domains, fill that column first. Here’s how to find a company website in bulk, and the return trip from a domain back to the company name.
Going the other way? For a parent company lookup, run the same job in reverse (child in, parent out) and keep both columns. That’s how to find the parent company of a subsidiary at list scale.
All of this is B2B data enrichment in its plainest form: you bring the identifiers, the database fills the missing fields. And if your list lives in a CRM export, CSV enrichment does the same job on the file.
Now the limits, because you should know them before you spend credits. Hierarchy coverage is strongest for registered and larger entities. Private groups and fresh acquisitions lag behind reality. Unmatched rows come back empty, results are a snapshot of today, and every run costs credits.
So test five rows first. And when a row stays blank, that’s not a bug; that’s the tool refusing to guess.
A Worked Example: 5 Rows, Before and After
Say your account list opens like this: parent companies in column A, domains in column B, an empty column C waiting for the children. All five groups are made up, by the way:
| A | B | C | |
|---|---|---|---|
| 1 | Parent Company | Domain | Subsidiaries Found |
| 2 | Calderwood Group | calderwoodgroup.com | |
| 3 | Northmoor Holdings | northmoorholdings.com | |
| 4 | Silverfern Industries | silverfernindustries.com | |
| 5 | Bramble Bay Foods | bramblebayfoods.com | |
| 6 | Orrin & Clyde | orrinandclyde.com |
Then I ran it: Find Child Companies, input column B, output column C, rows 2 to 6. A minute later, the same sheet looked like this:
| A | B | C | |
|---|---|---|---|
| 1 | Parent Company | Domain | Subsidiaries Found |
| 2 | Calderwood Group | calderwoodgroup.com | Calderwood Marine, Hartrigg Engineering, Vaneswell Chemicals |
| 3 | Northmoor Holdings | northmoorholdings.com | Pellow Underwriting, Northmoor Asset Services |
| 4 | Silverfern Industries | silverfernindustries.com | Ashcombe Plastics, Redmayne Tooling, Silverfern Pacific |
| 5 | Bramble Bay Foods | bramblebayfoods.com | Tolliver Dairy, Crestmill Bakehouse |
| 6 | Orrin & Clyde | orrinandclyde.com |
Four parents in, ten child companies out. Notice row 6, though.
Orrin & Clyde came back blank, and honestly that’s the row I trust most. It’s a private partnership with no filed subsidiary list and no registry record naming what it controls. So the honest output is nothing at all, rather than a plausible name that walks a rep into a call with wrong information. If that account matters, go read its registry entry by hand. That’s what the free routes above are for.
Then comes the step that would have saved me in 2022. Paste the subsidiary column into a second sheet, one name per row. Then match it against your CRM account list. A VLOOKUP is plenty.
Any name that lights up is a company you already deal with: a duplicate, a customer, or an open opportunity, caught before anyone dials.
💡 Pro Tip: Before any campaign, match your new account list against the subsidiary column. Two minutes of matching beats one apology call to a procurement lead. I've made that call. You don't have to.
→ 180 parent companies → one run → a mapped subsidiary column → a two-minute CRM match → zero apology calls.
The names in column C are still just names, though. Run company enrichment on them to pull industry, size, and location first. And once you can see a full corporate family, the next question is usually “who else looks like this group?” That’s a look-alike company hunt, a different run in the same sheet.
What Mistakes Should You Avoid When Mapping Corporate Families?
Treating subsidiaries as fresh accounts, enriching the header row, and trusting a map that’s six months old.
Each of these is a data quality problem wearing a sales costume. I’ve made most of them personally, so treat this as a scar map:
- Treating a subsidiary as a fresh, unrelated account. It has its own name, its own website, its own reception desk, and a relationship with you the rep knows nothing about.
- Enriching the header row. Start your range at row 2. Otherwise you’ll spend a credit hunting for the subsidiaries of a company called “Parent Company.”
- Using trading names instead of legal entity names. “Bramble Bay” and “Bramble Bay Foods Holdings Ltd” are not equally searchable. Registries and filings index the legal name.
- Assuming the map is permanent. Groups restructure constantly. Re-run the column quarterly, and always before a big launch.
- Confusing a branch or division with a separate company. A division isn’t a company at all, so it will never appear in a registry, and a branch is the same legal entity wearing a local address.
- Never checking the map against your own CRM. This is where the embarrassment lives. The map only pays for itself once you match it against what you already own.
Get those six right and the job takes an afternoon instead of two weeks. Still with me? Good. Here are the questions people actually ask.
FAQ: Finding Company Subsidiaries
How do I find if a company is a subsidiary?
Check three places: its filings, its registry entry, and the footer of its own website. Ownership lines such as “a member of the X group” turn up in small print more often than people expect. For a list, run the check as an enrichment instead.
Are subsidiaries public?
The company itself can be private while its parent is publicly traded. But the relationship is often public anyway, because filings and registries record it. So “private subsidiary” usually means private accounts, not a hidden owner. Disclosure varies by country.
How do I find the parent company of a subsidiary?
Run the lookup in reverse: child in, parent out. Registries and annual filings name the controlling entity, and plenty of companies state it in their own footer. For a column of subsidiaries, a parent company finder fills the list in one pass.
How do I check if a company has any subsidiaries?
For US filers, open Exhibit 21 in the most recent annual report. Everywhere else, start with the national registry and the annual report itself. And beyond a handful of companies, an enrichment run to find company subsidiaries beats reading filings one by one.
Do LLCs have subsidiaries?
Yes. An LLC can own other companies exactly like a corporation can. The disclosure is thinner, though, because private LLCs file far less than public companies do. So expect registry records, news, and the company’s own site to be your sources.
How do I find subsidiaries of a private company?
This is the hardest case, and no provider fully solves it. Work the registry entry, the news archive, and the brand pages on the company’s own website. Then accept the gaps honestly, because private groups aren’t required to publish a subsidiary list anywhere.
How do I find subsidiaries of a non-US company?
Start with the national registry, then move to cross-border databases. Naming conventions differ by country (GmbH, S.A., Pty Ltd), so search the legal suffix as well as the brand name. Group structures usually get filed in the parent’s home country first.
How often does subsidiary data change?
Constantly: acquisitions, disposals, and renames happen every week somewhere. So treat any corporate family map as a quarterly artifact, and re-run the column before a big campaign. A map you built last year describes last year’s group, not this one.
It’s Time to Map the Whole Family
You’ve got the full toolkit to find company subsidiaries now. Filings and registries when one company is the question. An enrichment run when 200 rows are the question. And a two-minute CRM match that keeps you off the apology call.
Picture it: Monday morning, 180 parent companies in column A, one run, and a mapped corporate family before the coffee cools. Every duplicate flagged. Every group sized properly. That’s my pre-campaign routine now, and it started with one uncomfortable phone call.
Subsidiaries are only one column, though. The whole data enrichment in Google Sheets hub covers what to add next: websites, revenue, contacts, all of it. Tell me in the comments: how many rows are in the list you’re staring at right now?
Bad
Okay
Good
Amazing
