Google Sheets localization with Crowdin

If you're currently using a Google Sheets to manage your localization keys, you now have the option to integrate it with professional translation tools using this app.

There are several benefits to continuing to use a spreadsheet while taking advantage of the features that Crowdin can offer. For example, you may already have the spreadsheet connected to your build system, and your team may be accustomed to using it, so introducing a new software may not be necessary. However, building a comprehensive localization system using Google Sheets can be challenging. With this app, you can find a compromise and get the best of both worlds.

Note: This application can only sync multilingual spreadsheets with Crowdin. If you are looking for a way to translate regular Google Drive files or spreadsheets, please see the following application Google Drive Integration

Important: This application does not resolve conflicts. We recommend having either Crowdin or Spreadsheet as the source of truth for source texts and translations. You can use Google Sheets as the source of truth for new rows and Crowdin as the source of truth for translations.

Sheet Format

If you have a multilingual Google Sheet file with one column for the source language and multiple columns for target languages, you can easily integrate it with Crowdin using our app.

After installing the app, you can configure it and map your columns to the relevant fields in Crowdin. The following fields can be mapped:

• Key

• Source Text

• Target Languages (all project languages)

• Labels

• Context

• Translation Max. Length

Don't worry if you have more columns or some of these fields are missing – the integration will not affect the rest of your spreadsheet.

It's worth noting that this integration will only sync the first sheet from your Google Sheet document.

Features at a glance

• Two-way synchronization for source text and translations
• Manual content synchronization before and after translation.
• Auto-sync of source content and translations.
• Quick sync and translation of even minor content updates, like a new sentence or a changed word.

Google Sheets translation connector overview

Setting up the Google Sheets connector

After installing the application, you will find it in your project Integrations section.

Follow the instructions on the screen to connect your Google Sheets account.

Manual synchronization

To import content for translation from Google Sheets, follow these steps:

1. Open the Google Sheets integration.
2. In the Google Sheets section (right panel), select the files that should be translated.
3. Click Sync.

To export translations to Google Sheets, follow these steps:

1. Open the Google Sheets integration.
2. In the left section, select the files that will be synced to Google Sheets.
3. Click Sync to Google Sheets.

Auto content synchronization

To automatically import content for translation from Google Sheets choose files and click Scheduled sync in the right panel in the Google Sheets integration. The file you chose will be pushed once at a scheduled time (by default, it is done once a day). The same button is used to export translated files from Crowdin to Google Sheets (in the left panel). You may disable this by clicking Disable Sync.