All Collections
Working with exports
Long Excel export
Merging results from multiple surveys
Merging results from multiple surveys

Our in-house data analysts give their advice for compiling duplicate surveys into one sheet for analysis

Parm Bansil avatar
Written by Parm Bansil
Updated over a week ago

Our Long Excel export makes merging data from multiple surveys as easy as copy and pasting results into a single spreadsheet. The only difference between data sets could be a different number and nature of demographic columns, if you're combining surveys from multiple countries.

Merging the results from surveys run in the same country

Surveys run in the same country will have consistent columns across every data set. In order to combine the results from two or more survey exports, select which export you'll merge the other results into and then:

  1. Navigate to the Master Data sheet in the survey(s) you're copying from.

  2. Copy all of the survey data (excluding the column headings as they'll already be in the destination file).

  3. Paste the copied data into the destination file in the rows under the existing data for that export.

You'll then have all survey data from the destination file grouped at the top of the sheet, followed by copied data from the next survey in the rows below, and so on. You can use the filters in the heading for the Survey GUID, Survey Title or Internal Title columns to narrow down to just a subset of the surveys in the sheet, or use any of these columns as columns in a pivot table to compare results from multiple surveys.

Merging the results from surveys run in different countries

Due to the different number and nature of demographic targeting available in each country you target through Attest, the process is slightly longer for merging results from surveys run in different countries:

  1. Navigate to the Master Data sheet in each of the survey exports you want to merge.

  2. You'll first want to compare the column headers in each sheet to identify differences. In a new sheet, copy and paste just row 1, the column headers, from each export below one another, including an extra column to identify the country each row is copied from. In this example, we can see that most columns are identical, but there are also some additional demographic columns in the GB survey.

3. Align the columns that match, exposing the differences between the surveys.

4. In a new row, copy and paste the column header present in each column, this is the new row we'll use as column headers in each survey before we merge them.

5. In the Master Data sheet in each of the survey exports create a new row above the existing row 1, and copy and paste in the new (yellow) column headers.

6. Next we need to align the data in the columns with the new column headers. Where the data and the new column headers don't match, select the data in that column, then copy and paste under the correct column header.

7. Repeat steps 5 and 6 in each of the exports you wish to merge.

8. Now each of the exports contain the same columns, so selecting a destination sheet you can merge all the exports using steps 1 and 2 in the section above this.

For any more help merging exports from multiple surveys, don't hesitate to reach out to our team of research experts via the in-platform live chat.

Did this answer your question?