The Scenario
You are a market researcher. The regulatory database submission is due next Tuesday. You have a Google Sheet with 150 company activity descriptions scraped from websites and LinkedIn profiles.
The database requires an OKVED2 code for each company — the official Russian business activity classification used in regulatory filings. Without the codes, the submission fails validation and comes back for rework.
The bad version of this week:
- Open the OKVED2 classifier on the government portal
- Read each description, pick a category, search the tree
- Find the closest code
- Copy it back to the sheet
- Repeat for 150 rows
- Spend Tuesday morning fixing the 23 codes the portal reviewer says are wrong because you picked the wrong level of the hierarchy.
The fast version is one prompt and the codes are in the sheet before the weekend.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the description column, calls DaData's OKVED2 suggestion endpoint for each row, and writes the best-matching code and section name back.
Open the SheetXAI sidebar and type:
For each business activity description in column A of my sheet, use DaData to find the best matching OKVED2 code and write the code into column B and the official OKVED2 section name into column C. If DaData returns multiple candidates, use the highest-confidence match.
SheetXAI reads the description column, calls DaData's OKVED2 classifier for each row, and writes two enriched columns back. All 150 descriptions matched to official codes in one pass.
What You Get
Two new columns with OKVED2 classification data for every description in the sheet:
- Column B — the OKVED2 code at the appropriate hierarchy level (e.g., 62.01, 47.11.1)
- Column C — the official OKVED2 section name (e.g., "Разработка компьютерного программного обеспечения")
The codes are from the official OKVED2 tree, not a custom taxonomy. They pass regulatory validation because they come from the same source the government portal uses.
What If the Data Is Not Quite Ready
Descriptions scraped from websites are inconsistent in length and specificity. SheetXAI handles the edge cases in the same prompt.
When some descriptions are in English and need translating first
A subset of companies posted their activity descriptions in English because they serve international clients.
For each description in column A, if it appears to be in English, translate it to Russian first. Then use DaData to find the best OKVED2 code match and write the code into column B and the section name into column C.
When you need the full hierarchy, not just the leaf code
The database requires the division code (two digits) and the group code (four digits) alongside the full code.
For each description in column A, use DaData to find the best OKVED2 match. Write the division code into column B, the group code into column C, and the full leaf code into column D. Write the section name into column E.
When some descriptions are too vague to classify confidently
Short one-word descriptions like "retail" or "IT" will not produce a reliable match at the leaf level. You want a flag on low-confidence assignments.
For each description in column A, use DaData to find the best OKVED2 code and write it into column B and the section name into column C. If the description is fewer than five words or DaData's confidence is low, write "NEEDS REVIEW" in column D.
When you need the classification plus a sector breakdown for the research report
The research report needs a pie chart of the database by OKVED2 division. You want the per-row codes and a summary distribution.
For each description in column A, use DaData to assign the best OKVED2 code into column B and the section name into column C. Then write a summary below: the number of companies per OKVED2 division (top-level two-digit group), sorted by count descending.
The pattern: the code assignment and the sector analysis come from the same prompt. The research report and the database submission are ready at the same time.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with business activity descriptions, then ask it to assign OKVED2 codes using DaData. The DaData integration is included in every SheetXAI plan. For related workflows, see how to standardize company names to official registry names or the DaData in Google Sheets overview.