If a CSV does not open correctly in Excel - showing all fields as one column - check the Regional and Language settings.

Set the List Seperator to a comma, and the Decimal Symbol to a fullstop

http://kb.paessler.com/en/topic/2293-i-have-trouble-opening-csv-files-with-microsoft-excel-is-there-a-quick-way-to-fix-this