I administered a questionnaire using limesurvey and downloaded the responses in csv format to analyse in R. For some reason, the column names are displaying very weirdly in excel. I have tried Data --> Text to columns, separate by comma but as in the picture it only changes the first few into column names and the rest are displaying strangely down column 1. The actual responses only start way down in row 120.
Does anyone have any idea how I can fix this? As when I tried reading the sheets into R it still displays strangely and I'm concerned about the analysis.
Here's the notepad display: Notepad display