If you want to translate words or phrases from one language to another, you’ll probably use Google Translate. But what will you do if you need to translate a batch of words in spreadsheets? Keep switching back and forth between Google Translate and Spreadsheets?
In fact, translating words in Google Sheets is as simple as inputting a formula. Here’s the formula:
=GOOGLETRANSLATE(“text”, “source language”, “target language”)
text: the text you want to translate
* The value for text must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
source language: the language being translated from
*Please use the two-letter language code, e.g. “zh-TW” for Traditional Chinese or “en” for English.
target language: the language being translated to
* Please use the two-letter language code, e.g. “zh-TW” for Traditional Chinese or “en” for English.
Check out how to do it in the video below!
Check out the language code here!
Source: Google Support