قالب وردپرس درنا توس
Home / Tips and Tricks / How to use Google Translate directly in Google Sheets

How to use Google Translate directly in Google Sheets



  Google Sheets logo

Google Translate lets you translate words or phrases from one language to another. But did you know that there is a formula that lets you translate a stack of words directly into Google Sheets? How It Works:

Translating Text in Google Sheets

The integration of Google Translate into Google Sheets was a good call. Now you no longer have to switch between tabs to translate text. Translating text into tables is as easy as typing a formula. Here's the structure of the formula:

  = pulledLETRANSLATE ("text", "source language", "target language") 

  Google Translate formula

When entering the text to translate, you can either type the actual text word in the formula itself, or you can enter a cell containing the word to translate.

In this example, we want to translate the English words in column A (which we call "English") into their Chinese equivalents in column B (which we called "Chinese"). Since we already have the words in the sheet, we can just call the cells that contain them. Here we call cell A2, which contains the word "cake".

 Text cell

Note: If you type the text directly into the formula, you will need to put the word in quotation marks. If you enter the cell in which the word is located, you must omit the quotation marks.

Next comes the source language in our formula. When entering the source language, you must enter the two-letter language code. If you are not sure which is the source language, you can type "auto" and Google will automatically detect the language. We know that "cake" is an English word, so we use "en". Note that you must place the quotation marks around the two-letter language code.

 Source Code

Finally, we must enter our target language in the same way. Here we use "zh" – the two-letter code for Chinese.

 Target Language Code

When you're done, press Enter and watch the spell happen.

If you have a list of words in column A that you want to translate, simply select the cell that contains the formula you just entered. Click on the lower right corner. and drag in the desired line.

As with any other translation software, this is not always 100%. For a less complicated vocabulary, however, this should be a reasonably reliable solution. Function (f, b, e, v, n, t, s) {if (f.fbq) return; n = f.fbq = function () {n.callMethod? n.callMethod.apply (n, arguments): n.queue.push (arguments)}; if (! f._fbq) f._fbq = n; n.push = n; n.loaded =! 0; n.version = & # 39; 2.0 & # 39 ;; n.queue = []; t = b.createElement (e); t.async =! 0; t.src = v; s = b.getElementsByTagName (s) [0]; s.parentNode.insertBefore (t, s)} (window, document, & # 39; script & # 39 ;, & # 39; https: //connect.facebook.net/en_US/fbevents.js'); fbq (& # 39; init & # 39 ;, 335401813750447 & # 39;); fbq (& # 39; track & # 39 ;, & # 39; PageView & # 39;);


Source link