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

• You have installed GPT for Excel Word.
• You have opened a workbook containing text to translate 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 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.
   
   
   
   
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: 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.