We all are familiar with MS-Office tools such as MS-Word, MS-Excel and MS-PowerPoint. Do you know Google has its own family of office tools called G-Suit. Yes, Similar to Microsoft, Google has its own office tools such as Google Docs, Google Sheets and Google Slides. Unlike MS-Office, Google tools are free web based programs which can be accessed using any Google account.
Google Sheets is a powerful web based program for creating and editing spreadsheets. These are online spreadsheets which can be saved into your Google Drive and you can access it from anywhere using your google account login. Google sheets are as powerful as Microsoft’s MS-Excel. It has all the functions like MS-Excel such as creating tables, using formulae, creating pivot tables, powerful lookup functions such as Vlookup, creating charts and graphs etc.
Google has made it more powerful by integrating with it some of its advanced tools such as Google Translate. Yes, you heard it right, Google Translate has been readily integrated with Google sheets making it ultra-powerful tool for translation services.
Using Google Translate function within Google Sheet, you can convert any sentence, paragraph stored within a cell into multiple languages simultaneously. You can translate a sentence, phrase, paragraph into 100+ world languages simultaneously . Oh, you don’t believe this? Just have a look at simple steps shown below which will blow your mind.
Login into your Google Account
You cannot access google sheets until you login into google.
Open Google Sheets
Search for google sheets and go to Google Sheets home page & open new blank sheet
Write Down Sentences that you want to Translate in different cells
Syntax for Google Translate Formula
Syntax for Google Translate formula is Very Simple
=GoogleTranslate(“text”, “source language code”,”target language code”)
If you want to translate one sentence from English to Spanish, then syntax would be:
Here, “en” is ISO-639-1 Code for “English” language and “es” is code for “Spanish” language.
Similarly, you can use any language code in target language to translate the sentence into that language.
Translate a Sentence into 11 different languages simultaneously
Now, let’s see an example where we will translate our sentences into 11 different languages simultaneously.
Here I have chosen to translate my sentences into Hindi, Spanish, French, Japanese, German, Korean, Indonesian, Chinese (Simplified), Dutch, Afrikaans & Arabic language.
Translate a Sentence into One Language First Using Google Translate Formula
Now write down Google Translate Formula for first sentence in the Cell B5 for Hindi Language.
Here you can see the arguments of the formula
- Text= A5 i.e. reference to the cell which needs to be translated.
- Source Language Code= “en”, i.e. language code for “English” as my sentence is in English.
- Target Language Code = B4, i.e. reference to the cell where language code for target language (Hindi) is stored
Here you can see, the Google Translate Formula has translated my sentence in to target language i.e. Hindi.
Now, Translate all Sentences into 11 different languages simultaneously
Now, just copy the contents of the cell B5 (Hindi translated sentence) and paste into all the cells of entire table between B5 to L9
All the sentences written in cells A6 to A9 will be translated into respective languages in cells B5 to L9.
Select Cell B5 and Copy (Press Ctrl+C)
Select Cells Between B5 to L9
Paste Google Translate Formula (Press Ctrl+P)
Whoa! All the 5 sentences are translated into 11 different languages in one go
This worked like a magic. You can use this feature to translate your content in 100+ languages in the world.
I hope you liked this article. Do share your feedback about it in the comments section below.
For more such informative articles, do subscribe to our blog. You can also join us on Facebook.
Here are the ISO-639-1 language codes for 104 languages supported by google.
|Sr No||Language||ISO-639-1 Code||Sr No||Language||ISO-639-1 Code|
|13||Cebuano||ceb (ISO-639-2)||65||Myanmar (Burmese)||my|
|14||Chinese (Simplified)||zh-CN (BCP-47)||66||Nepali||ne|
|15||Chinese (Traditional)||zh-TW (BCP-47)||67||Norwegian||no|
|20||Dutch||nl||72||Portuguese (Portugal, Brazil)||pt|