In this article
You may find that the question labels used in a survey in your hub arenot suitable to be used in your reports; the labels may be too long, or inappropriate. In this event you can download from the hub an Excel document containing the existing labels for the questions in a survey. You can then edit the label texts in the spreadsheet, and upload the same spreadsheet back to the hub and over-write the original label texts with your new texts.
This allows you to create shorter, better texts for use in reports and dashboards than those used in the survey. The new texts will take effect in the reports the next time the survey is synchronized, and will affect any reports based on that hub Reportal, Active Dashboard, Discovery Analytics, Studio). You can do this for surveys, combined surveys and contact databases.
In SmartHub, click the Surveys icon in the sidebar.
From the surveys list at the bottom, click the survey you want edit the question labels for.
Click the Override Labels button in the top right corner. This opens the "Import Override Labels" menu.
In this menu, click the Download button next to Step 1. This downloads an Excel file that acts as a template, containing existing labels and overrides. This file lists all the labels used in the selected survey, with the variable labels, variable texts, and variable list items presented on separate sheets.
Open the downloaded Excel template from your browser or downloads folder.
Edit the texts as required. For example, if you wanted the text for the Status variable in row 28 to read just "Status" in English instead of "Interview Status", you would type the word Status into cell D28 (highlighted yellow in the image below).
Save your changes.
Back in the "Import Override Labels" menu, click the Browse button.
Select the Excel file you just saved and double-click it.
Click the Import File button. The new texts will take effect in the reports the next time the survey is synchronized, and will affect any reports based on that hub.
Note: The Level column indicates the level in a loop where the variable is located and <root> indicates the variable is in the top level.
Note: If you download the Excel file again after having performed an override, the Excel file will have <overridden> in the column for the original labels where those labels have been overridden. If you want to go back to the original text, delete the text that has been added in the override column.