Skip to main content

XTM Connect - Google Sheets 7.2

Translating a single source text column in a Google Sheet

When you want to send texts for translation from a single source text column in a Google Sheet, you have two choices:

  • Send the entire column, containing source texts, for translation.

  • Choose a range of source column cells containing texts that you want to send for translation. The texts in other source column cells will not be translated.

In both cases, you also specify the columns to which the translations into the specified languages are to be returned. For details, see To request translation for the text in a column: below.

To request translation for the text in a column:
  1. In the Google Sheet that contains the source texts, log into XTM Connect – Google Sheets,.

    Note

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

  2. In XTM Connect – Google Sheets, for the selected Customer, next to Translate, select Column.

  3. If necessary, map the source and target language pairs. See Mapping the source and target languages for single source text column translation for details.

    Note

    To add and define multiple language pairs, select the plus icon circle-plus-blue.png.

    To delete an unneeded language pair, select the trash bin icon trash-grey.svg.

  4. If you want to give additional information or context to Linguists, or specific instructions to them about a translation task:

    1. Select the optional Add comments checkbox.

    2. After selecting the Add comments checkbox, select the following:

      Source. Select the column (in your Google Sheet) that contains the source text that a comment is about. That is essential information for the Linguist who reads the comment.

      Comment. Select one or more columns (in your Google Sheet) that contain information for the Linguist who reads the comments about the content. This enables you to provide the Linguist wtih several different comments about each source text segment. This information might, for example, be:

      • some (different) metadata about the source text In each line in the Sheet.

      • text length restrictions.

      • other reference information.

      All these different kinds of information must be present in the Sheet columns that you specify for the different comments. In your Sheet, you could even have a column called "Comment" which contains comments about the texts in that Sheet.

      Example (fictitious Sheet)

      In the Add Comments Source dropdown, select A to select column A, which is called "German" and contains the source texts list. Then, in the Add Comments Comment dropdown, select column C, which is called "Comment" and contains comments written about the source texts in column A.

    3. Optionally, to specify how comments are to be displayed to Linguists in XTM Cloud when they are translating these texts, select the more actions icon ellipsis-h-solid.svg next to the specified Comment column. Select whether comments should Show in XTM Cloud as:

      • Comments: comments will be displayed in a docked panel with the chat icon comment-solid.svg and a small text bubble will be displayed in the Status area at segment level. (These comments will not be translatable.)

      • New column: comments will be displayed in their own separate column in XTM Workbench, at segment level. (These comments will not be translatable.)

      Note

      To add and configure more comments, select the plus icon circle-plus-blue.png at the bottom of the comments list in the XTM Panel.

      To delete an unneeded comment, select Delete row (trash bin icon trash-grey.svg).

  5. Optionally, set the minimum and/or maximum target length for translations. It is useful to set these limits for content such as UI texts, whose translations need to fit in a particular space. The settings you make here are segment-specific. They are passed to Linguists to help them ensure that the translations they produce stay within the required translation lengths. To so so:

    1. Select the Monitor target length checkbox.

    2. After selecting the Monitor target length checkbox, select the Source and Target length column pair to specify the column in which the target length needs to be.

    3. To set one of the following Target length types, select the three dots icon next to the defined Target length:

      • Min. target length: the translation in a particular segment must not contain less than the specified number of characters.

      • Max. target length: the translation in a particular segment must not contain more than the specified number of characters.

      Note

      To add and define multiple target lengths, select the plus icon circle-plus-blue.png.

      To delete an unneeded target length, select the Delete row with the trash bin icon trash-grey.svg.

  6. 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.

    You can then either:

    • Save as default: save all the settings defined for XTM Connect – Google Sheets, such as language mappings and project templates, as default settings. These will be loaded automatically whenever you log in to XTM Connect – Google Sheets again.

      For example, if content is added to a sheet in the future, in lower rows, and you open the sheet again, the XTM Connect – Google Sheets form settings for that particular sheet will be applied.

    • Restore defaults: reset any settings that have been made and replace them with the original settings.

  7. 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.

  8. Optionally, if you do not want to save the settings you have made as defaults (in the Project template area), you can perform the following actions in the Configuration template area:

    • Import: if you have not defined any XTM Connect – Google Sheets settings (and saved them as defaults in step 5.), you can import them (in a .json file).

      See Reusing an XTM Connect – Google Sheets configuration in a new Sheet.

    • Export: you can export your XTM Connect – Google Sheets settings to a .json file, save them and have them ready to import next time you want to apply them to a sheet.

  9. Optionally, you can select these links:

    1. Show advanced settings. Select this link to display the advanced Clear sheet's memory option in the add-in form. (The Show advanced settings link changes to Hide advanced settings).Then, to clear all the memory that is associated with your sheet and settings, select the Clear sheet's memory button.

    2. Hide advanced settings. Select this link to hide the advanced Clear sheet's memory option in the add-in form. The link name changes back to Show advanced settings.

  10. Once you have made all the settings, you can select content for translation. In your Sheet, you can:

    • select a range of cells in your source column and send it for translation.

      Note

      You can use the Ctrl or Shift buttons to make the selection.

    • send your entire source column for translation (from row 2., so that you exclude the column header in row 1.). To include the entire column, do not select a range of source column cells for translation. If you request translation of all the texts in a specific column, a translation project will be created it in XTM Cloud.

    Note

    The target cells in the rows you want to translate must be empty. No matter whether you want to send a range of cells or the entire source column for translation, from row 2., you must select the required cells (they are marked in the Sheet, so you can see which ones have been selected). Otherwise, cell contents are not translated.

  11. To send the selected text for translation in XTM Cloud, select the Request translation button at the bottom of the XTM Panel. A project creation popup is displayed.

  12. Select the OK button. The popup closes. When the translation has been requested, the cells in the columns into which the requested translations are to be returned 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.

  13. Once translation is finished in XTM Cloud, XTM Connect – Google Sheets is notified. The cells in the Google Sheet columns intended to receive particular target language translations are then filled with the 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.