About Combining Results
If you want to combine the data from two surveys, follow the steps below. The steps are unique depending on whether you are combining data from two identical surveys or two surveys that are not identical (not recommended).
Combining Data From Two Identical Surveys
- Select the survey you that would like to use to hold the combined data. If you would like to preserve the two data sets separately, create a third copy of the survey to hold the combined data.
- Download both data sets as .CSV files and save them to your computer.
- Open the survey that will hold the combined results and navigate to the Responses section of the View Results tab.
- Click Advanced Options and then click Import Responses.
- Browse to find the files that you want to import. If you are importing the data into a survey that already holds one of the data sets, you will only need to import the second data set. If you are holding the data in a third copy of the survey, import both data sets into the survey.
Once you are done importing the data sets, the data will be combined.
Combining Data from Dissimilar Surveys
If you are combining the results from two surveys that are not identical, there are extra steps to make sure that the data is imported correctly.
- Create a hybrid survey that can hold the data from two non-identical surveys.
- Create a copy of “Survey 1” to create “Survey 1 – Copy.”
- If there are questions in “Survey 2” that are not in “Survey 1,” recreate the “Survey 2” questions in “Survey 1 – Copy.” When done, you will have a survey with all of the questions from “Survey 1” and all the questions from “Survey 2.”
- Now that you have a hybrid survey, create a hybrid data set:
- Download the data from Survey 1 and Survey 2.
- Next, click your hybrid survey. Click the View Results tab, click the Download Data icon, and select to download the data as a .CSV. (This is just a template.)
- Open the .CSV file from your hybrid survey and use this file to organize your data set into one .CSV that can be uploaded to the hybrid survey. Copy your data into the columns for the corresponding questions in the hybrid template. 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.
- Once your hybrid data set is formatted and saved as a .CSV, go into the hybrid survey.
- Go to the Responses section of the View Results tab.
- Click Advanced Options and then click Import.
- Choose the file to import. When you preview the imported file, there are six columns that are being “ignored” by the system. This is normal and necessary for the upload to work correctly.
- Click Import.
Your data set will now be combined.
- If the data appears bunched up instead of neatly divided into columns when you preview, your template may not be separating (or “delimiting”) correctly. To fix, click the Import Options link to the right of your file name (in the Import Responses dialog box), and change the Delimiter to “Comma” (or to tab if comma is already selected). Your data should line up correctly. If it does, simply click Import, and you will be set.
- After clicking Import, you may receive error messages. Error messages do not automatically mean that there is something wrong with your data. As long as the data matches up with the column headers in the template, the most common reason for receiving an error message is an empty data field (a respondent did not indicate his or her gender for example). The only way to verify that the data matches is to open the Excel files and make sure there are no inconsistencies between the original data files and the template.
- If your file is not importing, it could be because of validation in your survey. To ignore validation while importing, select Do not validate when you are importing your file.
- In some cases, the .CSV file must be closed on your computer before it will upload.