If you double click a CSV file from Windows Explorer to open it in Excel (assuming you have .csv extensions to open in Excel) then the results are generally shit.
If you start Excel and then open the CSV file from there it works a hell of a lot better, including automatically prompting you with the text import wizard.
I learned this the hard way after I had users screaming at me that Excel was mangling the CSV output of their reports.