How to open a CSV file in Excel

1. Open a new Excel document and navigate to the Data tab.
2. Click “From Text”.
3. Navigate to the CSV file you wish to open and click “Import”.
4. From the newly-opened window, choose “Delimited”. Then click “Next”.
5. Check the box next to the type of delimiter – in most cases this is either a semicolon or a comma. ... 
6. Click “Finish”.

Here's another way.