DATA STUDIO / 05

JSON to CSV converter

JSON to CSV converter: questions & answers

Practical answers for this specific tool, including what it can do and where its limits matter.

← Open JSON to CSV converter

How are columns chosen when keys differ?

The output uses the union of keys in first-seen order. A missing key or null value becomes an empty cell, which loses that distinction in CSV.

Why are negative values prefixed with an apostrophe?

The spreadsheet-safe default protects text starting with formula-sensitive characters, including minus. This deliberately changes values; inspect the result before importing it.

Can I export nested objects by expanding columns?

No. Flatten the records before using this tool. Arrays and nested objects inside a row are rejected rather than converted to vague text.

Why was a large integer rejected?

JavaScript cannot represent every large integer exactly. Quote long identifiers as JSON strings. Duplicate JSON property names are also rejected.