Function AI.TRANSLATE
The AI.TRANSLATE function helps you translate your content into multiple languages directly from your workbook. Simply provide the text, target language, and any optional instructions.
Unlike simple translation tools like Google Translate, AI.TRANSLATE can follow specific instructions and context for more accurate and nuanced translations.
Examples:
Basic Translation
=AI.TRANSLATE("Boost your productivity with ChatGPT for Excel", "Spanish")
This will translate "Boost your productivity with ChatGPT for Excel" into Spanish.
Translation with Context
=AI.TRANSLATE("bank", "French", "Translate in the context of a financial institution")
This ensures the translation of "bank" refers to a financial institution in French.
Translating a Range of Cells
=AI.TRANSLATE(A1:A10, "German")
This translates the text within the range A1:A10 into German.
Providing Additional Instructions
=AI.TRANSLATE("Make sure to check the document", "Japanese", "Translate this in a formal tone")
This translates the phrase into Japanese, ensuring it maintains a formal tone.
Syntax
AI.TRANSLATE(value, language, instruction)
| Argument name | Description |
|---|---|
| value | Text or a a reference to a cell containing the text |
| language | Target language |
| instruction (optional) | Instruction to AI to customize translations to suit your specific needs. For example, you can adjust the tone and style and consider some cultural connotations and regional differences in the meaning of words, something purpose-built translation tools like Google Translate can not do. |