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