Export a modern report to Excel

Export your report data as an XLSX spreadsheet and view the results in Excel. The Excel export presents an overview of the survey results by summarizing each question in a data table.

Prerequisites:

Ensure that your report is displaying the appropriate data before you export the report. For example, verify that the correct filters are applied and the required banners are included.

The report is exported as an Excel Workbook (.XLSX) file.

  1. Open the modern report.
  2. On the report toolbar click Export > Excel (Summary Data).
    Result: The Active Exports dialog is displayed while the export file is created. You can wait for the file to become available to download or return to the dialog later by selecting Export > View Active Exports.
  3. In the Active Exports dialog, click Download next to the report.
    When the download is complete, you can open the file from your web browser, or from the folder where it is saved on your computer. For example, in Google Chrome you can access the download from the top-right corner of the browser.

The exported file contains a worksheet with a summary view of the report including any banners and nested banners applied to the report.

Depending on the types of tiles included in your report, and the features enabled in the tiles, your report may include any of the following:

  • The summary view includes summary tables for crosstabs, Net Promoter Score℠1 values, sentiment analysis, and TURF analysis.

  • When you export a report that contains questions with sentiment analysis, separate crosstab tables are included for Positive, Negative, Neutral, and All responses.

  • If smart grouping is enabled for a tile, a crosstab is included for the tile with the groups identified and the counts and percentages for each group. For other/specify answers, the smart groups are displayed in a separate crosstab under the crosstab for the question.

For example, the exported information for a NPS® question includes the quantitative data. If the Sentiment Analysis tab was enabled for this question, additional tables with the results of the sentiment analysis would also be included.

The export does not contain any text data from other/specify questions, original responses for Open End questions, or follow-up responses for NPS® questions. For information on exporting open-ended responses and NPS® Follow-up responses from report tiles, see Export participant responses from modern reports.

Note: If the exported file's name contains square brackets, you may have trouble opening the file because square brackets denote linked files in Excel. Rename the file by removing the square brackets and try opening the file again.
1 Net Promoter, NPS, and the NPS-related emoticons are registered U.S. trademarks, and Net Promoter Score and Net Promoter System are service marks, of Bain & Company, Inc., NICE Systems, Inc. and Fred Reichheld.