

The same applies to A4 to B4, A5 to B5, etc. Now you can type any word in A3 and you will get a translation in B3.Then click on it and drag it down over B3, B4, B5, etc. Drag your mouse to the corner of the B2 until you see a little cross.As soon as you’re done typing, the translation should appear in cell B2 cell. In A2, write any word that you would like to translate.The program will write #VALUE! in the cell because you haven’t yet written anything in A2. You can change the language codes depending on what you want to translate. In cell B2, write the code: =googletranslate (A2, “en”, “es”).In A1 you can type: ‘English’, and in B1 type the language that you want to translate to.

We will use column A for the familiar words and column B for the translations. Here you can learn the codes for all supported languages. To see all the available languages, you should look at the list of languages supported by Google Translate. If the language option exists in Google Translate, you can use it in your Google spreadsheet. Google Sheets supports the same language codes as Google Translate. Press Enter, you should see a translation of your source word.Otherwise, you will get an error in the code. Remember to always write language codes in quotation marks. For example, you can type ”es” for Spanish or “it” for Italian. For, choose the language you want to translate to.If you want to translate the word ‘cat’, you should write ”en” (for English). For, choose the language of the word you’ve written in.Alternatively, you can click on that cell, and the program will write it for you.


