CX survey data & Analysis - Export feature for selective columns/fields | Experience Community
Skip to main content

CX survey data & Analysis - Export feature for selective columns/fields

  • October 11, 2022
  • 2 replies
  • 113 views
Y
Level 1 ●
Forum|alt.badge.img+2

Hi,
I tried to export a few columns of the survey questionnaire data with recoded value.
However, it only allows export of all columns/fields when exporting with recoded value which can span over 3 hundred columns in Excel . Very laboriously removing those columns/fields that I don't need. Imagine if I need to do it regularly and the mistakes that I made!
But when exporting as Text Choice value then you can selectively export a few columns/fields that you choose.
Any one has better idea?
Looks like a new enhancement suggestion/New product feature to Qualtrics Inc for this product?
Thanks.

    2 replies

    bgooldfed
    Level 4 ●●●●
    Forum|alt.badge.img+25
    • bgooldfed
    • Level 4 ●●●●
    • October 12, 2022

    Hi YokeSee,
    My employer stumbled on the same problem, and it is part of a process we regularly have to do.
    Our solution is to export the entire file and then use a script to gather the columns we want for processing/analysing. We use R, but you could also use Python or some other language with a good data analysis library. It's a very simple task to learn and there are heaps of resources out there to help.
    I recommend having deliberate column names with a consistent format, it will make it much easier.
    Good luck!

    Y
    Level 1 ●
    Forum|alt.badge.img+2
    • YokeSee
    • Author
    • Level 1 ●
    • October 30, 2022

    Thanks bgooldfed,
    I managed to find another way round it. In Data & Analysis, First use column chooser to chose those columns of interest. It will be in "text choice". Then go to each individual column and then highlight the column, a drop down selection appears (sort, hide column, move column, etc) and "View as Numeric Values" is one of the selection. Repeat for each column and then save the template. Export template data and it will be in Numeric values. Tedious but is a work around.

    Terms & ConditionsAccessibility statement