Strange data form in excel file

OS (e.g. Win10): win1
PsychoPy version (e.g. 1.84.x): 2.3
Standard Standalone? (y/n) If not then what?:
What are you trying to achieve?:
Organized excel output

What specifically went wrong when you tried that?:

  1. In row 4, the question text is split into two different columns while the other question text stays in one column. I compared different outputs and there is always random question text that split into two or even more columns.
  2. My experiment does not need data on the mouse button history: mouse.leftButton mouse.midButton mouse.rightButton. Is there any way to not save this data?
    000003_miso body experiment_2024-06-18_10h37.23.485.csv (44.7 KB)
  1. I think that the problem in row 4 is due to the combination of commas and quotes in memory_text, which confuses Excel whrn you try to open it.
  2. If you don’t need the mouse data then you could set save mouse state to never.

image

  1. I also note that your conditions files have extra rows, which are causing the “None” issue (when memory_random.thisIndex == 4). Try deleting the extra blank rows and make sure the cursor is in a cell with data.

Thank you for your reply. I fixed the comma and quote. However, my condition file does not have any extra row. here is picture: