Hi All,
Is there a way I could automatically export survey results in excel and place it in sharepoint or one drive.
This process needs to be automated to even capture new responses.
Please advise would be helpful.
Thank you
Solved
How to export qualtrics survey results to sharepoint/one drive
+1Best answer by nryalls
1. Here are the steps to create the workflow.
2. This will not pull in already collected responses as the workflow starts when a new response is collected. However, because you have to build the table prior to setting up the workflow I found it easier to do a full data export from Data & Analytics tab and use that to create my table. I then crossed reference the last Response ID from my export with the first from the workflow to ensure I didn’t have any missing.
+14Hi
You will have to set up the table first and then tell the system which question should apply to which column.
+1- What has to be selected here?
- Will this also get the responses which were already submitted (i.e. can the responses which were already submitted before creating workflow also be extracted into the excel in SharePoint)?
- Will this also get the responses which were already submitted (i.e. can the responses which were already submitted before creating workflow also be extracted into the excel in SharePoint)?
+14
1. Here are the steps to create the workflow.
2. This will not pull in already collected responses as the workflow starts when a new response is collected. However, because you have to build the table prior to setting up the workflow I found it easier to do a full data export from Data & Analytics tab and use that to create my table. I then crossed reference the last Response ID from my export with the first from the workflow to ensure I didn’t have any missing.
+1+14I ran into some trouble with this as well - but largely because we have so many files in the location I saved the worksheet. Qualtrics suggested reindexing the library. I eventually did use a file in my OneDrive as it was the quickest solution I could find and my use case had a tight turnaround time.
I did found this post about using API connections to do the same feature.
I just tried to search in the Excel task again and I saw that SharePoint libraries with a lot of data are not appearing compared with smaller libraries. Sorry I can’t help more than that.
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.