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

@POS POSCertainly, happy to help!1. Here are the steps to create the workflow.Select the option Survey responseMake your selections for optionsAdd a taskThis is the name of the task for adding rows to an Excel table. You’ll have the option to add a user account and then connect your Microsoft account.From there you can select your Excel Workbook, both SharePoint and OneDrive for Business documents have appeared here for me. You then choose your Worksheet and Table. Add your fields and map your survey response data using piped text.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.

@nryalls - Thanks for the steps. Will be trying this and post back shortly.

How to export qualtrics survey results to sharepoint/one drive

How to export qualtrics survey results to sharepoint/one drive | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded