You can now use functions in spreadsheets that can automatically detect and translate languages.
Standard, Premier, Education, Team and Partner Editions
All languages supported by Google Spreadsheets
How to access what’s new:
To detect and translate languages on a spreadsheet, use the new functions:
For the translate function, the fields should contain a combination of the text you want to translate, the two letter language code of the text and the language code you want the text to be translated into.