IronSphere Server: Export to EXCEL is not properly displayed on EXCEL spreadsheet.
Symptoms:
A CSV file exported from IronSphere is not properly displayed in excel.
Description:
When opening an IronSphere export file (CSV format), excel is using the default delimiter defined in your (Windows) "Regional and Language Options". This delimiter character might no fit the delimiter set by IronSphere, which is the semicolon (';') character.
Solution:
Use import instead of open if your delimiter is not a semicolon. Import allows you to specify the CSV file delimiter.