Subscribe

Google Sheets Translate

✍️

Translating in Google Sheets, its possible!

8 Aug, 2020 · 1 min read

Today I wanted to show you 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 often use Excel for quick replacing/searching/comparing, etc.

Today we are looking at translating strings in Google Sheets!

Translate a String in Google Sheets!

So we'll build 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` to 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

Spread the knowledge with fellow developers on Twitter
Tweet this tip
Powered by Webmentions - Learn more

Read next 📖

Failing is better than not trying

8 Sep, 2022 · 3 min read

Failing is better than not trying

Why do you write so much?

7 Sep, 2022 · 3 min read

Why do you write so much?

Join 1829 devs and subscribe to my newsletter