Title: CSV Export Formatting Issue
Last modified: June 10, 2020

---

# CSV Export Formatting Issue

 *  Resolved [jbelzman](https://wordpress.org/support/users/jbelzman/)
 * (@jbelzman)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/csv-export-formatting-issue/)
 * Downloaded CSVs of results aren’t formatting correctly. Some headers are missing,
   fields contain strange entries such as pieces of the quiz name, no results, etc.
   Is this because we haven’t installed the Results Light plugin?
 * In HD Quiz Results I see this:
 * > [View post on imgur.com](https://imgur.com/IcotZLJ)
 * But the exported CSV looks like this:
 * > [View post on imgur.com](https://imgur.com/cSzQMha)
    -  This topic was modified 5 years, 11 months ago by [jbelzman](https://wordpress.org/support/users/jbelzman/).

Viewing 1 replies (of 1 total)

 *  Plugin Author [Harmonic Design](https://wordpress.org/support/users/harmonic_design/)
 * (@harmonic_design)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/csv-export-formatting-issue/#post-12966335)
 * Hi jbelzman,
    this is an easy mistake to make.
 * CSV stands for **Comma Separated Values**. This means that each field (in our
   case `quiz name, date, score, user`) needs is separated with a comma `,`.
 * The problem you have here is that your quiz name is `Gander Quiz: Test, Test,
   Test` which includes two commas, which causes your CSV to contain two erroneous
   extra columns.
 * Based on your quiz name, I assume that this was just a test, so probably won’t
   be an issue for you moving forward. However, something you can do is open the
   CSV file using a text editor, then do a search/find for the text `Test, Test,
   Test` and replace it with something else such as `Test Test Test`.
 * Hope this makes sense!
 * (Also, I’ll try and detect this issue in a future update for HD Quiz Save Results
   Light and try and clean out commas in quiz names before exporting as CSV)

Viewing 1 replies (of 1 total)

The topic ‘CSV Export Formatting Issue’ is closed to new replies.

 * ![](https://ps.w.org/hd-quiz/assets/icon-256X256.gif?rev=2936040)
 * [HD Quiz](https://wordpress.org/plugins/hd-quiz/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/hd-quiz/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/hd-quiz/)
 * [Active Topics](https://wordpress.org/support/plugin/hd-quiz/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/hd-quiz/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/hd-quiz/reviews/)

## Tags

 * [export](https://wordpress.org/support/topic-tag/export/)

 * 1 reply
 * 2 participants
 * Last reply from: [Harmonic Design](https://wordpress.org/support/users/harmonic_design/)
 * Last activity: [5 years, 11 months ago](https://wordpress.org/support/topic/csv-export-formatting-issue/#post-12966335)
 * Status: resolved