Export an Excel summary from modern reports

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.

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.

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.

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.

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.