gerbiz.blogg.se -

and the target language, as is shown in the diagram. To use this function you must specify the text to translate, the source language. The GOOGLETRANSLATE function will automatically translate text from one language to another. Learn to build dashboards in Google Sheets Google Sheets Language Translate Function: GOOGLETRANSLATE You can use cell references for the source language and target language as well.Īll of the 2-letter language codes are listed at the bottom of this page, and are in the template as well.ĭownload your Google Sheets formula cheat sheet The first formula refers to cell A3 to specify the text to be translated, where the second formula uses simple text criteria that is entered directly into the formula. You can choose to enter text as the criteria for your GOOGLETRANSLATE formula, or you can also use cell references.īelow are two formulas which show the difference between using text, and using cell references. After the text is entered, the translation will appear in columns B and C, in the languages that you selected

In the cells in column A, starting at row 3, type the text that you want to translate.

You may also repeat this in cell C1 if you want to translate two different languages at once

In cell B1, select the target language, or in other words the language that you are translating to.

In cell A1, select the source language, or in other words the language that you are translating from.

You can view the full list of languages and language codes in columns H and I.

Select your favorite languages from the drop down menus in column E.

See more Google Sheets templates How to use the language translator template You can also translate language by using the Google Sheets Language Translation Template that is linked below. In this example, the cell that contains the formula would say, "Hola"

Press enter on the keyboard, and your text will be translated.

Type a comma, and then enter the two-letter language code, for the language that you are translating to (Target Language).

Type a comma, and then enter the two-letter language code, for the language that you are translating from (Source Language).

Then type the text that you want to translate (between quotation marks), or type the address of the cell that contains the text to be translated.

Type =GOOGLETRANSLATE( to begin the language translation function.

To translate languages in Google Sheets, follow these steps:

In this article I am going to teach you how to use the language translation formula in Google Sheets, and I am also going to give you a template that you can use to translate languages. Google Sheets is an amazing platform that can do many incredible things, such as translating languages.