Very cool! The ability to detect the language of text in the cell of a spreadsheet, and then translate it into the language of your choice. I’m not sure how I would use it in my daily job, but it certainly would come in handy when translating labels on a web site into multiple languages. So how does it work? Here’s an example of the two key functions:
- =GoogleTranslate(“Oi, como está?”,”pt”,”en”) gives “Hi, how are you”
- =DetectLanguage(“Oi, como está?”) gives “pt”
I saw this in a Google Docs blog post.