Imported Data Projects
Imported data projects allow you to use data from other external sources to analyze in Qualtrics. These project types are particularly useful for analyzing your operational data collected outside Qualtrics with your experience data collected inside Qualtrics.
Preparing a File for Import
Your file can be saved in the following formats: .xlsx, .csv, .tsv, .sav (SPSS), and .xls. You can also upload those files in compressed form by using the format [filename].[file type].zip (e.g., mydata.csv.zip, odata.xlsx.zip). Stats iQ can also take Triple-S files, which must be imported in a compressed format (myfile.sss.zip).
The first row of your file should contain the headers for each of the fields you’d like to import. These headers will end up being the names of the fields in your project, so make sure they’re clear and concise. Under each header, enter the data for each participant.
Qtip: Your file should contain only one header row. If you export data from a Qualtrics survey to use in an Imported data project, be sure to delete extraneous header rows.
Formatting Multiple Answer Data for Import
You are able to import multi-value fields such as from a multiple answer survey question. As shown below, you are able to import them as one of the following:
1. One column containing the results for all answer choices.
2. The multi-value data split into individual columns.
After successfully importing the multiple answer data, the data will be available to be used as a variable in Stats iQ.
Creating an Imported Data Project
- Either navigate to the Catalog or click Create project on the Projects page.
- Scroll, filter, or search as needed to find the correct project type.
- Select Imported data.
- Click Get Started.
- Name your project.
- If desired, place it in a folder.
- Choose how you want to upload data to Qualtrics. You may choose to either Upload from a file, or Paste data. The following steps will go over using both options.
- If you choose Upload from a file click Select a file and select the file you prepared. The project name will match the file you uploaded, but you can change this if desired.
- If you choose Paste data, you can paste data from Google Sheets or Excel. Remember to name your project.
- When you’re ready, click Next.
- Choose your Unique id field. This field will be used to deduplicate data entries if they have the same value for this field. Your chosen field will have an id label next to it in your data set.
- If needed, adjust the Field type for your imported fields. The field type determines how the data can be analyzed and displayed in dashboards. The available field types are:
- Numeric value: A number, with infinite possible values. In CX dashboards, this is a numeric value field type, and in Stats iQ this is a number variable type.
- Number set: A set of numbers that has a finite set of values (i.e. scale from 1 to 5). In CX dashboards, this is the number set field type, and in Stats iQ this is a number variable type.
- Date: A calendar date. In CX dashboards, this is the date field type, and in Stats iQ this is a times variable type.
- Text value: A one or two word value, with infinite possible values. In CX dashboards, this is a text value field type, and in Stats iQ this is a text variable type.
- Text set: A one or two word value with a finite set of values (i.e. on a scale from very satisfied to very dissatisfied). In CX dashboards, this is a text value field type, and in Stats iQ this is a categories variable type.
- Open text: Longer blocks of text. In CX dashboards this is an open text field type, and in Stats iQ this is a text variable type.
Attention: To analyze your data in Text iQ, you must have at least one open text field. If your project does not have an open text field, then you will not be able to access Text iQ.
- Click Finish.
When you’re on the Project page, you can click the dropdown to the far-right of a project for more options.
- Collaborate: Collaborate the project with other users
- Rename Project: Rename the project.
- Delete Project: Delete the project. Only do this if you are absolutely sure! Deleted imported data projects cannot be recovered.