After converting the participants’ data from CSV to Excel, some patients end up with missing trials (generally around the 30th) that SEEM to still be in the sheet, but as random gibberish that I can’t identify. What could be the cause? I suspect human error (this happened to around 16% of my sample) but don’t know.
OS: Win10
PsychoPy version: 2024.2.4 Py 3.8.
I’m not running online (Pavlovia).
Do you have an editable text box in your experiment? Often files can misopen in Excel if they contain new line characters or other punctuation like quotes.
Thank you! Yes, I have them. But in my case, the missing data are not the answers from the editable text boxes 
No – it will probably be the data saved to the right of the editable textbox contents. The data is likely to still be there, but on the next line.
Is it possible I’m having a similar problem? I have a non-editable textbox in a routine with examples (word1, word2, etc.). And then the “real” (editable) textbox for data collection in the next routine.
The problem I’m running into is that in my data, the editable textbox column is showing me my example words from the prior (non-editable) textbox routine. And I cannot find the real data of the editable textbox.
I’m still troubleshooting this, but any ideas? I’m seeing this both by opening the .csv in Excel and through R.