Translate Cells in Google Spreadsheets with this Function

Translate Cells in Google Spreadsheets with this Function

Google Docs recently introduced some new functions to help you translate individual cells in a spreadsheet from any one language to another or for detecting what language is being used in a particular spreadsheet cell.

 

Translate Cells in Google Spreadsheets with this Function

The syntax is so easy to implement:

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

So if you would like to translate the text contents of cell A1 from English to Hindi, you can use the following translate function.

=GoogleTranslate(A1, "en", "hi")

If you leave out the target language (in this case, “ar”) from the function, the GoogleTranslate function will automatically convert that text into the default language of your spreadsheet.

Google Translate Languages

This is a list of languages and their ISO languages Codes that are currently supported by Google Translate. When sending the translation request to the Language Translation API, as in the case of translating RSS Feeds, always make sure that the two language codes are different.

Language Name	Code	Language Name	Language Code
Afrikaans	af	Irish	ga
Albanian	sq	Italian	it
Arabic	ar	Japanese	ja
Azerbaijani	az	Kannada	kn
Basque	eu	Korean	ko
Bengali	bn	Latin	la
Belarusian	be	Latvian	lv
Bulgarian	bg	Lithuanian	lt
Catalan	ca	Macedonian	mk
Chinese Simplified	zh-CN	Malay	ms
Chinese Traditional	zh-TW	Maltese	mt
Croatian	hr	Norwegian	no
Czech	cs	Persian	fa
Danish	da	Polish	pl
Dutch	nl	Portuguese	pt
English	en	Romanian	ro
Esperanto	eo	Russian	ru
Estonian	et	Serbian	sr
Filipino	tl	Slovak	sk
Finnish	fi	Slovenian	sl
French	fr	Spanish	es
Galician	gl	Swahili	sw
Georgian	ka	Swedish	sv
German	de	Tamil	ta
Greek	el	Telugu	te
Gujarati	gu	Thai	th
Haitian Creole	ht	Turkish	tr
Hebrew	iw	Ukrainian	uk
Hindi	hi	Urdu	ur
Hungarian	hu	Vietnamese	vi
Icelandic	is	Welsh	cy
Indonesian	id	Yiddish	yi