Single Quote or Double Quotes in a CSV File

Question

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.

TomG · Accepted Answer

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.

Huiling · Answer

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?

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded