Skip to main content

XTM Connect - Google Sheets 7.2

Translating an entire Google Sheet

You can translate an entire active Sheet into one or more languages: XTM Connect – Google Sheets will send everything in the Sheet for translation in XTM Cloud. Only one Sheet can be sent for translation at a time.

The form for translating an entire Sheet contains fewer options than for translating a column containing source texts, in a Sheet, into one or more languages. This is because, when you send an entire Sheet for translation, XTM Connect – Google Sheets creates a separate new Sheet for each of the target languages that you have selected. In contrast, when you send a column containing source texts for translation, you also specify the cells to which the target texts are to be returned, in the same Sheet.

Note

Unless you log out from XTM Connect – Google Sheets, your credentials are stored and reused. You are not asked to log in again.

To request translation for an entire active Sheet:
  1. For the selected Customer, next to Translate, select Sheet.

  2. In the Source language dropdown, select the source language.

  3. In the Target language dropdown, select the target languages.

  4. Optionally, in the Project template dropdown, select a project template to be used in XTM Cloud for the selected customer, if you want to apply one for your Sheet.

    This project template, in your XTM Cloud instance, contains all the preconfigured and preselected project settings that specify the target languages, how ICE matches are handled, workflows, etc. The project template will have been created for the selected customer and is used to automate project creation in XTM Cloud.

  5. Set a Due date for the project by clicking in the text box and using the calendar. If necessary, select the Time: Hour and Minute using the sliders. Then select the Done button.

  6. To send your Sheet for translation in XTM Cloud, select the Request translation button. A project creation popup is displayed.

  7. Select the OK button. The popup closes. When the translation has been requested, separate new tabs are created, in the Google Sheet. The name of each tab consists of the original Sheet name plus a suffix consisting of the relevant target language code. The cells intended to receive the translations, in these new tabs, are filled with the following data:

    • The DO NOT EDIT! Waiting for translation from XTM Cloud. placeholder text.

    • Date and time.

    • A cell ID.

    Warning

    Do not make any changes in these cells. The cell contents must stay intact to enable the translations to return.

    If you send an entire Sheet for translation, a separate project will be created in XTM Cloud for each of the target languages defined in the Sheet.

  8. Once the translation is finished in XTM Cloud, XTM Connect – Google Sheets is notified. The Google Sheet cells in the Sheet tabs intended to receive particular target language translations are then filled with the appropriate translations.

    Note

    In the case of translations into multiple target languages, when the source content has been translated into particular target languages, those translations can be returned to your Google Sheet, via XTM Connect – Google Sheets, without waiting for the other target language translations to finish. Consequently, you do not have to wait until the whole project is finished, to start checking or using some of the translations, when they are ready. For more information, see Retrieving finished translations manually.