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. Click GPT for Excel Word in the Home tab. If you don't see it, go to Home > Add-ins > My add-ins > GPT for Excel Word.

  2. Click Translate from the Bulk tools tab.



  3. Configure the translation tool to match the data 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.

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

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


    Note: Using gpt-3.5-turbo models may result in less accurate results. To achieve enhanced accuracy in following instructions and glossary interpretation, select the gpt-4o model. Learn more.

  6. 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.