Translate text from one language into another with this simple formula in Google Sheets
Whether you’re a student studying a new language or a tourist encountering new words, the Google Translate formula in Google Sheets provides you with an easy access list of what you know, or want to know.
To get started simply enter a word in one language in a cell, and then use the formula =GOOGLETRANSLATE(cell with text, “source language”, “target language”) in another cell to translate it. You can even drag the fill handle at the bottom of the formula cell down to apply this formula to more than one cell.
Here’s an example, translating English words into Spanish: =GOOGLETRANSLATE(A2, “en”,”es”) - note if you paste this into a sheet and get an error, replace the speech marks as they may not paste properly.
Some Language Code
English ------- en
Hindi----------- hi
Gujarati ------- gu
Panjabi--------- pa
Bengoli --------- bn
Googletranslate formula
-----------------------------------------------------------------------------------------------------------------------
=googletranslate(Select Cell , " Source Language Code ", " Target Language Code")
This formula works for all languages supported by Google Translate. You’ll just need to know the 2-letter code for the language, which you can find in this list.
0 Comments