Formatting Reporting Data | Experience Community
Skip to main content
JoseS
Administrator
1 year ago
Solved

Formatting Reporting Data

  • Jul 12, 2023 1:12 PM UTC
  • 3 replies
  • 216 views
Level 2 ●●
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 7 ●●●●●●●
    Forum|alt.badge.img+54
    • Sachin Nandikol
    • QPN Level 7 ●●●●●●●
    • Answer
    • Jul 12, 2023 1:26 PM UTC

    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

     

     

    Sachin
      Level 2 ●●
      Forum|alt.badge.img+2
      • fcampo
      • Author
      • Level 2 ●●
      • Jul 20, 2023 12:42 PM UTC

      Thank you!!! This was very helpful

        Sachin Nandikol
        QPN Level 7 ●●●●●●●
        Forum|alt.badge.img+54
        • Sachin Nandikol
        • QPN Level 7 ●●●●●●●
        • Jul 21, 2023 4:21 AM UTC

        Hi @fcampo,

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

        Sachin
        Terms & ConditionsAccessibility statement