Friday, October 2, 2009

Function to Translate Google Spreadsheet Cells

Google Spreadsheets has two new functions. One will let you auto-translate the contents of a cell. In my sample document containing German quotes in the second column, I used the following function for the third column:

=GoogleTranslate(B2, "de", "en")

i.e.

=GoogleTranslate(text, sourceLanguage, targetLanguage)

That’s potentially very useful I think. The other new function is DetectLanguage, telling you which language a given text has. You can also combine the translation function with other dynamic functions; for instance, in one cell you could use =GoogleLookup("US", "president")* and in another cell reference that result to translate it to Chinese.

[Via Tony.]

*It fails to name the current president, though.

Function to Translate Goo ... by Philipp Lenssen | Comments (2)

>> More posts

Advertisement