I've done a pilot study recently and got some data to work on.
The first problem I've encountered is the data in CSV comes already compiled on mean, median, etc.
The individual participant data comes only as a TXT file. I know is possible to convert in Excel tables, but it's being very difficult, because on the TXT file the spaces between information is not always the same. So when I import data on the Excel the collums don't stay neat (eg, reaction times come spread on collum 5, 6 and 7, depending on how many spaces the TXT file had on that line).
Since is only 5 participants data right now, I'm correcting manually, but when I have 100 participants data, this will be impossible.
Any thoughts about what can I do to fix this issue?
Isn't possible to download the individual data also in CSV? (because with the CSV file, it seams Excel understands better and make all the collums correctly)