Check the source value first

OrderID,PostalCode,Quantity
00124,01234,2
00125,05678,4

OrderID and PostalCode carry meaningful leading zeros. Quantity is a measurement. A spreadsheet import may treat all three as numbers, changing the first two displays. QuickDataView’s CSV preview displays fields as text.

Use the local viewer for inspection

  1. Open the CSV in QuickDataView.
  2. Find the identifier column and inspect a few cells.
  3. Search for a complete ID including its leading zeros.
  4. If needed, export matching rows as CSV and keep the original export.

Import carefully when you need calculations

In your spreadsheet editor, use its import controls and explicitly treat identifier columns as text. Opening the downloaded CSV directly in another application can reinterpret the values again. QuickDataView cannot set that application’s import rules.

Zeros already gone?

If the CSV itself contains 124 rather than 00124, a viewer cannot know the missing width. Check the original system or obtain a fresh export. Do not pad every identifier unless its intended format is known.

For XLSX or ODS, displayed cell formatting can differ from the underlying value; click a cell in the spreadsheet viewer to compare both. A preview here is free, local and useful for checking the file before an editing workflow. Read how to turn a checked export into a report when calculations are the next task.

Credit to the format’s makers

CSV owes its usefulness to decades of spreadsheet and data-export practice rather than a single creator. Yakov Shafranovich’s RFC 4180 documents a common comma-separated convention. That simplicity makes a small export easy to move between tools.

Format reference: RFC 4180’s CSV documentation. Reference checked 7 October 2026. These links acknowledge the format; they do not imply endorsement or a partnership.