How to use Google Translate directly in Google Sheets

Do you know there is a formula that makes Google Translate translate a series of words directly in Google Sheets? If not, read the following article.

You often use Google Translate to translate a word, phrase or even text into another language, but do you know there's a formula that makes Google Translate translate a series of words directly in Google Sheets? If not, read the following article.

  1. How to translate web pages into Vietnamese, English or any language
  2. 3 simple ways to download pronunciation files on Google Translate
  3. How to turn off automatic language translation in Google Chrome

Translate text in Google Sheets

It's easy to integrate Google Translate into Google Sheets, now you don't need to switch between tabs to translate text. Translate text in Sheets simply with the following formula:

 = GOOGLETRANSLATE ('text', 'source language', 'target language') 

How to use Google Translate directly in Google Sheets Picture 1How to use Google Translate directly in Google Sheets Picture 1

When entering text to translate, you can manually type in the command or refer to the cell containing the word to be translated.

In this example, we need to translate the English word in column A (English column) into Chinese in column B (Chinese column). Because we already have the word in the column, just refer to cell A2 containing the word "Cake".

How to use Google Translate directly in Google Sheets Picture 2How to use Google Translate directly in Google Sheets Picture 2

Note: If you enter text directly in the formula, you need to put the word to translate in quotation marks. If you enter a cell that contains words, do not use this quotation mark anymore.

Next in the formula, enter the original language in the two-letter language code. If you don't remember the language code, enter 'auto' for Google to automatically detect the language. Here Cake is English so we use the 'en' language code. Note you must leave this language code in quotes.

How to use Google Translate directly in Google Sheets Picture 3How to use Google Translate directly in Google Sheets Picture 3

Finally, enter the translation language similar to the original language. Here we use the 'zh' code which is the language code of Chinese.

How to use Google Translate directly in Google Sheets Picture 4How to use Google Translate directly in Google Sheets Picture 4

After completing the formula, press Enter .

How to use Google Translate directly in Google Sheets Picture 5How to use Google Translate directly in Google Sheets Picture 5

If you have a list of words in column A you want to translate, simply select the cell containing the formula and drag the bottom right corner to the desired cells.

How to use Google Translate directly in Google Sheets Picture 6How to use Google Translate directly in Google Sheets Picture 6

Like any translation software, the translation here may not be 100% accurate, but for simple words, this can be a reliable solution.

I wish you all success!

4 ★ | 4 Vote