Formulas > =GOOGLETRANSLATE()
How to Use GOOGLETRANSLATE() in Google Sheets
Description
How To Actually Use GOOGLETRANSLATE() in Sheets
GOOGLETRANSLATE(text, [source_language], [target_language])
Try GOOGLETRANSLATE yourself
Use the GOOGLETRANSLATE function to translate the text in cell A1 from English to Spanish. The result should be displayed in cell B1.
Hints (2)
-
Remember to specify the source and target languages using their language codes.
-
The source language code for English is 'en' and for Spanish is 'es'.
2 Better Sheets Tutorials
World Peace in Google Sheets
Combining GoogleTranslate() and DetectLanguage() to figure out what a language is without having to know the two letter codes. And adding a dropdown range to make it easier to find the language you want to translate to. What a great way to solve the frustrating world of International language!
DETECTLANGUAGE()
GOOGLETRANSLATE()
VLOOKUP()
Study Better With Google Sheets
Made Ali Abdaal's study google sheet better.
COUNTA()
GOOGLETRANSLATE()
INDEX()
RANDBETWEEN()
VLOOKUP()
Learn more about the GOOGLETRANSLATE() formula:
Generate a GOOGLETRANSLATE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses GOOGLETRANSLATE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a GOOGLETRANSLATE() formula