Quiz generator: How do I include a comma in exported CSV question?


Good morning everyone! I need your help, please. I have reached a dead end in my research and don’t know how to answer my math instructor with the following question. She asked:

I have been using the (Brightspace) Question generator. I notice that if the question has a comma (,) when it downloads to excel csv, the question is not completed. As you know I have a lot of commas in my exam. Any advice on this?

Does anyone know the answer? Please let me know.

Thank you, Michael

Best Answer

  • Janet.W.813
    Janet.W.813 Posts: 56
    Answer ✓

    Hi Michael,

    I have not tested this, but have you tried double quotes around the commas? I found this in Stack Overflow's documentation:

    Fields containing line breaks (CRLF), double quotes, and commas should be enclosed in double-quotes.

    So, to have values foo and bar,baz, you do this:


    Hope that works!