Analyze Qualtrics data in Excel

The OfficeReports add-in adds a complete crosstab tool to Excel, so you can create tables and charts from your Qualtrics data directly in Excel. OfficeReports is a crosstab tool just like SPSS Survey Reporter, Wincross or Marketsight, but the user-interface is just a ribbon tab in Excel. Just have a look at the header picture of this site to see the functionality OfficeReports adds to Excel. Next we will explain how to report your Qualtrics data using OfficeReports.

Step 1: Export data to SPSS

The SPSS data format contains most information about your survey and is therefore a better data format than Excel and CSV. You do not need to have SPSS installed, OfficeReports can import the resulting 'sav' file without any problem.

To download SPSS data from Qualtrics, please do the following:

  1. On the 'Data & Analysis' tab, click 'Export/Import -> Export Data'.
  2. In the next dialogue box, select SPSS.
  3. Click the Download button at the bottom.

Step 2: Import the data in OfficeReports

Please do the following:

  1. If you did not yet install OfficeReports, please download and install OfficeReports first.
  2. Open Excel, open a workbook and click the 'OfficeReports' ribbon tab.
  3. A window will popup asking you to import data. Please click the first option "Import SPSS 'sav' file"
  4. A new window pops up after reading the SPSS data file. Please click 'Start' and the data will be imported.
  5. Now, a window pops up showing the data and the variables you have imported. From here you can recode your variables and start creating tables and charts. Please read more about OfficeReports Analytics by clicking one of the buttons below.