How to export data such as department and phone number? | XM Community
Skip to main content

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?

Can 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:
headers for report.png


https://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


If 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.


amandaysy 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


Leave a Reply