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!
Language Name | Language Code |
Chinese Simplified | zh-CN |
Chinese Traditional | zh-TW |
English | en |
Filipino | tl |
French | fr |
German | de |
Greek | el |
Indonesian | id |
Irish | ga |
Italian | it |
Japanese | ja |
Korean | ko |
Latin | la |
Polish | pl |
Portuguese | pt |
Russian | ru |
Spanish | es |
Swedish | sv |
Thai | th |
Turkish | tr |
Vietnamese | vi |
Source: Google Support