How to Export Halo Products
Updated
Print

Introduction

This is an Excel issue. The program automatically truncates all leading zeros from numbers in CSV files. The key is to change the columns where the leading zeros occur, into text. There are two options for accomplishing this.

 

Option 1

  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 IN EXCEL!

  4. Open a new worksheet in Excel.

  5. Click on the Data tab in the Navigation Bar.

 mceclip0.png

  1. Click the From Text icon in the Get External Data section.

  2. Select your CSV file to import.

  3. Select the Delimited radio button. Text Import Wizard, Step 1 determines that your data is delimited.

 mceclip1.png

  1. Click Next.

  2. Check Comma as a delimiter (column dividers will appear in preview). Step two lets you set delimiters.

 mceclip2.png

  1. Click Next.

  2. Highlight the column(s) with leading zeros in Step three.

  3. Mark those columns formatted as Text by clicking the radio button in the Column Data Format section. YOU WILL NEED TO DO THIS FOR EACH COLUMN WHERE THE DATA CONTAINS LEADING ZEROS.

 mceclip3.png

  1. Click Finish.

  2. The leading zeros will still be there in the new worksheet with the imported data. The columns with real numbers can still be used with calculations.

 mceclip4.png

 

Option 2

  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. Change the file extension from .csv to .txt.

  5. Open a new worksheet in Excel.

  6. Click the Data tab in the Navigation Bar.

  7. Click the From Text icon in the Get External Data section.

  8. Select your CSV file to import.

  9. Select the Delimited radio button. Text Import Wizard, Step 1 determines that your data is delimited.

  10. Click Next.

  11. Check Comma as a delimiter (column dividers will appear in preview). Step two lets you set delimiters.

  12. Click Next.

  13. Highlight the column(s) with leading zeros in Step three.

  14. Mark those columns formatted as Text by clicking the radio button in the Column Data Format section. YOU WILL NEED TO DO THIS FOR EACH COLUMN WHERE THE DATA CONTAINS LEADING ZEROS.

  15. Click Finish.

  16. The leading zeros will still be there in the new worksheet with the imported data. The columns with real numbers can still be used with calculations.

 

Attachments
How to Export Halo Products .pdf
- 300 KB