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.
- 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.
- Click Translate from the Bulk tools tab.
- Configure the translation tool to match the data in your sheet:
- Select the column you want to Translate.
- (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.
- Enter the language to translate To.
- Select the column to Put results in.
- (Optional) Use specific instructions to provide context or guidance on the required tone or audience.
- (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. - 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