How to: Translate languages in Google Sheet using GoogleTranslate

You’ll probably already know Google Translate, the most popular translation tool on the internet. Thanks to that application, it’s easier to communicate with people who don’t speak your language. However, did you know that Google Translate was also available in Google Sheets? It’s awesome. You can now translate words and sentences in bulk, with the ease of Google Sheets. In this tutorial, you’ll learn how to use the function.

Usage

To use the GoogleTranslate function in Google Sheets, select the cell and type in the following formula.

=GOOGLETRANSLATE(text, [source_language], [target_language])

Example 1: Translating the word ‘Cheese’ from English to Spanish

=GOOGLETRANSLATE(“Cheese”, “en”,” es”)

Example 2: Translating cell A1 from Dutch to German

=googletranslate(A1,”nl”,”de”)

Variables

The first variable you need to fill in is the text you want to translate. This can be a text between brackets, like this “Hello, welcome to our website”, or a cell. Like A1 or H3.

Source_language and target_language

The second and third variables are optional, they are called source_language and target_language. They both need to be the two-letter code of a language. For English, this is ‘en’. Check all language codes out below. If you don’t fill them in it will default to “auto”, which auto-detects the language. And translates it to the language of your Google Sheets settings. If you fill in the source_language, the second variable, the third variable, target_language, must also be omitted.

There are a ton of languages available on Google Sheets. I’ve created an overview of all the languages that you could use

Languages available on the GOOGLETRANSLATE function

LanguageTwo-letter language code
Abkhazianab
Afaraa
Afrikaansaf
Akanak
Albaniansq
Amharicam
Arabicar
Aragonesean
Armenianhy
Assameseas
Avaricav
Avestanae
Aymaraay
Azerbaijaniaz
Bambarabm
Bashkirba
Basqueeu
Belarusianbe
Bengalibn
Bihari languagesbh
Bislamabi
Bosnianbs
Bretonbr
Bulgarianbg
Burmesemy
Catalan, Valencianca
Chamorroch
Chechence
Chichewa, Chewa, Nyanjany
Chinesezh
Chuvashcv
Cornishkw
Corsicanco
Creecr
Croatianhr
Czechcs
Danishda
Divehi, Dhivehi, Maldiviandv
Dutch, Flemishnl
Dzongkhadz
Englishen
Esperantoeo
Estonianet
Eweee
Faroesefo
Fijianfj
Finnishfi
Frenchfr
Fulahff
Galiciangl
Georgianka
Germande
Greek, Modern (1453–)el
Guaranign
Gujaratigu
Haitian, Haitian Creoleht
Hausaha
Hebrewhe
Hererohz
Hindihi
Hiri Motuho
Hungarianhu
Interlingua (International Auxiliary Language Association)ia
Indonesianid
Interlingue, Occidentalie
Irishga
Igboig
Inupiaqik
Idoio
Icelandicis
Italianit
Inuktitutiu
Japaneseja
Javanesejv
Kalaallisut, Greenlandickl
Kannadakn
Kanurikr
Kashmiriks
Kazakhkk
Central Khmerkm
Kikuyu, Gikuyuki
Kinyarwandarw
Kirghiz, Kyrgyzky
Komikv
Kongokg
Koreanko
Kurdishku
Kuanyama, Kwanyamakj
Latinla
Luxembourgish, Letzeburgeschlb
Gandalg
Limburgan, Limburger, Limburgishli
Lingalaln
Laolo
Lithuanianlt
Luba-Katangalu
Latvianlv
Manxgv
Macedonianmk
Malagasymg
Malayms
Malayalamml
Maltesemt
Māorimi
Marathimr
Marshallesemh
Mongolianmn
Nauruna
Navajo, Navahonv
North Ndebelend
Nepaline
Ndongang
Norwegian Bokmålnb
Norwegian Nynorsknn
Norwegianno
Sichuan Yi, Nuosuii
South Ndebelenr
Occitanoc
Ojibwaoj
Church Slavic, Old Slavonic, Church Slavonic, Old Bulgarian, Old Church Slavoniccu
Oromoom
Oriyaor
Ossetian, Osseticos
Punjabi, Panjabipa
Palipi
Persianfa
Polishpl
Pashto, Pushtops
Portuguesept
Quechuaqu
Romanshrm
Rundirn
Romanian, Moldavian, Moldovanro
Russianru
Sanskritsa
Sardiniansc
Sindhisd
Northern Samise
Samoansm
Sangosg
Serbiansr
Gaelic, Scottish Gaelicgd
Shonasn
Sinhala, Sinhalesesi
Slovaksk
Sloveniansl
Somaliso
Southern Sothost
Spanish, Castilianes
Sundanesesu
Swahilisw
Swatiss
Swedishsv
Tamilta
Telugute
Tajiktg
Thaith
Tigrinyati
Tibetanbo
Turkmentk
Tagalogtl
Tswanatn
Tonga (Tonga Islands)to
Turkishtr
Tsongats
Tatartt
Twitw
Tahitianty
Uighur, Uyghurug
Ukrainianuk
Urduur
Uzbekuz
Vendave
Vietnamesevi
Volapükvo
Walloonwa
Welshcy
Wolofwo
Western Frisianfy
Xhosaxh
Yiddishyi
Yorubayo
Zhuang, Chuangza
Zuluzu
All languages available on the GOOGLETRANSLATE function on Google Sheets

Use cases

Now you know how the formula works, It’s time to put learnings to practice. I’m sure that you can think of a dozen of ideas yourself to create. Here are some of my ideas:

  • Translation tool for your website content
  • Multi-language translator of comments, in combination with the “auto” function

GoogleTranslate function not working?

There are a couple of common errors with Google Finance.

  1. Make sure you translate one cell, or one string.

GoogleTranslate is only able to translate one cell or string at a time. It doesn’t work with an array, like A1:A4. Just select one cell to translate.

  1. Make sure you’re using either ‘single’ or “double” quotes

An error I encounter a lot is that people don’t have the right quotes in the formula. Make sure you’re using either only single or double quotes in the formula.

If your error is not in this list, please let us know via a comment, we’ll try to figure it out and add it to the list!

Sum up

That’s it! This is all you need to know to work with the GOOGLETRANSLATE formula in Google Sheets. If you still have any questions, don’t hesitate and leave a comment down below. We’ll check all comments daily and try to help you out with your issues. Cheers!

1 comment

Leave a comment

Your email address will not be published. Required fields are marked *