In order to properly view the data in the CSV file, you will first have to make sure that the values are divided into separate columns. You can do this as follows:
1. Select the first column (column A)
2. Click on 'Data' and then on 'Text to Columns'
3. The option 'Delimited' has been preselected. This is the correct option. Click on 'Next'.
4. Select the option 'Comma' and click on 'Finish'.