CA Client Automation - Reporter csv export not opening in excel with proper formatting

Document ID : KB000123032
Last Modified Date : 14/12/2018
Show Technical Document Details
Issue:
In DSM Reporter the CSV does not export as it should with the comma delimiter. When I open the exported file, each line fills just a single cell rather than being broken up into multiple columns based on location of commas on the line
Environment:
any supported Client Automation (or DSM/ITCM) installation running DSM Reporter
Cause:
This happens when the CSV export is set to use the comma character for 'Field Delineation' which does not result in a format natively understood by MS Excel
Resolution:
Change the Field Delineation setting from a comma "," to tab "<tab>" which will allow MS Excel to open and automatically process the file as expected.