GOOGLETRANSLATE Formula Generator
GOOGLETRANSLATE translates text inside a cell using Google Translate. Sheets-only. Great for multilingual product catalogs, customer messages, or learning vocabulary.
Syntax
=GOOGLETRANSLATE(text, [source_language], [target_language])Try it — generate a GOOGLETRANSLATE formula
Examples
Auto-detect source, translate to Spanish
=GOOGLETRANSLATE(A2, "auto", "es")Auto-detects source language, translates to Spanish.
English to Turkish
=GOOGLETRANSLATE(A2, "en", "tr")Force English source, Turkish target.
Detect language of text
=DETECTLANGUAGE(A2)Related function — returns the language code ("en", "fr", "tr"...) without translating.
Tips
- ✓Use ISO 639-1 codes: "en", "es", "fr", "de", "tr", "zh", "ja", etc.
- ✓"auto" auto-detects source language — convenient when input language varies.
- ✓Not available in Excel. For Excel, use an API call via Power Query or Office Scripts.
Related Formulas
CONCATENATE / TEXTJOIN
Combine text from multiple cells into one. TEXTJOIN is the modern approach with ...
QUERY
QUERY is Google Sheets' most powerful function. It lets you use SQL-like syntax ...
REGEXEXTRACT / REGEXMATCH / REGEXREPLACE
Google Sheets has three regex functions: REGEXEXTRACT (pull matched text), REGEX...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free