A worked example
Keep a product code’s leading zero
- Start with
- CSV with code,name and 00123,Bolt; Preserve cells as text enabled
- Check the result
- Save an .xlsx containing 00123 as a text cell.
Use text preservation for meaningful leading zeros. Date formatting is not assigned automatically; adjust it in Excel if needed.