Reading CSV in EXCEL

Our configuration files and meter lists are in CSV format.

If you want to edit these in Excel, they will look strange when you open them as all the information is in the same column.

For an easier overview, follow these steps.

Tick column A.
Go to Data in the menu
Then select Text to column

When the wizard asks for the Original data type, select Delimited fields and then Next
Now select Comma to be a delimiter, press Next and then Finalise.

Now the information has been split into different columns.