It’s really annoying when you open a csv file and you see all the data appear in the first column, but luckily the solution for this is really easy.
First select the first column, then select the tab “Data” and press the button “Text to Columns” in the Ribbon.
In the Columns Wizard press next at the first step keeping the default data type “Delimeted“. In Step 2 select the correct Delimiters and press “Finish”.
Now the CSV will be displayed with the data in the correct columns.