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.

WAS THIS PAGE HELPFUL?
New Stuff!