I’ve just come across a post in my Linkedin feed showcasing the possibility to quickly translate text inside of Google Sheets using its native Google Translate integration.

It’s a very useful tip. Here’s how to use Google Translate in Google Sheets, in a snap.

Let’s say that you have a first column containing text written in French and want to translate it into English and Spanish.

Google Translate in Google Sheets

Simply type the following formula in a cell of the second and third columns, on the same line as your first text item in the source language (here “siège” in FR, located in A2):

For English =GOOGLETRANSLATE(A2,fr,en)

For Spanish =GOOGLETRANSLATE(A2,fr,es)

So the structure of the formula is =GOOGLETRANSLATE(Reference_cell,source language code,target language code)

Google Translate in Google Sheets

Don’t forget the “air quotes” around the language codes.

Then simply drag the formula on the following lines. Et voilà !

Google Translate in Google Sheets

Always review your translations before publishing the translated copy since Google Translate isn’t always right (but it’s pretty accurate, especially for single words between major languages).

Here’s an example with longer text snippets. The translation took 1 second.

Google translate in google sheets

 

google translate in google sheets

Enjoy using Google Translate in Google Sheets!

""
1
Want to get weekly snack tips?
Sign up to my newsletter.
Previous
Next

You may also like these tips