I worked it out. So, first, I have a rating scale that I customised so that I could stretch it across the screen. The text in the Custom box is:
low=1, high=5, precision=1, textSize=0.35, stretch=2.7,
choices=[“Absolutt Ikke”, “Litt”, “Middels”, “Ganske”, “Svaert”]
I’ll get back to a contradiction in there; PsychoPy doesn’t behave quite as described in the book.
My procedure for getting data into Excel is to convert into text, because when I tell Excel to open a CSV file, it just puts everything into a single cell, without giving me the option to tell it to separate. From text, I first tell Excel that the file will be delimited, then that it will be comma separated. With one exception, that puts everything into its proper place.
The exception is the information from that Custom box, specifically the choices. The first quotation mark around “Absolut ikke” is lost, and then the remaining four choices are saved in the next four columns, which are supposed to be reserved for other data. And that is what shifts everything that is further to the right by those four columns.
If I knew how to tell PsychoPy how not to save data, I could just tll it to omit this stuff in the CSV file, and then nothing would get shifted. I don’t know whether such a command exists. I have failed to find one.
As for the contradiction in the Custom Box, I want a numerical rating, hence the low and high values. Specifying categorical choices interferes with that. However, when I say these are labels, then, contrary to what is in the book, I don’t get my five labels evenly distributed under the scale. I only achieve that by asking for choices. Then I have a bit of code which converts them into numerical ratings.