If you have trouble opening CSV files in Excel, it might be that your Regional Settings are incorrect.
If all your columns are suddenly showing in column A, then follow these instructions:

Go to Control Panel, and set it to Small Icons in the top right.
Then click on Region

In the window that opens, click on Additional Settings

In the window that opens, you will see a number of settings. The important ones are: Decimal Point and List Separator
If Decimal Point and List Separator is the same value, then Excel uses a different value for List Separator.
In PNPSCADA the List Separator is always a comma.
So set your List Separator to comma (,)
and set your Decimal Point to point (full stop, period) (.)

You'll need to restart Excel

Alternatively, you can download and run this file: excel_csv_fix.reg

Another way is to use Text to Columns in Excel: