Sign Up

Have an account?

Sign In

Don't have account,

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

You must login to ask question.

Need An Account,

You must login to add post.

Need An Account,
Search
Ask A Question
Home/Google Sheets Tutorials/Translate Text in Google Spreadsheets Using GoogleTranslate Function
On: Posted in Google Sheets Tutorials Comments: 0 Views: 460

Translate Text in Google Spreadsheets Using GoogleTranslate Function

Translate Text in Google Spreadsheets Using GoogleTranslate Function is an effective way to translate text in bulk to another language.

Please refer the image for for original text and it’s translated version in some 6 other languages.

Que. What is the language code for translation to Hindi language in Googletranslate function?

  1. gu
  2. hi
  3. en
  4. te

Ans. “hi” is the language code for converting text to hindi using Googletranslate function.

It can be used for translation in multiple languages, because GoogleTranslate function supports 10’s of languages including Tamil, Telugu, Gujarati etc.

GOOGLETRANSLATE Explained:

Please refer the pic below for getting an idea about “GOOGLETRANSLATE” function and it’s variables.

where,

  • text: is the text to be translated into another language
  • [source_language]: Original language of the text
  • [target_language]: Target language of the text

Support link to get language codes for translation:

  • GoogleTranslate Language Codes List: Link

Apart, from GOOGLETRANSLATE we also have other articles as well related to viz.

  • VLOOKUP: This articles briefs about ways to merge different tables in GoogleSheets or Excel
  • Creating & Editing Spreadsheets: This article has a brief introduction about the GoogleSpreadsheet, it’s various functions, types of documents it supports, options available under various tabs in menu, difference between GoogleSheets and Microsoft Excel, Advantages of using GoogleSheets etc.
  • SUMIF & SUMIFS: This article briefs about summing based on single or multiple criteria
Other Article Links:

Also, we have “Book Summary” section as well which has in-depth summary of famous books like currently it has summary of “Greatest Salesman in the World“.

And GK section which is full of MCQ’s for static general knowledge.

Do let us know if you want us to write on article of your interest or if you want any further explanation on any existing topic.

For more articles like “Translate Text in Google Spreadsheets Using GoogleTranslate Function” please leave a comment.

Previous article
Next article

Leave a comment