You can now use functions in spreadsheets that can automatically detect and translate languages.
Standard, Premier, Education, Team and Partner Editions
All languages supported by Google Spreadsheets
How to access what’s new:
To detect and translate languages on a spreadsheet, use the new functions:
- =GoogleTranslate(“field one”,”field two”,”field three”)
- =DetectLanguage(“field one”)
For the translate function, the fields should contain a combination of the text you want to translate, the two letter language code of the text and the language code you want the text to be translated into.
For the detection function, simply enter the text in the field and it will output the two letter language code of the text.
For more information: