Open a CSV File on Excel

Open your CSV file in text editor and add sep=, on the first line.

Or

1. Go to Data
2. Select the first column (Column A)
3. Select Text to Columns
4. Choose Delimited
5. Select your delimiters
6. Finish