Exporting data from Snap XMP Desktop to Excel

This worksheet shows how you can export response data from your surveys in Snap XMP Desktop to other applications, such as Excel. The example is based on the Crocodile Rock Cafe survey supplied with Snap XMP Desktop.

Step 1: Export response data in Excel format

  1. Open the survey and click on the Data Entry button DataEntryIcon.png  to open the data entry window.
  2. From the main toolbar select File | Export. This opens the Data Export window.
Data Export window with the destination file selected
  1. In Format, select Excel (CSV) for exporting the response data in a format for Excel.
  2. In the Destination section, select File showing the response data will be exported to a file. A temporary file name is generated that can be changed, if required. Alternatively, click Browse to select an existing file.
  3. In the Export section, you can enter Filter that specifies the response cases to export, and Content to export specific questions in the response cases. If you want to export all questions and responses leave Filter and Content blank.
  4. In the Export Options section, select Expand Multiples when you want to expand multiple choice questions into individual columns – that is one column per answer rather than one column per question. Select Code Labels to export the codes as labels rather than numerical values. Select Label Row if you want to export the question text as a second header row in the CSV.
  5. Click OK. A message showing the number of cases exported to the file is displayed. Click Done to close the window.
Message showing how many cases were exported

Step 2: View response data in Excel

  1. Open Excel.
  2. Browse to locate your saved file. Set the file type to All Files to show files with extensions other than XLS (Excel files).
  3. Open up the file and view the data.
Example of data responses exported from Snap Desktop to Excel

If there is a topic you would like a worksheet on, email to snapideas@snapsurveys.com