The Scenario
You are a project manager at a software company. The release is in four days and you need to know the translation status for every file in the main Crowdin project before you can sign off on the go/no-go decision.
What you need is an Excel workbook on the Progress tab: file name, target language, words translated, and percentage complete. Sorted by percentage complete ascending so you can see the bottlenecks at the top.
The slow version:
- Open each Crowdin project file individually
- Click through the language breakdown for each file
- Manually copy file name, language, word count, and percentage into the workbook
- The project has 34 files across 9 languages, that is 306 data points to copy
- You spend four hours on a report and still have three files you are not sure about.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that pulls the file-level translation progress from Crowdin and writes it into the Progress tab, so you have the full picture without opening a single file in Crowdin.
Open the SheetXAI sidebar and type:
Get the translation progress for all files in Crowdin project ID from cell A1 and write the file name, language, translated word count, and completion percentage into the Progress tab starting at row 2. Sort by completion percentage ascending so the lowest-progress files are at the top.
SheetXAI calls the Crowdin API, retrieves per-file per-language progress, and writes the 306 rows sorted by completion into the Progress tab. The go/no-go report is ready.
What You Get
A file-level progress report with one row per file per language:
- File name — the exact file name in Crowdin
- Language — the target language for that row
- Translated word count — number of words with a translation
- Completion % — percentage of words translated
The sort order is the decision tool. Sorted by completion ascending, the files at the top of the workbook are the ones that are not ready.
What If the Data Is Not Quite Ready
Release go/no-go reports need more than a raw progress dump.
When you need to flag only the files that are blocking the release
Get the translation progress for all files in Crowdin project ID from cell A1. Write file name, language, and completion percentage into columns A through C of the Progress tab. In column D, write "BLOCKING" if the file name contains "ui-strings" and completion is below 100%, "AT RISK" if completion is below 80% for any other file, and "OK" for all others.
When you need to see which specific languages are furthest behind globally
Get the translation progress for all files in Crowdin project ID from cell A1. Write file name, language, and completion percentage into the Progress tab. Also write a tab called Language Summary with one row per language showing the average completion percentage across all files. Sort by average completion ascending.
When some files should be excluded because they are not in scope
Get the translation progress for all files in Crowdin project ID from cell A1. Write the results into the Progress tab but skip any file whose name matches a name in column A of the Exclusions tab. Sort by completion percentage ascending.
When you need the file-level report plus a go/no-go recommendation per language
Get the translation progress for all files in Crowdin project ID from cell A1. Write file name, language, and completion percentage into columns A through C of the Progress tab. Then write a tab called Release Readiness with one row per language: language name, files below 80%, files below 100%, and a recommendation of "GO," "CONDITIONAL," or "NO-GO."
The pattern: pull the file-level data and derive the release decision in one prompt. The workbook becomes the release artifact.
Try It
Get the 7-day free trial of SheetXAI and open a workbook with your Crowdin project ID in cell A1, then ask it to pull file-level translation progress. The Crowdin integration is included in every SheetXAI plan. For related workflows, see how to pull a translation progress dashboard or the Crowdin in Excel overview.