A customer order export often mixes identifiers with quantities. The postal code 00123 needs all five characters, while the quantity 2 needs to work in a sum. This example puts both in the same workbook.
Download the sample orders CSV · Open CSV to Excel
Preview the column types
Open the original CSV directly in the converter. Leave the first-row header enabled. You should see three columns and two orders. If everything appears in one column, choose comma as the delimiter.
Set postal_code and order_id to Text. Set quantity to Number. The order IDs end in 678 and 679. Keeping the entire ID as text lets you distinguish these records even though they agree for the first 17 digits.
Check the workbook
Select Create Excel file, download the XLSX and open it. A2 should display 00123 and A3 should display 00456. Select B2 and B3 and compare their last digits in the formula bar. In a spare cell, enter =SUM(C2:C3). The result should be 7.
Download the expected Excel workbook
If a previous spreadsheet export already replaced 00123 with 123 or rounded the order IDs, return to the original source export. Setting a damaged identifier to Text preserves the characters still in the file.