Fast and Easy Translations Using Google Sheets

Sheets

If you deal with feedback coming from your customers all over the world, having the ability to translate their comments in your native language is crucial! You obviously do not want to exclude non-english speaking users from your analysis for example. Translating is super easy in Google Sheets, and I will show you how to do just that using the GOOGLETRANSLATE function.

Here is how it works:

In the following example we will translate the content in cell A1 from French to English.

=googletranslate(A1,"fr","en")

png

Here is more, you can use GOOGLETRANSLATE in collaboration with the DETECTLANGUAGE function, so you can let Google Sheets figure out the original language:

=googletranslate(A1,detectlanguage(A1),"en")

png

There is an even simpler way to do it! The below function will yield the same result as the two previous examples. GOOGLETRANSLATE is very powerful and does not even need your input when it comes to identifying the language used in the original text:

=googletranslate(A1)

To sum it up

The GOOGLETRANSLATE function take three parameters as input: text, source_language and target_language.

Text is simply the piece of text you want to be translated.

Source_language, is auto by default (GoogleSheets will automatically detect the language) however we can indicate the source language by using a two-letters code as below:

png

Finally the target_language is the two-letters code for the language we want the text to be translated into.

Et voila!

Share this post: