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.