Exporting Data Without Dropping Leading Zeros

1. Click on Save to my computer as
2. Select either CSV or CSV (with options)
3. Click Save -- DO NOT OPEN THE CSV FILE DIRECTLY WITH EXCEL!
4. Open a new worksheet in Excel 
5. Open the Data tab
6. Click on the From text button in the Get External Data section
7. Select your CSV file to import
8. Select the "Delimited" radio button -- Text Import Wizard, Step 1 determines that your data is delimited
9. Click Next
10. Check "Comma" as a delimiter (column dividers will appear in preview)-- Step 2 lets you set delimiters
11. Click Next
12. Highlight the column(s) with leading zeros in Step 3
13. Mark those columns format as "text" by clicking the radio button in the Column Data Format section.  NOTE: You will need to do this for each column where the data contains leading zeros.
14. Click Finish
15. The leading zeros will still be there in the new worksheet with the imported data. The columns with real numbers will still be able to be used with calculations.

Click on Save to my computer as

1. Select either CSV or CSV (with options)
2. Click Save -- DO NOT OPEN THE CSV FILE DIRECTLY WITH EXCEL!
3. Open a new worksheet in Excel 
4. Open the Data tab
5. Click on the From text button in the Get External Data section
6. Select your CSV file to import
7. Select the "Delimited" radio button -- Text Import Wizard, Step 1 determines that your data is delimited
8. Click Next
9. Check "Comma" as a delimiter (column dividers will appear in preview)-- Step 2 lets you set delimiters
10. Click Next
11. Highlight the column(s) with leading zeros in Step 3
12. Mark those columns format as "text" by clicking the radio button in the Column Data Format section.  NOTE: You will need to do this for each column where the data contains leading zeros.
13. Click Finish
14. The leading zeros will still be there in the new worksheet with the imported data. The columns with real numbers will still be able to be used with calculations.