Import Format not working properly

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!

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