Google Blogoscoped

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")


=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.


Blog  |  Forum     more >> Archive | Feed | Google's blogs | About


This site unofficially covers Google™ and more with some rights reserved. Join our forum!