{"id":8080,"date":"2020-04-04T16:31:16","date_gmt":"2020-04-04T21:31:16","guid":{"rendered":"https:\/\/jessicaeblack.org\/research\/?p=8080"},"modified":"2020-04-04T16:31:35","modified_gmt":"2020-04-04T21:31:35","slug":"downloading-data-from-qualtrics","status":"publish","type":"post","link":"https:\/\/jessicaeblack.org\/research\/downloading-data-from-qualtrics\/","title":{"rendered":"Downloading data from Qualtrics"},"content":{"rendered":"\n

Below is a step-by-step how-to for downloading data from Qualtrics<\/a>. I’ve had to tell people how to do this many times. It doesn’t take long (it’s easy), so I am only now getting around to writing a blog on the topic. (Mainly because I will soon be leaving my lab. This will provide an easy-access resource!) Please let me know if I have missed anything or if you have any additional questions. <\/p>\n\n\n\n

Take me directly to:<\/h5>\n\n\n\n

Understanding the Data & Analysis screen<\/a>
Selecting the download file format and variables<\/a>
Output for Randomization<\/a>
Downloading the data<\/a><\/p>\n\n\n\n

OU users: your institution’s Qualtrics link is https:\/\/ousurvey.qualtrics.com\/<\/a>.<\/p>\n\n\n\n

Step 1<\/h2>\n\n\n\n

Go to Data Analysis.<\/p>\n\n\n\n

\"\"
On the survey screen (where Qualtrics takes you upon opening a new project), select the Data & Analysis tab.<\/figcaption><\/figure><\/div>\n\n\n\n

Step 2<\/h2>\n\n\n\n

On the Data & Analysis screen, you can see the most recent completed cases with the data they provided in selected columns. To hide the default columns, click on the header and select Hide Column. To add columns you want to see, hover over the header and click on the + sign that will appear. Select the one you want to add. I always add Duration (under Survey Metadata), because I want to know if people are taking more or less time than I expected.<\/p>\n\n\n\n

\"\"
To add a column to the Recorded Responses screen, hover over the Header, click on the plus sign, and select the data you want to add.<\/figcaption><\/figure><\/div>\n\n\n\n

Before downloading data from Qualtrics, make sure all your responses have been recorded. Below, the survey on the left has only recorded responses. If you have already paused data collection, Qualtrics will have given you the option to record all open responses or leave them open. <\/p>\n\n\n\n

\"\"<\/figure><\/div>
\"\"<\/figure><\/div><\/div><\/div><\/div>\n\n\n\n

The survey on the right above still has three responses in progress. Click on the link to see them.<\/p>\n\n\n\n

\"downloading
The screen for Responses in Progress shows you the start time, last activity, scheduled expiration, the last question the respondent answered, and the overall progress. The expiration depends on the option you chose under Survey Options on the Survey tab. You can set Qualtrics to record partial responses at 4 days to up to one year after the last activity.<\/figcaption><\/figure><\/div>\n\n\n\n

On the Responses in Progress you can see each participant’s progress. If you click on the Survey session ID, you can see all the responses given thus far. You will have to decide whether to delete or record partial responses. 96% complete responses, for example, should clearly be recorded; 5% complete should be deleted. Everywhere in between just depends on your survey and research design. <\/p>\n\n\n\n

\"downloading
Select the responses you want to close (record) or delete, and then click on “With Selected” and choose the appropriate action.<\/figcaption><\/figure><\/div>\n\n\n\n

Step 3<\/h2>\n\n\n\n

Once you have recorded all the partial responses you want, go back to the Recorded Responses page. Click on Export & Import, then Export Data.<\/p>\n\n\n\n

\"\"<\/figure><\/div>
\"\"<\/figure><\/div><\/div><\/div><\/div>\n\n\n\n

You can export data in various formats. I will demonstrate the basics using the Excel and SPSS format.<\/p>\n\n\n\n