Formatting Reporting Data | XM Community
Skip to main content

Hello,

When my survey data is exported into excel, it is populated vertically, instead of horizontal rows. Is there a way to change this/customize how data is put on the excel sheet? I am looking for each question to be a column with the answers below. In relation, am I able to choose the order of which data/survey question goes in what column?

Thank you on advance,

 

Frank

Hi @fcampo,

When you are exporting survey data there is no option for you to download it in different format or customize the format. But you can download it in different formats like CSV, Excel etc etc.

When you export it automatically downloads each questions in each column and answer below those respective columns.

Try exporting your Excel with options like shown in below screenshot:

 

For more information about this refer below link:

https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/download-data/understanding-your-dataset/?utm_medium=DataExport&utm_source=product&utm_campaign=UnderstandingYourData

 

 

Thank you!!! This was very helpful

Hi @fcampo,

You’re welcome. I am glad i could help you. 

Leave a Reply


Terms & Conditions