SYMPTOM:
When exporting a report grid from Strategy Web or Developer CSV format, the exported file does not open correctly in Excel. All the data is in one column, and commas appear, but they are not used to delimit the data properly, as shown in the image below:
CAUSE:
Excel does not understand that data is saved in CSV (comma separated values) format because the file extension used is .txt.
ACTION:
Option 1:
When saving the text file change the extension to.csv from .txt and select the 'All files' option from file type drop down list as shown in the image below:
Option 2:
If the file is saved in .txt format:
