GOOGLETRANSLATE Function – Google Sheets Tutorial

Google Sheets GOOGLETRANSLATE Function

While there are several similarities between Excel and Google Sheets, the GOOGLETRANSLATE function is a feature that is only available in the latter. Because Google Sheets is web-based and connected to Google’s powerful APIs, the GOOGLETRANSLATE function enables you to translate words and phrases in Google Sheets from one language to another. Because this function is powered by the Google Translate technology, it works with any language that Google Translate supports.

Syntax of the GOOGLETRANSLATE Function

=GOOGLETRANSLATE(Text, [From_language, To_language])
  • Text: The text is the only required argument for this function. This is the text that will be translated from one language to another.
  • From_language: This optional argument tells Google Sheets the language of the text argument (before it’s translated). You can omit this argument and let Google detect the source language on its own, however this may cause issues if a word looks similar in multiple languages. This argument is specified with a language code from the table below. You can also supply “auto” for this argument, which would be the same as leaving it blank.
  • To_language: This argument – also optional – tells Google Sheets what language to translate the text to. If you omit this argument, the function will translate the text to your computer’s system language. This argument is also specified with a language code found in the table below.

Examples with the GOOGLETRANSLATE Function in Google Sheets

Here are some examples of the GOOGLETRANSLATE function in action.

Google Sheets GOOGLETRANSLATE Function Examples
Google Sheets GOOGLETRANSLATE Function Examples

In the first example, we see that the text in cell A2 is written in Spanish, but we want to translate it to English. We use A2 as the first argument, “es” (the language code for Spanish) for the second argument, and “en” (the language code for English) as the third argument.

=GOOGLETRANSLATE(A2, "es", "en")

This formula returns a result of “Hello!” in English.

In the second example we see that the text in cell A3 is written in Japanese and we want to translate it to English.

=GOOGLETRANSLATE(A3, "ja", "en")

This formula returns a result of “This is Japanese!” in English.

In the third example, we see some text in cell A4, but we’re not sure what language this is. We can supply “auto” as the second argument, so that Google will detect the language on its own.

=GOOGLETRANSLATE(A4, "auto", "en")

This formula detects the language is Afrikaans (we could use the DETECTLANGUAGE function if we need to know which language this is) and returns a result of “Translating is fun” in English in cell C4.

In the fourth and final example we see more fun text in cell A5, but again, we don’t know what language this is. We can just leave from_language and to_language blank.

=GOOGLETRANSLATE(A5)

Google will detect the language of the text in cell C5 (Icelandic) and translates it to the system language of the user’s computer, which, in this example, happens to be English. This formula returns a result of “How are you?” in English in cell C5.

Google Translate Language Codes

When using the GOOGLETRANSLATE function in Google Sheets, the language arguments in the formula need to be in the form of the language codes shown in the table below. If you attempt to provide the actual language name (e.g. “spanish”) as an argument, your formula will return a #VALUE! error. Rather than writing “spanish” for example, you would provide “es” as the language argument.

As of May 2021, Google Translate supports 108 languages, which means that you can use the GOOGLETRANSLATE function to translate text between all of these languages in Google Sheets. See the table below for language codes to use with the GOOGLETRANSLATE function.

Afrikaans af
Albanian sq
Amharic am
Arabic ar
Armenian hy
Azerbaijani az
Basque eu
Belarusian be
Bengali bn
Bosnian bs
Bulgarian bg
Catalan ca
Cebuano ceb
Chinese (Simplified) zh-cn
Chinese (Traditional) zh-tw
Corsican co
Croatian hr
Czech cs
Danish da
Dutch nl
English en
Esperanto eo
Estonian et
Finnish fi
French fr
Frisian fy
Galician gl
Georgian ka
German de
Greek el
Gujarati gu
Haitian Creole ht
Hausa ha
Hawaiian haw
Hebrew he or iw
Hindi hi
Hmong hmn
Hungarian hu
Icelandic is
Igbo ig
Indonesian id
Irish ga
Italian it
Japanese ja
Javanese jv
Kannada kn
Kazakh kk
Khmer km
Kinyarwanda rw
Korean ko
Kurdish ku
Kyrgyz ky
Lao lo
Latin la
Latvian lv
Lithuanian lt
Luxembourgish lb
Macedonian mk
Malagasy mg
Malay ms
Malayalam ml
Maltese mt
Maori mi
Marathi mr
Mongolian mn
Myanmar (Burmese) my
Nepali ne
Norwegian no
Nyanja (Chichewa) ny
Odia (Oriya) or
Pashto ps
Persian fa
Polish pl
Portuguese (Portugal, Brazil) pt
Punjabi pa
Romanian ro
Russian ru
Samoan sm
Scots Gaelic gd
Serbian sr
Sesotho st
Shona sn
Sindhi sd
Sinhala (Sinhalese) si
Slovak sk
Slovenian sl
Somali so
Spanish es
Sundanese su
Swahili sw
Swedish sv
Tagalog (Filipino) tl
Tajik tg
Tamil ta
Tatar tt
Telugu te
Thai th
Turkish tr
Turkmen tk
Ukrainian uk
Urdu ur
Uyghur ug
Uzbek uz
Vietnamese vi
Welsh cy
Xhosa xh
Yiddish yi
Yoruba yo
Zulu zu

Try Practice Problems With GOOGLETRANSLATE

To fully commit this function to memory you need to get some hands on experience. Try some practice problems with the GOOGLETRANSLATE function in our interactive Google Sheets Tutorial now!

Leave a Reply