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:

js
=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

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

Comments

[Manyong'oments]

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

[Chris Bongers]

Amazing right, just cool their products integrate so well!