Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I'm trying to translate a spreadsheet I've uploaded to Drive and converted to a Sheet. However there is no "Translate" option for me in the Tools menu, as per this article: http://support.google.com/drive/bin/answer.py?hl=en&answer=187189

I've attached what my Tools menu looks like. What am I doing wrong?

enter image description here

share|improve this question
2  
I've only seen that option in a Google Doc, but not a Google Sheet. –  Jacob Jan Tuinstra Dec 11 '12 at 7:48

4 Answers 4

up vote 2 down vote accepted

You can use the following formula to get text translated:

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

See reference: TRANSLATE

share|improve this answer

You can use Google translate to translate a spreadsheet (.xls or xlsx), and also pdf's, word doc's etc. - But they do not get saved into your Google drive.

http://translate.google.com/?tr=f&hl=en

Select "Choose file", browse for it on your local drive, the click on "Translate". Saving it out is a copy & paste affair unfortunately though

share|improve this answer

I wrote this short google apps scripts function that duplicates each sheet in a workbook, and translates the cells. The from and to languages are just function parameters at the moment, but it would be easy to add a prompt and/or use language detection.

function duplicatetranslate(inputLang, outputLang) {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = spreadsheet.getSheets();
  for (index = 0; index < sheets.length; index++) {
    spreadsheet.setActiveSheet(sheets[index]);
    var dup = spreadsheet.duplicateActiveSheet();
    var cells = dup.getDataRange();
    cells.setFormulaR1C1("=iferror(googletranslate('" + sourceSheetName + "'!" + 
       "R[0]C[0],\"" + inputLang +"\",\"" + outputLang + "\"),\"\")")
  }
}
share|improve this answer

You can use the following link:

http://translate.google.com/translate?hl=en-US&u={link-of-page}&sl=auto&tl=en-US

where the u parameter (u={link-of-page}) you can add the link of your Google Document

share|improve this answer
1  
I tried it, with both a Google Sheet and Google Doc, but wasn't successful. Even tried with and without curly brackets. Perhaps you can explain the procedure a bit more? –  Jacob Jan Tuinstra Jul 29 at 5:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.