After we exported the report as a CSV file, Qualtrics changed single quote or double quotes into some strange symbols. Can you please fix that? Thank you very much!
The “Title†will be more effective than other vacuums in cleaning my carpet and hard surfaces.
It should be this way:
The “Title” will be more effective than other vacuums in cleaning my carpet and hard surfaces.
------------------------------
The “Title’s†no touch disposal system is a strong reason to buy the product.
It should be this way:
The “Title’s” no touch disposal system is a strong reason to buy the product.
Solved
Single Quote or Double Quotes in a CSV File
Best answer by TomG
It's because your quotes aren't the quotation mark character (U+0022), but extended left quotation mark (U+201C) and right quotation mark (U+201D) characters. You should replace the left/right quotation marks with a regular quotation mark.
+27It's because your quotes aren't the quotation mark character (U+0022), but extended left quotation mark (U+201C) and right quotation mark (U+201D) characters. You should replace the left/right quotation marks with a regular quotation mark.
We used the the quotation marks in Qualtrics when we set up the survey. So Qualtrics could not recognize its own quotation marks when it exported the report as a CSV file?
+27CSV doesn't support unicode characters. Export as TSV instead.
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.