Google Sheets Translate

— 2 minute read


Today I wanted to show you guys a cool feature I only recently discovered, and it's in Google Sheets!

As a developer, you're not always working in programming languages; sometimes, a simple excel formula can do things quicker.

I tend to use Excel quite a lot actually for quick replacing/searching/comparing etc.

Today we are looking at translating string in Google Sheets!

Translate a String in Google Sheets! permalink

So what we'll build is a multi-column setup; in column 'A', we will have our input words in English. Then in B', we will translate these into Dutch. InC, we'll translate to Spanish, inD, to German and inE` too Arabic.

So in Google Sheets, google added the formula GOOGLETRANSLATE it looks like this:

=GOOGLETRANSLATE(cell with text, “source language”, “target language”)

So here is the list of formulas;

  • Dutch = =GOOGLETRANSLATE(A2,"EN","NL")
  • Spanish = =GOOGLETRANSLATE(A2,"EN","ES")
  • German = =GOOGLETRANSLATE(A2,"EN","DE")
  • Arabic = =GOOGLETRANSLATE(A2,"EN","AR")

You can find these two-letter abbreviations on the following page ISO Codes

Google Sheets Translate

You can also find an example from my sheet here:

View my Translate Sheet

Thank you for reading, and let's connect! permalink
