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 Translation instructions, and use the Translation glossary to guide the AI in the process.

Prerequisites

• You have installed GPT for Excel Word.
• You have opened a workbook containing data for translation in one of its columns.

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 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 Write results in.

      

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

   

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

   
   info

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

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

The translations are generated in the selected column.

What's next

Discover more bulk tools.