Title: Import Format not working properly
Last modified: December 22, 2022

---

# Import Format not working properly

 *  Resolved [prajwal6898](https://wordpress.org/support/users/prajwal6898/)
 * (@prajwal6898)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/import-format-not-working-properly/)
 * inporting quiz is not properly working, as it is taking the right answer as an
   option.
 * QuizName,Question,Option1, Option 2, Option 3, Option 4,Correct answer (In Number)
 * also please allow an option to add : instead of , because some options also contains,
   so it is breaking the options

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Harmonic Design](https://wordpress.org/support/users/harmonic_design/)
 * (@harmonic_design)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/import-format-not-working-properly/#post-16313275)
 * Hi prajwal6898,
   Please confirm that your CSV file is properly formatted as a 
   CSV.
 * CSV stands for **Comma** Separated Value – so using any other character as a 
   delimiter means that it is no longer a CSV.
 * I’m guessing that “as it is taking the right answer as an option” is because 
   one of your answers contains a comma in it. If this is the case the solution 
   is to wrap your answer inside double quotes `"`.
 * BONUS: It looks like WordPress updated the comment editor for this forum to use
   a stripped down version of Gutenberg. Much nicer now!
 *  Thread Starter [prajwal6898](https://wordpress.org/support/users/prajwal6898/)
 * (@prajwal6898)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/import-format-not-working-properly/#post-16318468)
 * ![](https://i0.wp.com/i.paste.pics/2a8a3428586e71c4733b5ae4616aca45.png?resize
   =1036%2C162&ssl=1)
 * ![](https://i0.wp.com/i.paste.pics/4c90168f9ceac7eed7cedd69b8553dd3.png?ssl=1)
 * ![](https://i0.wp.com/i.paste.pics/e205b8db5ef0c15cfc3f7b96904daa94.png?ssl=1)
 * please check
 *  Plugin Author [Harmonic Design](https://wordpress.org/support/users/harmonic_design/)
 * (@harmonic_design)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/import-format-not-working-properly/#post-16318472)
 * Thanks for the screenshot – very helpful.
 * Your problem is that you are missing columns. The “correct” answer column is 
   the 13th column (column M). You have yours as the 9th (column I).
 * Change
 * `GK Quiz, What is the capital of India?, New Delhi, Mumbai, Kolkata, Bangalore,,,
   1`
 * to
 * `GK Quiz, What is the capital of India?, New Delhi, Mumbai, Kolkata, Bangalore,,,,,,,
   1`
 * The order of columns are
    1.  Quiz Name
    2.  Question Title
    3.  Answer 1
    4.  Answer 2
    5.  Answer 3
    6.  Answer 4
    7.  Answer 5
    8.  Answer 6
    9.  Answer 7
    10. Answer 8
    11. Answer 9
    12. Answer 10
    13. Correct Answer
 *  Thread Starter [prajwal6898](https://wordpress.org/support/users/prajwal6898/)
 * (@prajwal6898)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/import-format-not-working-properly/#post-16318693)
 * Thanks, it’s working ❣

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Import Format not working properly’ 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

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

 * 4 replies
 * 2 participants
 * Last reply from: [prajwal6898](https://wordpress.org/support/users/prajwal6898/)
 * Last activity: [3 years, 4 months ago](https://wordpress.org/support/topic/import-format-not-working-properly/#post-16318693)
 * Status: resolved