Formatting Reporting Data | XM Community
Skip to main content
Solved

Formatting Reporting Data


Forum|alt.badge.img+2

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

Best answer by Sachin Nandikol

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

 

 

View original

3 replies

Sachin Nandikol
QPN Level 6 ●●●●●●
Forum|alt.badge.img+34
  • QPN Level 6 ●●●●●●
  • 467 replies
  • Answer
  • July 12, 2023

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

 

 


Forum|alt.badge.img+2
  • Author
  • Level 2 ●●
  • 8 replies
  • July 20, 2023

Thank you!!! This was very helpful


Sachin Nandikol
QPN Level 6 ●●●●●●
Forum|alt.badge.img+34
  • QPN Level 6 ●●●●●●
  • 467 replies
  • July 21, 2023

Hi @fcampo,

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


Leave a Reply