Company Name Normalizer & Deduplicator for CRM
Pricing
from $0.50 / 1,000 results
Company Name Normalizer & Deduplicator for CRM
Normalize messy company names and deduplicate company lists in your CRM, leads or vendor data. Strips Inc, LLC, Ltd and GmbH, splits d/b/a names, fixes caps, punctuation and common aliases (IBM, P&G), and returns a clean name, canonical key, legal form and duplicate group ID per row.
Pricing
from $0.50 / 1,000 results
Rating
0.0
(0)
Developer
UltimateMC
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
10 days ago
Last modified
Categories
Features
Share
Company Name Normalizer & Deduplicator for CRM cleans messy company names and groups the duplicates. It turns "ACME PLUMBING L.L.C.", "The Acme Plumbing Co." and "Acme Plumbing Inc. d/b/a Acme Rooter" into one company, Acme Plumbing, with the same groupId, and keeps the legal form, DBA and former names as separate fields. Use it to dedupe CRM accounts, merge lead lists from different scrapers, match vendors or employers across datasets, or prepare names for enrichment. Click Start with the prefilled 10 names to see the result in a few seconds.
Deterministic, explainable cleaning. Every row shows the steps applied and how it was grouped (exact key, alias, spacing/plural variant or, if you turn it on, typo). It doesn't look companies up in any registry, so two different companies with the same cleaned name share a group: check
groupSizebefore merging records automatically.
What does Company Name Normalizer & Deduplicator do?
- ✅ Removes legal forms worldwide (81 forms: Inc, LLC, L.L.C., Corp, Co, Ltd, LLP, PLC, GmbH, GmbH & Co. KG, AG, S.A., S.A. de C.V., SARL, B.V., N.V., Pty Ltd, Pvt Ltd, K.K. and more) and returns them as
legalForm,legalFormTypeandjurisdictionHint - ✅ Splits DBA, "trading as" and FKA/formerly names into
dbaNameandformerName - ✅ Removes store and location numbers ("McDonald's #1234"), parenthetical notes, leading "The", country qualifiers ("Deel US LLC"), and turns domains into names (acme.com → Acme)
- ✅ Fixes casing for ALL CAPS and all-lowercase input while keeping acronyms (IBM, AT&T) and leaving mixed-case names as written
- ✅ Expands common abbreviations in the match key (Intl, Mfg, Svcs, Assoc, Natl, Mgmt, Bros), so "Acme Intl Mfg" groups with "Acme International Manufacturing"
- ✅ Knows 116 well-known aliases (IBM, P&G, AT&T, GE, HP, 3M, McDonald's...) and accepts your own
- ✅ Groups spacing, punctuation, "&"/"and" and plural variants ("HospiceMD" / "Hospice MD"); optional typo grouping ("Deloite" / "Deloitte") with safety rules
- ✅ Returns every row with
cleanedName,canonicalKey,groupId,groupSize,groupCanonicalName,duplicateOfRow,matchMethod,stepsandflags, or one row per group as a deduplicated list - ✅ Works on plain lists, your own records, or another Actor's dataset (company name field detected automatically, original record copied through)
Who is it for?
- 📇 Sales ops and RevOps teams deduplicating CRM accounts and merging lead lists
- 🧲 Lead-gen agencies combining Google Maps, LinkedIn-style and directory scrapes into one clean list
- 🧾 Finance and procurement matching vendor names across systems
- 📊 Data analysts and researchers joining datasets on employer or company name
- 🤖 Developers and AI agents that need a cheap, repeatable name-cleaning step before enrichment
How to normalize and deduplicate company names
- Click Try for free or Start. The input is prefilled with ten messy names.
- Paste your own names in Company names (one per line), or pass Records or a Dataset ID from another Actor.
- Choose Output: all rows with their group, or one row per group.
- Optional: turn on Also group typos, or add Your aliases.
- Click Start, then download CSV/Excel or fetch the results through the API.
Input example
This is the prefilled input:
{"names": ["Acme Plumbing, LLC","ACME PLUMBING L.L.C.","The Acme Plumbing Co.","Acme Plumbing Inc. d/b/a Acme Rooter","Acme Plumbers LLC","International Business Machines Corp.","IBM","McDonald's #1234","MCDONALD'S CORPORATION","Siemens AG"]}
Clean the company field of a scraper's dataset and output one row per company:
{"datasetId": "YOUR_LEADS_DATASET_ID","nameField": "companyName","outputMode": "onePerGroup","aliases": {"Big Blue": "International Business Machines"}}
Output example
Real output from the prefilled input above (run on 2026-10-21, America/Chicago): 10 names became 5 groups.
| Row | Input | Cleaned | Group name | Group size | Match | Legal form |
|---|---|---|---|---|---|---|
| 1 | Acme Plumbing, LLC | Acme Plumbing | Acme Plumbing | 4 | group representative | LLC |
| 2 | ACME PLUMBING L.L.C. | Acme Plumbing | Acme Plumbing | 4 | exact key | LLC |
| 3 | The Acme Plumbing Co. | Acme Plumbing | Acme Plumbing | 4 | exact key | Co |
| 4 | Acme Plumbing Inc. d/b/a Acme Rooter | Acme Plumbing | Acme Plumbing | 4 | exact key | Inc |
| 5 | Acme Plumbers LLC | Acme Plumbers | Acme Plumbers | 1 | unique | LLC |
| 6 | International Business Machines Corp. | International Business Machines | International Business Machines | 2 | group representative | Corp |
| 7 | IBM | International Business Machines | International Business Machines | 2 | alias | - |
| 8 | McDonald's #1234 | McDonald's | McDonald's | 2 | group representative | - |
| 9 | MCDONALD'S CORPORATION | McDonald's | McDonald's | 2 | exact key | Corp |
| 10 | Siemens AG | Siemens | Siemens | 1 | unique | AG |
"Acme Plumbers LLC" is deliberately not merged with "Acme Plumbing": the words differ, and they may be different businesses (turn on typo grouping to be more aggressive). Two rows in full, untrimmed:
[{"row": 4,"id": null,"inputName": "Acme Plumbing Inc. d/b/a Acme Rooter","cleanedName": "Acme Plumbing","canonicalKey": "acme plumbing","groupId": "g-831b7ef85b","groupSize": 4,"groupCanonicalName": "Acme Plumbing","isFirstInGroup": false,"duplicateOfRow": 1,"matchMethod": "exact key","legalName": "Acme Plumbing Inc.","legalForm": ["Inc"],"legalFormType": "corporation","jurisdictionHint": "US","dbaName": "Acme Rooter","formerName": null,"aliasApplied": false,"steps": ["split d/b/a","removed legal form"],"flags": []},{"row": 7,"id": null,"inputName": "IBM","cleanedName": "International Business Machines","canonicalKey": "international business machines","groupId": "g-02fb16bcc4","groupSize": 2,"groupCanonicalName": "International Business Machines","isFirstInGroup": false,"duplicateOfRow": 6,"matchMethod": "alias","legalName": "IBM","legalForm": null,"legalFormType": null,"jurisdictionHint": null,"dbaName": null,"formerName": null,"aliasApplied": true,"steps": ["alias"],"flags": []}]
How much does it cost to normalize company names?
This Actor uses pay-per-event pricing:
- $0.0005 per output row (one row per name, or one per group in "one row per group" mode)
- a tiny Actor start fee of $0.00005 per run
- plus the small Apify platform usage of the run, paid by you. For the prefilled 10-name example this was about $0.0001 (256 MB, under 4 seconds).
So 1,000 names cost about $0.50 and 10,000 names about $5, plus a few cents of platform usage. Apify lets you set a maximum cost per run.
Use it through the API, integrations or AI agents
- API:
POST https://api.apify.com/v2/acts/ultimatemc~company-name-canonicalizer/run-sync-get-dataset-itemswith your Apify token and the input JSON as the body. Client libraries for JavaScript and Python are on the API tab. - AI agents (MCP): add
https://mcp.apify.com?tools=ultimatemc/company-name-canonicalizerto Claude, Cursor, ChatGPT or any MCP client, so your agent can clean and group a list of companies as a tool. See Apify MCP server. - Chain it after a scraper: pass the
datasetIdof a leads, jobs or Maps scraper run, or trigger this Actor with a webhook. - Automation: connect webhooks, Make, Zapier, n8n, HubSpot exports or Google Sheets from Apify Console.
FAQ
How accurate is the grouping?
On a test of about 6,800 real employer names from public H-1B filings, written in different ways, 99-100% of each company's spelling variants ended up in one group, with about 5 joins of different employers per sample (mostly the same company under a slightly different name). Typo grouping is off by default because it trades precision for recall.
Will it merge two different companies with the same name?
Yes, if their cleaned names are identical ("Acme Plumbing LLC" in Texas and "Acme Plumbing Inc" in Ohio). It has no location or registry data. Use groupSize, your own IDs and other fields before auto-merging.
Does it change how names are displayed?
Only ALL CAPS or all-lowercase input is re-cased. The legalName field keeps the name with its legal form; cleanedName is without it.
Does it look companies up online or use AI?
No. It's deterministic rules plus a built-in alias list. No names are sent to any outside service, and the same input always gives the same output.
Which languages and countries?
Latin-script names. Legal forms cover the U.S., UK, EU, Latin America, India, Australia, Japan and more; accents are kept in the display name and ignored in the key.
Limitations
- No registry or website lookup, so it can't tell apart two companies with identical names, or know that a subsidiary belongs to a parent (unless you add an alias).
- The alias list is curated, not complete: "Big Blue" → IBM needs your alias.
- Typo grouping can join similar but different names ("Computek" / "Computer"); review rows where
matchMethodis "fuzzy typo". - Non-Latin scripts (Chinese, Arabic, Cyrillic) are passed through with minimal cleaning.
Data and privacy
Only company names are processed; no lookups or outside calls. Data is used only during the run and saved only to your own Apify dataset.
Other tools by Ultimate Foresight
- Ad Copy Policy Checker for Meta, Google & TikTok: checks ad text against Facebook, Instagram, Google Ads and TikTok ad policies before you submit.
- H-1B Visa Sponsor Checker & Score for Job Listings: adds Department of Labor H-1B sponsorship history and a 0-100 score to company names or job listings.
- Chain vs Independent Labeler for Google Maps Leads: labels local businesses as chain, franchise or independent.
- YouTube Monetization Checker for Scripts & Titles: pre-checks titles, descriptions and scripts for wording that leads to limited or no ads.
- Etsy & eBay Listing Policy & Banned Item Checker: pre-checks marketplace listings for prohibited items, counterfeit wording and off-platform contact.
- Job Scam Detector & Trust Score for Job Postings: scores job postings 0-100 for scam and ghost-job signals.
- SAM.gov Amendment & Opportunity Change Tracker: shows what changed between versions of a SAM.gov notice: deadlines, set-asides, NAICS and attachments.
- Product Recall Checker for Brands, UPCs & Products: matches your brands, products, UPCs or model numbers against CPSC, FDA and NHTSA recalls.
- App Store & Google Play Listing Policy Checker: pre-checks app names, subtitles and descriptions against Apple and Google Play metadata rules.
- FCC Covered List & Section 889 Bulk Screener: screens FCC IDs and brand names against the public FCC Covered List, with sources and timestamps (screening aid only).
- Green Claims Checker: EU Greenwashing Ban & FTC: flags risky eco-friendly, carbon neutral and recyclable wording under EU, FTC and UK CMA rules.
- Influencer #ad Disclosure Checker: FTC & ASA: flags influencer posts with missing or unclear #ad labels under FTC, ASA/CAP and CMA rules.
- Job Title to SOC Code Mapper with O*NET Data: maps job titles to SOC and O*NET-SOC codes in bulk, with seniority and tech skills found in the posting.
- Shrinkflation Detector for Grocery Price Data: finds smaller packs at the same or higher price by comparing two runs of a grocery scraper, with unit price before and after.
- Fair Housing Listing Checker for Real Estate Ads: flags rental and sale listing wording that may raise Fair Housing Act issues, with HUD sources and rewrite tips (screening aid only).
- Job Ad Discrimination Checker for Job Posts (US): flags age, sex, national origin, citizenship and other discriminatory wording in job posts, with EEOC and DOJ sources (screening aid only).
- Amazon Listing Policy Checker for Titles & Bullets: flags pesticide, FDA and disease claims and Amazon title and bullet rule breaks in bulk, with policy links and fixes.
- Walmart Listing Policy Checker for Titles & Copy: flags promotional phrases, retailer names, URLs, long titles and pesticide or FDA claims in Walmart Marketplace listings, with policy links and fixes.
- TikTok Shop Listing Policy Checker for Products: flags off-platform links, dupe wording, weight-loss, disease and FDA claims and title rule breaks in TikTok Shop listings.
- Supplement & Cosmetic Claims Checker: FDA & FTC: flags disease, drug and 'FDA approved' claims and missing supplement disclaimers in supplement and beauty product copy, with FDA and FTC sources (screening aid only).
- Rental Listing Scam Checker for Craigslist & FB: scores rental listings 0-100 for FTC-listed scam signs like wire or gift card payment, deposit before viewing and rent far below similar listings.
- GTIN, UPC & EAN Barcode Validator (Check Digit): checks UPC, EAN, GTIN-14 and ISBN codes for wrong check digits, lost leading zeros, scientific notation, restricted prefixes and duplicates before a feed upload.
- Fake Review Checker: Incentivized & Duplicates: screens scraped reviews for incentivized or insider wording, copied text, rating bursts and rating/text mismatches named in the FTC 2024 fake-review rule.
- Facebook Marketplace Listing Policy Checker: flags Marketplace listings that may break Meta's Commerce Policies (weapons, vapes, Rx, animals, gift cards, services, counterfeits and more), with policy links.
- Fake Discount Checker: EU 30-Day Prior Price: checks 'was' and strikethrough prices against your own price history for 30-day prior-price, raise-then-discount and wrong-badge issues.
- SMS Marketing Message Checker: STOP & 10DLC: pre-checks SMS marketing texts for segment count, STOP opt-out wording, URL shorteners, SHAFT content and quiet hours.
- Hidden Fee Checker: Hotel, Rental & Ticket Prices: flags headline prices that leave out mandatory resort, service or booking fees under the FTC junk fees rule (16 CFR 464), with sources per finding.
- EU GPSR Listing Checker for Amazon, eBay & Shops: checks listings for the EU GPSR Article 19 online-sale details: manufacturer, EU responsible person, product identifier, picture and warnings.
- Food Allergen Label Checker: US, EU & AU: compares ingredient lists with the 'Contains' statement for US 9, EU/UK 14 and Australian PEAL allergens and flags gaps and conflicting free-from claims.
- Toy Choking Hazard Warning Checker (CPSC): flags toy listings missing the CPSC choking-hazard warnings for small parts, balloons, small balls and marbles, with age-grade checks.
- Textile Fiber Label Checker: Bamboo & Origin: flags 'bamboo' claims that should say rayon, fiber percentages that don't add up, mismatched silk or cashmere titles and missing Made in USA/Imported.
- Prop 65 Warning Checker for Product Listings: flags Prop 65 safe-harbor warnings missing 'WARNING', the P65Warnings.ca.gov link or a chemical name, old short forms, and listed chemicals mentioned with no warning.
- Unit Price Checker for Grocery & Retail Listings: parses pack sizes, recomputes the price per kg, litre or item, and flags missing or wrong unit prices in grocery and retail data.
- Made in USA Claim Checker for Product Listings: flags unqualified 'Made in USA' claims next to imported or foreign-origin details under the FTC rule (16 CFR 323), with sources per finding.
- Subscription Auto-Renewal Disclosure Checker: checks subscription and free-trial offer text for missing renewal, price, billing period and cancellation disclosures under California law and FTC ROSCA.
- Email CAN-SPAM Checker & Unsubscribe Header Test: pre-checks marketing emails for missing unsubscribe links or postal address, misleading subjects and Google/Yahoo one-click unsubscribe headers.
- Energy Certificate Checker for Property Listings: flags EU property ads missing energy certificate details: Germany's GEG §87 items, France's DPE and GES classes and annual energy cost, and the EPBD energy class.
- Nutrition Claim Checker: Low Fat, High Protein: checks claims like low fat, sugar free, high protein and no added sugar against nutrition values with EU per-100 g and US FDA per-serving rules.
- Financing Ad Checker: Truth in Lending Triggers: flags car and retail ads with payment, term or down payment trigger terms but no APR, repayment or lease disclosures (Reg Z, Reg M).
- EU Energy Label Checker for Appliance Listings: flags EU appliance, TV, lamp, phone and tyre listings with a missing energy class, old A+++ classes after the rescale or no label or product sheet.
- Organic Claim Checker: USDA & EU Organic Labels: flags organic food claims that don't fit USDA NOP or EU 2018/848 label rules: seal use, organic percentage, certifier, control code.
- Gluten-Free Claim Checker for Food Listings: checks gluten-free claims against ingredients: wheat, barley, rye or malt, wheat starch statements, ppm over 20 and EU 828/2014 wording.
- Jewelry Claim Checker: Gold, Silver & Lab Diamonds: flags jewelry listings with FTC Jewelry Guides issues: gold without karat, plated items called gold, vermeil and sterling misuse, lab-grown stones called diamond, uncultured pearls.
- Leather Claim Checker: Genuine, Bonded & Vegan: flags 'genuine leather' next to PU, bonded leather without fiber percentage, embossed exotics and vague vegan leather (FTC Leather Guides).
- Pet Food Label Checker: 95%, Dinner & With Rules: checks dog and cat food names against ingredient lists with the AAFCO 95%, dinner, with and flavor rules, plus grain-free and natural conflicts.
- Warranty & Guarantee Claim Checker for Listings: flags 'warranty void if removed' and genuine-parts-only clauses, implied warranty disclaimers, undefined lifetime warranties and money-back guarantees without terms.
Got a wrong merge or a missed duplicate? Open an issue on the Issues tab with the names, and we'll review the rule.