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!
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;
You can find these two-letter abbreviations on the following page ISO Codes
You can also find an example from my sheet here: