GOOGLETRANSLATE Function

Google Sheets offers a suite of useful and unique features, GOOGLETRANSLATE Function being one of them. This will help us translate any text input to multiple different languages. Something like below:-

This can be very useful if you are dealing with multiple-clients across different geographies, or simply are learning a new languge.

So lets begin.

Purpose

GOOGLETRANSLATE Function helps to translate a text input from one language to another.

Syntax and Parameter Definition

Below is the Syntax of GOOGLETRANSLATE Function:

=GOOGLETRANSLATE(text, [source_language, target_language])

Parameter Definition:-

  1. text:- the text which needs to be translated. Can be a cell number like “A2/C10/B5” etc or a direct input like “cat, train, dog” etc
  2. source_language:- two letter language code of input text like “en” for English, “fr” for French, “ko” for korean. You can also add “auto” for enabling auto-detection of the language. It’s an optional entry. Default value is “auto”.
  3. target_language:- two letter language code of the final output language. It’s an optional entry. Default value if system language.

Key Points to Note:

  1. Visit this link to get mapping for 2 digit language codes
  2. If Source_language is empty then target_language should be left empty as well and vice-versa

Expected Output

As mentioned before GOOGLETRANSLATE Function translates from one language to another. Hence, if we supply an input text we get a translated output as a result.

=GOOGLETRANSLATE(B2,"en","fr")

Examples

Follow the below steps to translate from one language to another in Google Sheet

  1. Prepare the input text which requires translation
  2. Find out the two digit language code for both source and target language using this link
  3. Apply GOOGLETRANSLATE Formula using input text and language code
  4. Get the final result

We will be using the above principles to apply GOOGLETRANSLATE Function in the below examples.

Translation of Simple Words

In the below example we have taken multiple random works and translated it to FRENCH from ENGLIGH.

In the above example if i want to now translate to Spanish, we’ll replace “fr” by “es”.

Translation of Sentences

Using the GOOGLETRANSLATE Function you can not just translate words but whole sentences as well. The principles remain the same. Below are some examples.

Visual Demo of GOOGLETRANSLATE Function

Before we end here is a sample visual demonstration of GOOGLETRANSLATE Function in action.

That’s it on this topic. If you face any issues in implementing the above methods then leave a comment down below. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Liked the content?? Then share the word!!!

Rishav

I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply