How to Use GOOGLETRANSLATE() in Google Sheets

Description

Translates text from one language into another

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.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

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!

Beginner

DETECTLANGUAGE() GOOGLETRANSLATE() VLOOKUP()

Study Better With Google Sheets

Made Ali Abdaal's study google sheet better.

Beginner

COUNTA() GOOGLETRANSLATE() INDEX() RANDBETWEEN() VLOOKUP()

Transcript-matched member videos for GOOGLETRANSLATE(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Currency Exchange Tricks In Google Sheets

Little tricks to make Currency Exchange in Google Sheets better for you,...

Advanced Intermediate Beginner

GOOGLEFINANCE()

Add Title Case to Google Sheets

Discover the Ultimate Google Sheets Hack! Transform Text with Title Case...

Advanced

Unlock these tutorials

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