The Scenario
You are a procurement manager at a company with Kazakhstan operations. The legal team needs the vendor list by end of week for contract review. You have an Excel workbook with 80 KZ supplier BINs on the KZ Vendors tab from purchase orders and emails this quarter.
Legal requires official company name, director name, registered address, and status for every supplier before contracts can be reviewed.
The slow version of this week:
- Open the Kazakhstan business registry site
- Search each BIN one at a time
- Copy the company details
- Paste them into the workbook
- Repeat 80 times across two days
- Deliver Thursday afternoon, too late for the legal team's Wednesday review slot.
The fast version is one prompt and the enriched workbook is ready the same morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the BIN column on the KZ Vendors tab, calls DaData's Kazakhstan party lookup for every row, and writes the company details back.
Open the SheetXAI sidebar and type:
For each Kazakhstan BIN in column A of the KZ Vendors tab, use DaData to fetch the company details and write the legal company name into column B, the director name into column C, the registered city into column D, and the active/inactive status into column E. If DaData returns no result, write "NOT FOUND" in column B.
SheetXAI reads the BIN column, calls DaData's KZ lookup for each row, and writes four enriched columns back. All 80 suppliers before lunch.
What You Get
Four enriched columns for every KZ supplier in the workbook:
- Column B — official legal company name from the Kazakhstani registry
- Column C — director or signatory name on record
- Column D — registered city
- Column E — active or inactive status
NOT FOUND rows are explicit so the procurement team can chase the supplier for the correct BIN before legal review.
What If the Data Is Not Quite Ready
Supplier BINs collected from emails and purchase orders have inconsistencies. SheetXAI handles them in the same prompt.
When BINs have formatting characters from copy-paste
Some BINs have spaces or dashes from email formatting.
Before running the DaData lookup, strip all non-numeric characters from each entry in column A of the KZ Vendors tab. Then fetch the company details and write legal name, director, city, and status into columns B through E.
When you also need the business activity code for procurement categorization
The new supplier database requires a primary business activity code alongside the company details.
For each BIN in column A of the KZ Vendors tab, use DaData to fetch the legal name into column B, the director into column C, the city into column D, the status into column E, and the primary KZ business activity code into column F.
When you want to flag inactive suppliers before they reach legal review
You need the enrichment, but inactive suppliers should not be sent to legal as if they were active.
Enrich all BINs in the KZ Vendors tab using DaData — name to column B, director to column C, city to column D, status to column E. In column F, write "FLAG — INACTIVE" if the status is inactive and "OK" if active.
When you need the enrichment plus a vendor summary for the procurement director
Legal needs the per-row details and the procurement director wants a one-page summary before the review.
Enrich all 80 KZ supplier BINs in the KZ Vendors tab using DaData — name to column B, director to column C, city to column D, status to column E. Flag inactive suppliers in column F. Then create a new sheet called "Vendor Summary" with: total suppliers, number active, number inactive, number NOT FOUND, and the top three cities by supplier count.
The pattern: the enrichment and the summary report come from the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with Kazakhstan supplier BINs, then ask it to enrich the rows with official registry data using DaData. The DaData integration is included in every SheetXAI plan. For related workflows, see how to enrich Russian supplier INNs in Excel or the DaData in Excel overview.