I have some excel spreadsheets that were coded by multiple coders. Each spreadsheet contains information such as the following:
ID, TEXT, Code1, Code2, Code3...
I am wondering if it is possible to import this into MAXQDA while maintaining all the information and the fact that different coders coded the data.
Right now, different coders are saved in different excel files, but I am wondering what the best format would be to import the information into MAXQDA. There are two formats that come to mind that might work, but I am looking for those who might have had experience with this to help.
ID, TEXT, CoderName, Code1, Code2, Code3 ...
(CoderName would represent the person who coded the data)
ID, TEXT, Code1-Coder1, Code2-Coder1, Code3-Coder1, Code1-Coder2, Code2-Coder2, ...
(Here we place each coder next to the other coder.
Which of these formats is most appropriate? And How can I import this information into MAXQDA without losing any of the information about who coded the data and what they coded it. Thank you for your assistance.