Merge xlsx data files
I have several times 150 csv files for different experiments that were created with open sesame. Due to some errors during datacollection the "subject number" of several files are not correct.
To overcome this issue, I have made xlsx files based on the csv files, I have added a column "Subject" with the correct subject number for each file, and finally added all these corrected xlsx files to **one new folder. **
I want to merge all these files to one big "masterfile". I have tried different options, for example the data merger program. The program indicates it the merge was successful, but once I open the created csv file, it only contains the title cells, without any other data.
Can somebody help? Thanks in advance!