Translate Text in Google Spreadsheet

Google has introduced another good feature in Google Spreadsheet. Now you can translate any text in Google Spreadsheet with simple functions. You can translate any text in 40 different languages. All you have to do is to know the two words code of the language. If you don’t know the language in which you want translate, go to this site and check the code of required language under ISO 639-1 Code column.

To detect the language of any text, you will have to use this function command:

=DetectLanguage("text")

In text you can type any text and google spreadsheet will automatically detect the language of the text.

For example:

=DetectLanguage("Hola, ¿cómo estás?") would give “es” as a result.

Similarly you can translate the text into your required language with this funtion:

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

For example:

=GoogleTranslate("Hola, ¿cómo estás?","es","en") translates into “Hi, how are you?”

I have used these functions in the following example and it will help you how to use them.

In column A I have written some sentences, and in column B I will use the function to detect the language of text which is in column A. And in column C, I translated the column A text into french.

If you will hover the mouse pointer on the translated text, you will see the original text.

It is really an amazing feature. You can use this feature to translate all the responses into your own language. If you want to ask anything about this feature, you can leave a comment here.