Hi
I need to export survey response data including department and phone number. However, after I exported the data from "data and analysis tab" in excel format, the spreadsheet doesn't show department and phone number. Anyone can help please?
Question
How to export data such as department and phone number?
+22Can you see those two columns in data and analysis tab?
While, exporting make sure you checked "Download all fields" checkbox.
Yes I did check the "download all fields" checkbox. But I can't still see "Department" and "Phone no.". These are the only fields in the exported report:
+22https://www.qualtrics.com/community/discussion/comment/28897#Comment_28897Can you see those two columns in data and analysis tab?
I can't and when I clicked on all the drop downs, can't see department field even though I added in dept. information in the contact list. (phone information, I have yet to add to the contact list.
screenshot in data and analysis tab.docx
+22If department and phone number ae present in your contact list from which you have distributed the survey, then just create same embedded data in the survey flow of the survey and then try exporting the survey data.
+38amandaysy This page will help you with following rondev's advice to set your contact list fields as embedded data in your survey
https://www.qualtrics.com/support/survey-platform/survey-module/survey-flow/standard-elements/embedded-data/#SettingValuesFromAContactList
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.