The Scenario
You are a localization manager at a SaaS company. Five Crowdin projects, each with eight to twelve target languages. Every other Friday, you send the exec team a progress update.
The update is supposed to be a single Excel workbook, one row per project per language on the Progress tab, with translation percentage and approval percentage side by side so leadership can see at a glance where things stand before the release decision.
The slow version of the Friday report:
- You open each Crowdin project individually
- Click through to the language breakdown for each
- Copy the numbers into the workbook one language at a time
- Repeat for all five projects, roughly forty rows of manual entry
- Fix the column formatting so it matches the finance team's expected layout
- You send it at 4:55 PM and miss the exec team's 3 PM review.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your Crowdin projects and writes the progress data directly into the workbook, so you never have to open Crowdin's UI for this report.
Open the SheetXAI sidebar and type:
Get the translation progress for all languages in each project listed in column A of the Progress tab and write the project name, language code, translated percentage, and approval percentage into rows starting at row 2 of the Progress tab. Sort by project name, then by approval percentage ascending.
SheetXAI calls the Crowdin API for each project, retrieves the per-language progress, and writes the rows into the workbook sorted the way you asked.
What You Get
A progress dashboard on the Progress tab with one row per project per language:
- Project name — from column A, written back with each row
- Language code — the Crowdin language identifier
- Translated % — percentage of strings with a translation
- Approval % — percentage of strings approved by a proofreader
The approval column is the number that matters. Translated percentage tells you if the work has started. Approval percentage tells you if the work is shippable.
Want to add conditional formatting to flag anything below 90%? Tell SheetXAI to add it. Same prompt, extra instruction.
What If the Data Is Not Quite Ready
Real localization dashboards are rarely clean pulls. SheetXAI handles the edge cases in the same prompt.
When the project IDs in column A are mixed with project names
Some rows have numeric project IDs, some have display names someone typed by hand.
For each row in column A of the Progress tab, look up the Crowdin project by ID if the value is numeric, or by name if it is text. Write the project name, language code, translated percentage, and approval percentage into columns B through E.
When leadership wants only the languages below a threshold
Leadership only cares about languages that are not ready to ship.
Get the translation progress for all languages in each Crowdin project listed in column A of the Progress tab. Write only languages with an approval percentage below 80% into the tab, with project name, language, and approval percentage. Sort by approval percentage ascending.
When you need a rollup row per project
Leadership wants one row per project showing the average approval across all languages.
For each Crowdin project in column A of the Progress tab, get the per-language approval percentages and calculate the average. Write one row per project showing project name, number of target languages, and average approval percentage. Sort by average approval ascending.
When you need to compare this sprint to last sprint
Last sprint's numbers are on the Prev Sprint tab and you need a delta column in the current view.
Get the current translation progress for all projects in column A. Write project name, language, and current approval percentage into columns A through C of the Current tab. Compare each row to the matching row in the Prev Sprint tab by project and language, and write the approval percentage change into column D. Flag rows where approval dropped.
The pattern: describe the output you need and SheetXAI figures out the pull and the logic together.
Try It
Get the 7-day free trial of SheetXAI and open a workbook with your Crowdin project IDs in column A of a tab, then ask it to pull translation progress for all languages. The Crowdin integration is included in every SheetXAI plan. For related workflows, see how to export file-level progress or the Crowdin in Excel overview.