The Scenario
You are an accounts payable manager. Payment approval is on Thursday. You have an Excel workbook with 300 supplier INN codes on the Vendors tab from incoming invoices this quarter.
Finance policy requires verified counterparty data before any payment is released: legal name, registered address, and active/inactive status. Your controller blocked the last two payment batches because the list was not verified.
The slow version of this week:
- Open the DaData web interface
- Paste each INN one at a time
- Copy the legal name, address, and status
- Paste them into the workbook
- Repeat 300 times
- Paste the wrong name into two rows at row 183 and have to start over.
The fast version is one prompt and the workbook is enriched before the morning standup.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the INN column on the Vendors tab, calls DaData's party lookup for every row, and writes the registry data back.
Open the SheetXAI sidebar and type:
For each INN in column A of the Vendors tab, use DaData to look up the company in the Russian tax registry and write the legal name into column B, the registered address into column C, and the active/inactive status into column D. If DaData returns no match for an INN, write "NOT FOUND" in column B and leave columns C and D blank.
SheetXAI reads the INN column, calls DaData for each row, and writes the enriched data back. All 300 rows done in minutes.
What You Get
Columns B, C, and D populated with official registry data for every supplier:
- Column B — full legal entity name from the FTS registry
- Column C — registered legal address
- Column D — active or inactive status
"NOT FOUND" rows are explicit. Any INN that DaData cannot resolve is flagged immediately. No unknown supplier slips through to approval.
What If the Data Is Not Quite Ready
Supplier lists pulled from invoices have formatting inconsistencies. SheetXAI handles them in the same prompt.
When some INNs have formatting issues
Some entries have leading zeros stripped, extra spaces, or OCR characters.
Before looking up each entry in column A of the Vendors tab, strip spaces and non-numeric characters, and pad to 10 digits with leading zeros if shorter. Then run the DaData party lookup and write results to columns B, C, and D.
When you need to flag inactive suppliers before payment
You want the enrichment, but inactive suppliers need a hold flag visible to the controller.
For each INN in column A, use DaData to fetch the legal name, address, and status into columns B, C, and D. In column E, write "HOLD — INACTIVE" if the status is inactive and "OK" if active.
When you only need to re-check new rows
A previous run already enriched 200 of the 300 rows. You added 100 new suppliers this week.
Only process rows in the Vendors tab where column B is empty. For those rows, run the DaData party lookup using the INN in column A and write results to columns B, C, and D. Leave rows that already have data in column B untouched.
When finance also needs OKVED2 classification per supplier
The compliance team needs the primary business activity code alongside the registry data.
For each INN in column A of the Vendors tab, use DaData to fetch the legal name into column B, registered address into column C, status into column D, OGRN into column E, and the primary OKVED2 code and description into columns F and G. Mark "NOT FOUND" in column B for any INN that returns no result.
The pattern: the enrichment, the flags, and the extended field pull all come from one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with Russian company INNs, then ask it to enrich the rows with registry data from DaData. The DaData integration is included in every SheetXAI plan. For related workflows, see how to standardize company names in Excel or the DaData in Excel overview.