The Scenario
You are a data analyst. The data warehouse join is scheduled for Friday. You have an Excel workbook with 600 company names on the CRM Export tab, entered by sales reps in various formats — abbreviations, misspellings, missing legal forms.
The join is failing on 38% of rows because the sales-entered names do not match the Russian registry strings.
The slow version of this week:
- Sort the list and identify obvious duplicates
- Look up each ambiguous name on the FTS registry site
- Copy the canonical name and INN
- Go back to the workbook, find the right row, paste
- Repeat for 600 entries over two days
- Deliver Friday afternoon, after the data warehouse team needed the file.
The fast version is one prompt and the canonical names are in the workbook before noon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the company name column on the CRM Export tab, calls DaData's company suggestion endpoint for each row, and writes the canonical legal name and INN back.
Open the SheetXAI sidebar and type:
For each company name in column A of the CRM Export tab, use DaData to suggest the closest official Russian company match and write the canonical legal name into column B and the INN into column C. If DaData returns multiple matches, use the highest-confidence result. If no match is found, write "NOT FOUND" in column B.
SheetXAI reads column A, calls DaData's suggest-party endpoint for each row, and writes two standardized columns back. All 600 entries resolved to registry names and INNs in one pass.
What You Get
Two new columns with authoritative registry data on the CRM Export tab:
- Column B — canonical legal name from the FTS registry (ООО, АО, ПАО, ИП in full)
- Column C — INN for the matched entity
NOT FOUND rows are explicit so ambiguous entries are flagged rather than matched to the wrong company.
What If the Data Is Not Quite Ready
A sales-entered company list has patterns that complicate the lookup. SheetXAI handles them in the same prompt.
When the column mixes legal entity names and individual entrepreneur names
Some rows are legal entities (ООО, АО), others are individual entrepreneurs (ИП Surname).
For each entry in column A of the CRM Export tab, use DaData to suggest the best match. If the result is an individual entrepreneur, write the full ИП name into column B and the ОГРНИП into column C. If it is a legal entity, write the legal name into column B and the INN into column C.
When you want to flag low-confidence matches for manual review
Some entries are ambiguous and even DaData's top result may be wrong.
For each company name in column A of the CRM Export tab, use DaData to find the closest registry match and write the canonical name into column B and the INN into column C. If DaData's confidence score is below 0.7, write "LOW CONFIDENCE — REVIEW" in column D. Otherwise leave column D blank.
When some rows already have an INN from a prior enrichment
Some rows already have the INN in column C. You only want to resolve the rows where column C is blank.
Skip any row in the CRM Export tab where column C already contains a value. For all other rows, use DaData to resolve the company name in column A to a canonical legal name in column B and INN in column C.
When you need the resolution plus a deduplication summary for the analytics lead
After canonicalization, some entries will resolve to the same company. The analytics lead needs unique entity counts before building the join.
For each company name in column A of the CRM Export tab, write the canonical legal name into column B and the INN into column C using DaData. Then create a new sheet called "Join Analysis" with: total rows, number of unique INNs in column C, number of NOT FOUND results, and the top five companies by frequency in column A.
The pattern: the standardization and the deduplication analysis happen in the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with messy company names, then ask it to resolve them to canonical registry names using DaData. The DaData integration is included in every SheetXAI plan. For related workflows, see how to enrich supplier INNs in Excel or the DaData in Excel overview.