Data & Analysis in Imported Data Projects
About Data & Analysis in Imported Data Projects
Data & Analysis is a tab where you can view and manage the data in your project. Here, you can filter, classify, merge, clean, and statistically analyze your response data. This support page will explain the features available in the Data & Analysis tab of an imported data project.
Re-Importing Data
Imported data projects are the only types of projects that allow you to re-import data. This means that rather than uploading all new responses, you can make changes to data that already exists in your project using a file upload.
Unique IDs
Imported data projects with unique identifiers are the easiest to re-import data for, because the unique ID is how Qualtrics recognizes which responses to update.
Unique identifiers can only be added to an imported data project when you first create it. See step 11 in the setup process.
Examples of unique identifiers include response IDs, customer IDs, employee IDs, or random number IDs you generated right inside the sheet.
Preparing a File
Your file must have the exact same headers your dataset has. You want to make sure no headers are missing and that every field rename is accounted for. To make this easy, we recommend exporting your data to use as a template for your updates.
- Go to Data & Analysis.
- Go to the Data section.
- Click Export & Import.
- Select Export Data.
- Select either CSV or TSV. Do not select Excel.
- Make sure Download all fields is selected.
- Click Download.
- Open the file in Excel or an equivalent software and make your desired edits. Do not add new headers or remove any headers. When you save the file, make sure CSVs are UTF-8 encoded, and TSVs are UTF-16 encoded.
Qtip: These are the changes you can not make to the data by uploading a file:
- Add a new field (instead, see Custom Field Creation)
- Remove a field (instead, see Removing a Variable)
Re-Importing Data
Once your file is ready, you can import it with a few easy steps.
- Go to Data & Analysis.
- Go to the Data section.
- Click Export & Import.
- Select Re-import Data.
- If your project doesn’t have unique identifiers, select Replace all existing data with the uploading data.
- Click Choose file and select the CSV or TSV you just edited.
- Click Re-import.
- Qualtrics will tell you when the import is complete. The page will then reload.
Importing New Data
To import new responses into an imported data project, you will follow many of the same steps you take to re-import data. There are just 2 differences:
- If your project has unique identifiers, make sure the new responses have their own unique identifiers that do not match any other existing response. If unique identifiers match, data will be overwritten.
- If your project does not have unique identifiers, make sure you do not select Replace all existing data with the uploading data.
Qtip: These are the changes you can not make to the data by uploading a file:
- Add a new field (instead, see Custom Field Creation)
- Remove a field (instead, see Removing a Variable)
Editing Fields
The Field Editor is located in the Data section of the Data & Analysis tab. Here, you’ll see all the fields in your imported data project and be able to make edits, such as renaming fields, recoding values, changing field types, and removing fields.
To learn more about all the ways you can edit your fields, see Editing Custom Variables.
To create a new field altogether, see Custom Field Creation.
Exporting Data
Exporting data from an imported data project is very similar to exporting data from a survey project. There are just a few key differences.
Export formats
You can only export data in a CSV, TSV, or Excel (XLSX) format.
Export options
Imported data projects only have the following export options available when you click More options:
- Compress data as .zip file
- Use commas for decimals
- Remove line breaks
See Export Options for a description of each.
Other Features in the Data Section
A lot of functionality in the Data section works the same as it does in survey projects. Here’s a list of support pages covering this functionality:
- Recorded Responses
Qtip: Imported data projects only allow you to view 1 page of responses at a time. That means filtering or selecting data in bulk will be limited to 1 page of responses.
- Filtering Responses
- Custom Field Creation
- Response Editing
- Translate Comments
Qtip: Make sure comments you want to translate are set to open text.
Other Features in Data & Analysis
The Data section isn’t the only one in the Data & Analysis tab. The following is a list of features available in imported data projects, so long as they have already been purchased for your license.