Open the csv file:
Highlight column A
1. Select Data tab
2. Text to Columns
3. Delimited, 'NEXT'
4. Check 'Comma,' and NEXT
5. select Finish
You will need to insert a row with the headers.