GUIDE · 4 min read

Why data can change when you convert CSV and JSON

Protect leading zeros, quoted commas, nested values, and spreadsheet imports.

Tierify editorial · November 18, 2026

Is 001 a number or an identifier?

CSV does not declare value types in the way JSON does. A parser cannot know whether 001 is a quantity or a product code. Tierify CSV to JSON keeps every cell as a string so that leading zeros are retained.

If you need arithmetic afterward, convert only the relevant columns in the receiving application. Opening a CSV in a spreadsheet may trigger type inference again. Import identifier columns explicitly as text when their exact representation matters.

Commas and line breaks inside a cell

Splitting text on every comma breaks cells that contain quoted commas. Tierify uses a CSV parser that understands quoted values and multiline cells. A literal quote inside a quoted CSV field must itself be escaped according to CSV rules.

The first row needs distinct, nonempty column names. When rows have different column counts, values can shift into the wrong fields. The converter stops and reports the mismatch instead of silently producing an ambiguous table.

Nested structures and large integers

CSV is a rectangular table, while JSON can store arrays and objects inside other values. Tierify JSON to CSV accepts a flat object array. Flatten nested structures yourself before exporting so that you can choose meaningful columns and avoid losing relationships.

JavaScript cannot represent every large integer exactly. Keep long order numbers and identifiers as JSON strings. Repeated JSON keys retain only their last value, so check the data at its source before relying on a converted result.

Values that a spreadsheet treats as formulas

A CSV cell beginning with characters such as =, +, -, or @ can be interpreted as a spreadsheet formula. Tierify JSON to CSV adds an apostrophe to values that match its formula-escaping rules.

This protection can add a character to the exported representation. Check the receiving system before using the output as a machine-to-machine data exchange. Review untrusted spreadsheet contents regardless of which converter generated the file.