Google Sheets Translate

β€” 2 minute read

permalink

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

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 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 set up; 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

Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on Facebook or Twitter