Export data file in SPSS format

Compatibility: IdSurvey 6 IdSurvey 7

With IdSurvey you can export all the data collected in different formats from the “Export Results” page you can reach by clicking on the “Tools” icon on the survey menu.

In this article we will focus on SPSS format.

The system will export by default all the results of all the interviews collected for that survey.
By clicking on “Filter by Date” in the “Setting” box on the left, you can filter data to export according to a specific time frame, selecting days using the “From” – “To” fields.
Only the interviews included in the time frame selected will be exported.

Note

  • You can set filters only for exportation in SPSS, CSV, TXT format. The exportations in ACCESS format always includes all data collected.

By clicking on “Contact fields”, you will choose which contact fields (among those uploaded in the contact database) you will export in the data file. These fields will be the first column of the exported file. To quickly select or deselect all contact fields, just click on the round button on the bottom right under the list.

To save the chosen columns for future exports click on “Save export field” and the system will automatically register the action.

Instructions

In the TXT box select the type of interviews to export (complete or incomplete). Click on “Export” and wait for the exportation to be concluded then click on “Close”.

In the “Export history” you will see the list of all the exports that were done.

Note

  • Exportations will be deleted after 3 days from creation.

IdSurvey creates a zipped folder with 2 text files to export to SPSS: a variable file (the name ends with _var) and a data file (the name ends with _dat).
Save the files on your computer, open the variable file and substitute in the third link (e.g.: /FILE=‘physical-path\2014_02_19_154442_dat.txt’) the physical-path string with the real physical path of the data file you saved.
The file is ready to be analyzed with SPSS choosing “New Syntax” and copying the variable text.

export_data_SPSS

Open SPSS export with Excel

You can also open an SPSS file using Excel. In this case open Microsoft Excel and click on “Data” -> “From text”.

Select data file (_dat) contained in the SPSS export folder. In “File origin” choose Unicode UTF-8, write in “Other” the symbol “§” as delimitation, select all columns and set the format as “Text”. Click on “End”.

Leave A Comment?