Can CSV export be adjusted to use a comma for decimals? (as is commonly used in Europe) | XM Community
Skip to main content

Can CSV export be adjusted to use a comma for decimals? (as is commonly used in Europe)

  • January 31, 2020
  • 2 replies
  • 86 views

jbyrne
Forum|alt.badge.img+1
When I export a widget into CSV the decimal place is a "." and since my laptop was setup in the UK my Excel can read this perfectly well and calculations can be performed without making any changes. However, our program has a lot of users in Europe where the "," is more common and so when they see "0.8321" (for example) their Excel doesn't recognise this as a number - it is expecting "0,8321". It's probably not realistic to suggest they change their global Excel settings since I imagine in any other context all numbers will come in the expected format. Is there anything within Qualtrics that can change the format of the number? I imagine customers have faced this issue before?

2 replies

TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • Level 8 ●●●●●●●●
  • January 31, 2020
Under Export Data/CSV/More Options, check the "Use commas for decimals" box.

jbyrne
Forum|alt.badge.img+1
  • Author
  • February 3, 2020
Thanks @TomG. I see this when I am in my survey project on the Data & Analysis tab, but when I am in Vocalize and want to export a widget I don't have this option. Is it available in Vocalize?