Under certain circumstances, leading zeros included in IDs, serial numbers etc. may be lost. In order to avoid this, open the CSV file from within Excel and follow the steps below to open and edit the CSV file.
1. Start Excel.
2. Click “Data” --> “Get external data”.
3. The text conversion wizard appears:
4. Delimiter: semicolon
5. Data format for the columns: At least the “CustomerID” and “ID” columns must be formatted as text:
6. Finish.
Results:
Results After Opening the CSV File via the Explorer: