DEV Community

Cover image for Google Sheets Translate
Chris Bongers
Chris Bongers

Posted on • Originally published at

Google Sheets Translate

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!

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!

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

Top comments (2)

33nano profile image

This is freaking awesome. Definitely saves more time than actually translating it from the Google translate website

dailydevtips1 profile image
Chris Bongers

Amazing right, just cool their products integrate so well!