Translating Dashboard Data

About Data Translations

Data translations (or “filter translations” in CX dashboards) are the data fields you’ve mapped to your dashboard (names and recode values). These fields are translated separately from the rest of the dashboard text, but these fields only need to be translated once, rather than repeating the process for each page filter.

Examples include:

• Field names
• Field values
• Category names
• Question statement names

Data translations are done slightly different depending on whether you have a data mapper or data model dataset. However, you can also just translate straight from the Translations tab, which is the same regardless of your dataset.

Translating Dashboard Data

These steps work regardless of whether your dashboard is EX or CX, and whether it uses a data mapper or a data modeler.

For a list of languages supported, see the Languages in Qualtrics page.

1. Click the gear to go to your dashboard settings.
   
2. Select Translations.
   
3. Set Translation type to Data translation.
4. Choose a file format (CSV or TSV).
5. Click Export the file to get an example file.
6. Open the file in a spreadsheet editor on your computer.
7. Add your translations to their corresponding language column. Here are some general tips:
   • See the List of Language Codes page for guidance about each language column.
   • Follow the file’s exact formatting for creating your translations.
   • Use the English column (EN) as a guide.
   • Copy and paste to ensure formatting is correct. Do not delete or rearrange the columns, as this will cause the import to fail and translations to be lost.
   • Do not delete the strings of numbers and letters – these are internal IDs that identify the parts of the dashboard you are translating.
8. Save your file as a CSV file with UTF-8 encoding or as a TSV.
   Warning: Once you’ve saved the file, do not open it again as this could cause you to lose formatting for any special characters.
9. In the product, click the Select a file button and select your translation file.
   
10. Click Import the file.

Other Places to Translate Filters

You can also translate filters in the Dashboard data tab of your dashboard settings. However, while most of the steps will be the same as what we described previously (exporting a sample file, editing a spreadsheet, and re-uploading it), the user interface varies.

Data Mapper

Data mappers are some of the most common datasets and look like the screenshots you see below.

1. Click Action.
   
   
2. Select Data Translation.
3. A new window will open where you can export an example file and re-import it. Use the same file formatting discussed here.
   

Data Modeler

Data models let you create joins and map data from very different sources together, such as surveys, tickets, and imported data projects.

1. Click the output dataset.
   
2. Go to Dataset Editor.
3. Click Actions.
4. Select Data Translations.
5. A new window will open where you can export an example file and re-import it. Use the same file formatting discussed here.
   

Deleting Dashboard Data Translations

The only type of dashboard translation that can be deleted this way is a data translation.

1. Open your data field translation file.
2. Add [DELETE] to the column header of the language translations to be deleted.Example: To delete the Spanish translation of your data, change the column header from “ES” to “ES [DELETE]”.
3. Go to your dashboard settings.
   
4. Go to the Translations tab.
   
5. Select Data translation as the translation type.
6. Click Select a file and select your translation file.
7. Once the file is selected, click Import the file.

Troubleshooting Translations

See the Dashboard Translation page for help opening files, previewing translations, fixing file formatting, and more.

Translation Compatibility

Widget Compatibility (CX)

The following widgets are compatible with data translations. Label translations refer to labels, widget names, and dashboard names. Data translations refer to categories and field names.

Widget Compatibility (EX)

The following widgets are compatible with data translations. Label translations refer to labels, widget names, and dashboard names. Data translations refer to categories and field names.

Understanding Data Translation Files

This section covers how to read an exported data translation file, which is shown below.

Each row of the exported file represents a single data translation. From left to right, the columns include:

• Unique identifier: The internal Qualtrics ID for the data translation field.
  Qtip: Recode translations and field translations that match each other will have the same value in the “unique identifier” column.
• Type: Identifies the type of data translation:
  • Labels: A recode translation of the field values (i.e. the different field values displayed in a widget or used in a dashboard filter).
  • Fields: A field name translation (i.e. the names of the fields that appear when choosing fields to display in a widget).
• Recode: The recode value.
• Language codes: Add the translated content in the associated language columns, identified by the language codes. Use your dashboard’s base language as a guide.