Loading...
  • Customer Experience
    Customer Experience
  • Employee Experience
    Employee Experience
  • Brand Experience
    Brand Experience
  • Product Experience
    Product Experience
  • Core XM
    Core XM
  • Design XM
    Design XM

Imported Data Projects

What's on This Page:


Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!


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.

Once your data is imported into Quatrics, use Stats iQ, Text iQ, crosstabs, and response weighting to analyze your data. You can also use your project as a data source in your CX dashboards.

Qtip: Imported data projects do not have access to reports or other project features.
Qtip: Imported data projects are not currently available to all customers. If you are interested in getting access to this feature, please reach out to your Customer Success Representative.

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.

An exported data file that has the first row highlighted but the second and third scratched out

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.

Format of multi-value or multiple answer fields as imports into Stats iQ

After successfully importing the multiple answer data, the data will be available to be used as a variable in Stats iQ.

Variable describe view for multiple answer question in Stats iQ

Creating an Imported Data Project

  1. Either navigate to the Catalog or click Create new project on the Projects page.
    Create Project button in Projects Page, catalog from navigation hamburger menu
  2. Scroll, filter, or search as needed to find the correct project type.
    Filters and search bar along the top of the catalog, chosen project appears as a tile. Once the tile is clicked, a menu opens on the right with a description and a get started button
  3. Select Imported data.
  4. Click Get Started.
  5. Name your project.
    giving the project a name, choosing the folder, and selecting the import method
  6. If desired, place it in a folder.
  7. 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.
  8. 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.
    Import option with instructions, a button in the center for uploading a file
  9. If you choose Paste data, you can paste data from Google Sheets or Excel. Remember to name your project.
    Paste data option, with an open field where you can paste the data
  10. When you’re ready, click Next.
  11. 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.
    selecting the unique id field, changing the field types, and clicking finish
  12. 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.
  13. Click Finish.

Project Actions

When you’re on the Project page, you can click the dropdown to the far-right of a project for more options.

from the project page, clicking the project actions dropdown for an imported data project

  • 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.