Hi,
I'm looking for an Excel report of all the data from a survey in a usable format. Users must login to Qualtrics to download the CSV or Excel from the Data & Analysis tab, then transform the data after deleting unnecessary columns (i.e. Response ID, IP Address, etc.). Is there a trigger that can send an Excel report to a designated person on a daily basis that contains basic information like: name, email address, survey questions, and answers? Any help would be appreciated.
Brianna
Solved
Reporting - Excel Daily Email Trigger
+2Best answer by SpencerDT
Hi Brianne, one approach would be to click "reports" and click the "reports" subheader below next to the "results" header. You can create a custom report that has any fields you would like to include and set up a schedule that this report is shared.
An alternative method would be to set up an automation and connection to an SFTP server and set up parameters around what info you would like included. That is a little more complicated process, but might be what you are looking for if you would a format that can be opened in excel.
+1Hi Brianne, one approach would be to click "reports" and click the "reports" subheader below next to the "results" header. You can create a custom report that has any fields you would like to include and set up a schedule that this report is shared.
An alternative method would be to set up an automation and connection to an SFTP server and set up parameters around what info you would like included. That is a little more complicated process, but might be what you are looking for if you would a format that can be opened in excel.
+33I second the response export automation, https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/download-data/response-export-automations/
+2Those are the work arounds I've found so far. I wish the automation didn't involve connection to an SFTP server. Not a simple solution for this one, but thank you both for the help!
+1I agree, there should be a simple solution to this request, but I don't believe it exists. A simple way to add a filter to the data and analysis section and set up a daily automated export of that to send a csv file to an email address specified would be amazing. If you make that request I'll vote for it! This is something that has come up countless times at my organization.
Hi, I have an easy solution for this. We can export data to an email in CSV format at a specific time using the dashboard. Also, we can automate this process. In the Qualtrics dashboard, by using a widget record table, we can add all the required columns and apply filters. Then, in the download option, we have the option to Export Dashboard → Email Dashboard, where we can automate the process.
We can share the data in PDF/CSV formats as well.
Hi, I have an easy solution for this. We can export data to an email in CSV format at a specific time using the dashboard. Also, we can automate this process. In the Qualtrics dashboard, by using a widget record table, we can add all the required columns and apply filters. Then, in the download option, we have the option to Export Dashboard → Email Dashboard, where we can automate the process.
We can share the data in PDF/CSV formats as well.
Can you give more a step-by-step description of this process?
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.