What's on this page:IntroductionCombining Responses from Identical SurveysCombining Responses from Dissimilar SurveysMore Information
If necessary, you can combine response data from two surveys. The steps differ depending on whether you are combining data from two identical surveys or two dissimilar surveys (not recommended).
Combining Responses from Identical Surveys
- Decide which survey you would like to use to hold the combined data. This can be one of the two surveys you’re combining or a third, empty copy of the survey (recommended, as it allows you to preserve the two original datasets separately).
- Export the dataset(s) from each survey as CSV files and save them to your computer.
Qtip: Make sure that you export as numeric values (the default) and not as choice text. See the linked page on exporting data for more info on this.
- Navigate to the Data tab of the Data and Analysis module for the survey that will hold the combined data.
- Click Tools and choose Import Data.
- Click Browse and select the file you want to import (note that if you are importing the data into a survey that already holds one of the datasets, import only the second dataset; if you are holding the data in a third copy of the survey, import both datasets).
- Click Import Responses.
- Repeat this process with each survey you need to combine until all data is in one survey.
Combining Responses from Dissimilar Surveys
If you are combining the responses from two surveys that are not identical, there are extra steps you’ll need to take to make sure that the data is imported correctly. You’ll need to create a hybrid survey that can hold data from the two nonidentical surveys and then create a hybrid dataset.
For the purposes of instruction, we will call one of the two surveys you’re combining Survey 1 and the other Survey 2.
To create a hybrid survey
- Create a copy of Survey 1.
- In the Survey 1 copy, add any questions from Survey 2 that are not already present (when finished, you will have a survey with all the questions from Survey 1 and all the questions from Survey 2).
To create a hybrid dataset
- Export the data from Survey 1 and from Survey 2 as CSV files.
- Download the Example CSV file from the hybrid survey (this file won’t have response information, but it will have column headers and will serve as a template).
- Open the hybrid file in Excel.
- Copy your data from Survey 1 and Survey 2 into the columns for corresponding questions in the hybrid file (if you added all the questions from Survey 2 the end of the hybrid survey, you will easily be able to copy your Survey 2 data in a block to the hybrid template).
- Save the hybrid file as a CSV.
To import a hybrid dataset
After clicking Import Responses, you may receive error messages. Error messages do not automatically mean that there is something wrong with your data, but there might be inconsistencies between the original data files and the template. Check the following:
- The data matches up with the column headers in the template
- There are no empty data fields for questions with validation (e.g., a respondent didn’t answer a question that now has Force Response)
- The question values are recode values and not choice text
- The question recode values are the same in the original surveys and in the hybrid.