Search our Help.

How to Fix Truncated CSV Files

Follow

Summary: 

When downloading a CSV file from Unleashed into Microsoft Excel, some columns consisting of leading zeros or truncated numbers will need to be formatted correctly to display the correct data. This essential when importing files back into Unleashed. 

Steps:

  1. Open the file in Excel
  2. Highlight necessary column
  3.  Right-click Format Cells
  4. Under Category, select Number 
  5. Change Decimal Places to 0
  6. Click Ok

Additional Information

Here is a demonstration of fixing truncated customer code:

 

Was this article helpful?
0 out of 0 found this helpful