For Excel 2013:

1) Open Blank Workbook.
2) Go to DATA tab.
3) Click button From Text in the General External Data section.
4) Select your CSV file.
5) Follow the Text Import Wizard. (in step 2, select the delimiter of your text)