Knowledgebase: Localization
Google Translations
Posted by Gian Luca De Bonis, Last modified by Gian Luca De Bonis on 27 September 2010 01:30 PM
How to translate the Excel file by using Google Translation services?

1) Use the Import/Export function to export your phrases and translations as Excel
2) Upload the document to Google Docs
3) Go to the first cell to translate (F2) and write the following formula:
=GoogleTranslate($C2, $D2, F$1)
4) copy the formula to the other columns in the same row
5) copy these cells (from F2 to the last column) to the rest of the document
6) Download as Excel
7) Revise the Excel file
8) Use the Import/Export function to import the Excel file

Note:
1- use it as a draft translation
2- Google puts a space between the at sign (@) and the number. Revise those cells (indicate parameters as @n, where n is a number between 1 and 9 or a letter between A and I)
3- Google doesn’t understand PB special strings (e.g.: ~r~n). Revise those cells.
(7 vote(s))
Helpful
Not helpful

Comments (0)