Problem import xlsx conditions file

That might help, but the other problem (which may be caused by the right-to-left aspect), is that the xlsx file does seem to be encoded with some extra columns of nothing. To me it looks like some application has added some empty columns to you file for no good reason. If I save the file as a csv file instead and then open it in a text editor it looks like this:

question,correct_response,,,,,,,,,,,
questions\02\Slide4.JPG,3,,,,,,,,,,,
questions\02\Slide5.JPG,1,,,,,,,,,,,
questions\02\Slide6.JPG,2,,,,,,,,,,,
questions\02\Slide7.JPG,3,,,,,,,,,,,

I was able to fix the import by copying the genuine data to a new file and saving it again. 02b.xlsx (25.5 KB)

I’m afraid that PsychoPy isn’t smart yet about working out whether blanks in a file could be safely ignored (as in this case) or whether they are a problem.

Out of interest, what was the file created in Noa?

1 Like