Opening CSV Exports in Excel
Setting Excel as the Default Program
While CSV files are usually automatically opened in Excel by default, that is sometimes not the case on Windows 7. Here are instructions and screenshots on how to set Excel as your default program for CSVs on Windows 7.
Converting CSV to XLSX or XLS
To convert a CSV to XLSX or XLS, or get rid of the comma in between data values, refer to this guide for importing CSVs into Excel.
Leading Zeroes Stripped From User IDs
You may sometimes find that leading zeroes are stripped from User IDs in your CSV export. This happens because Excel treats the numbers in a CSV as data, as opposed to text. Here are steps on how to remedy this by running Excel’s Text Import Wizard.