How to use Google Translate in Google spreadsheets

Link to ISO language codes: https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes

A very important advantage of using google spreadsheets over Microsoft Excel is that you can use a lot of tools from the Google ecosystem. One such important tool is the google translate. Yes, google translate...if you have used in your phone; you know how good it is and especially the lovely live translation which can help you in a foreign country and you are not lost in translation…..

Guess what; google translate is available as a function in the google spreadsheets…. You can translate between any language pairs...almost..

Let’s see how this function works.

Open up a new spreadsheet and let’s say you have english language in column A and you want german language in column B. So, the function would be: =Googletranslate(A2,”en”,”de”)

Now these ISO codes can be found online. Just search for ISO language codes and you will get the ISO 639 codes from various sources.

It might happen sometimes that you are not aware of the ISO code of the source language or you do not know the source language at all. In such case, for the source language you can type auto in quotes for the source language and google will automatically detect the source language.

Now let’s try translating one sentence into multiple languages using Google translate function…..I am trying Spanish French Intalian Japanese and Arabic

See the results and check for yourself if they are correct or not. While using this function, the best practice would be paste the cells as values.

Wish that google would have allowed the agility of google translate to be used in Microsoft excel as well...but at the end of the day they are competitors. So, let’s try to get the best of both worlds.

One thing I have noted personally is that google translate in general does falter for longer sentences; so it is better to be used as a translator for labels or simple sentences.

------------------------

Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners. Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1 Want some focused playlists. Click here and lean back: The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401 Excel basics if you have just started: https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQY ... https://www.youtube.com/watch?v=ot4FYPLRa2o