The Scenario
You are a terminology manager. Your team has spent three months building a 500-term glossary: English source, Spanish translation, French translation, and definition. It is sitting in a Google Sheet.
The localization team has been waiting for this glossary to land in Crowdin before they start the next translation sprint. The sprint starts in two days.
The slow version:
- Open Crowdin's glossary editor
- Add the first term: paste the English source, add the Spanish translation, add the French translation, paste the definition
- Repeat 500 times
- Realize at term 200 that you have been adding Spanish terms to the wrong glossary
- You spend the afternoon cleaning up and the sprint starts without the glossary.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the glossary rows and imports them into Crowdin in one go, so you never have to touch Crowdin's glossary editor.
Open the SheetXAI sidebar and type:
Import all rows from my sheet as glossary terms into Crowdin using column A for the English source term, column B for the Spanish translation, column C for the French translation, and column D for the definition. Write "IMPORTED" into column E when each term is created successfully, and the error message if it fails.
SheetXAI iterates through all 500 rows and writes the result into column E. The import is auditable: you see which terms succeeded and which failed before you hand off to the translation team.
What You Get
A 500-term Crowdin glossary plus a per-row confirmation in the sheet:
- English source, Spanish translation, French translation — all three added per term
- Definition — included for each term
- Column E — "IMPORTED" for successes, error message for failures
The failure log is what saves the sprint. If 12 terms have character limit violations or duplicate entries, column E tells you exactly which rows and why. You fix them before the localization team starts, not after.
What If the Data Is Not Quite Ready
Glossaries built in spreadsheets over three months accumulate inconsistencies. SheetXAI handles cleanup and import in the same prompt.
When some terms have inconsistent capitalization
The English source terms were added by multiple people, some title-cased, some lowercase, some all caps for acronyms.
Normalize the terms in column A so regular words are lowercase and acronyms in all caps stay all caps. Then import all rows into Crowdin with the normalized term, Spanish translation from column B, French translation from column C, and definition from column D.
When some rows are missing the French translation
Column C is blank for about eighty rows because the French translator has not finished yet.
Import all rows into Crowdin where column C is not blank. For rows where column C is blank, write "SKIPPED — French translation missing" into column E. Do not create a glossary term for incomplete rows.
When you need to import into two separate Crowdin glossaries
Some terms are product-specific (go into the Product Glossary) and some are legal terms (go into the Legal Glossary). Column F has the glossary designation.
Import each row into the Crowdin glossary named in column F. Use column A for the English source, column B for Spanish, column C for French, and column D for the definition. Write the glossary name and "IMPORTED" into column G for each success.
When the glossary already exists and you want to update changed terms rather than create duplicates
The Crowdin glossary already has 300 terms from a previous import. Your sheet has 500, including updates to some existing terms.
For each row in my sheet, check if a term with the same English source already exists in the Crowdin glossary. If it does, update the Spanish translation, French translation, and definition from the sheet. If it does not exist, create it. Write "UPDATED" or "CREATED" into column E for each row.
The pattern: the sheet is the source of truth for the glossary. Crowdin gets what the sheet says, not the other way around.
Try It
Get the 7-day free trial of SheetXAI and open a sheet with your glossary terms, then ask it to import them into Crowdin. The Crowdin integration is included in every SheetXAI plan. For related workflows, see how to bulk-add source strings or the Crowdin in Google Sheets overview.