Skip to main content

XTM Connect - Google Sheets 7.2

Mapping the source and target languages for single source text column translation

This topic is only applicable for single source text column translation, not for translating entire Google Sheets.

XTM Connect – Google Sheets recognizes columns in a Sheet by their letters (on the left of the Google Sheets) screen) and the contents of the cells in the first row (cell A1) and the other columns to the right of it. Before requesting translation of the source texts in a particular column, you must map that column's name to the XTM Cloud source language and map the appropriate target language column names to the relevant XTM Cloud target languages. The form recognizes the columns and their names, which can be any custom names of your choice: they need not necessarily be language codes. For example, they could be something else that suits your organization's needs, such as the names of in-country subsidiaries.

Note

You must map language values to the language codes that have been configured for the selected customer in XTM Cloud.

Example: source text in English (UK), in column A, target languages Danish (column B), French (column C) and German (column D)

In this case, the language values in Google Sheets and in XTM Cloud would be as follows:

Google Sheet cell

Value in Google Sheet cell

XTM Cloud language code

What does each column contain?

A1

English

English (UK)

The A column contains the source texts that are to be translated into the other languages. Note that the language code here and below also specifies which language variant is required. For example, instead of "UK", the source language could have been for Canada, and would have said "(Canada)".

B1

Dansk

Danish

The B column will contain the Danish translations for the source texts listed in column A.

C1

Français

French (France)

The C column will contain the French translations for the source texts listed in column A.

D1

Deutsch

German (Germany)

The D column will contain the German translations for the source texts listed in column A.

In the XTM Panel, these settings will be in this layout:

Source

Target

A - English

English (UK)

B - Dansk

Danish

A - English

English (UK)

C - Français

French (France)

A - English

English (UK)

D - Deutsch

German (Germany)