Skip to main content

Translate

Use the Translate bulk tool to translate an entire column according to your instructions and glossary.

For example, you can translate a column with content in various languages into a single common language. You can also customize your translations by adding specific instructions, and a glossary to guide the AI in the process.

Prerequisites
  1. Select Extensions > GPT for Sheets and Docs > Open.

  2. Click Translate from the Bulk tools tab.


  3. If you open the Bulk tools for the first time, you are prompted to grant additional permissions. These permissions are required for GPT for Sheets to write in your spreadsheets.
    1. Click Sign-in with Google. A Sign in with Google window opens.
    2. Select the Google account with which you have installed GPT for Sheets.
    3. Click Allow to grant GPT for Sheets the required permissions.

  4. Configure the translation tool to match the text in your sheet:
    1. Select the column you want to Translate.
    2. (Optional) Enter the language to translate From, or leave the field empty if you want the AI to detect the source language for each cell.
    3. Enter the language to translate To.
    4. Select the column to Put results in.

      5. The image shows steps to select a column to translate, optionally set or auto-detect the source language, specify the target language, and choose a results column.

  5. (Optional) Use specific instructions to provide context or guidance on the required tone or audience.

  6. (Optional) Use glossary to pair Source words with Translated words, ensuring consistent translations across languages.


    Note: To achieve enhanced accuracy in following instructions and glossary interpretation, select the gpt-4o model. Learn more.

  7. Select if you want to run a specific number of rows or All rows. Then, click Run rows.

The translations are generated in the selected column.

What's next

Check our translation best practices.