Google Sheets Translate

I'm a full-stack developer from South Africa 🇿🇦. I love writing about JavaScript, HTML and CSS.
Search for a command to run...

I'm a full-stack developer from South Africa 🇿🇦. I love writing about JavaScript, HTML and CSS.
No comments yet. Be the first to comment.
Most of you know me for my consistency, a golden arrow in my blog series. I've written 1000 articles in 1008 days! Almost an article a day, and my honeymoon was the only holiday I ever took. I'm super proud of this achievement; it has been a fantasti...

It's not the first time I'll be talking about community. I think it's an essential aspect of any successful tool. This shows in my previous explorations of Astro, Medusa, and now Vendure as well. All these products thrive in a super open, welcoming, ...

The cool part about Vendure is how easy it is to set up and how abstract each layer is. Basically, we get the following elements: External database Server Worker Admin UI Frontend While this is amazing, it also brings a bit of complexity when it co...

The previous article looked at customizing Vendure on a data and process level. In this article, we'll look at customizing emails, as they are often a big part of a webshop system. We'll be looking at two different layers of customization for customi...

Even though Vendure is a pretty significant project out of the box, in some cases, we might want to go in and modify some elements to work to our specific use case. In this article, I'll take a high-level look at some elements we can customize within...

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;
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:
Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on Facebook or Twitter