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.

Translate with google docs