JSON vs CSV

JSON represents nested values and typed data, while CSV represents rows and columns in a broadly portable text format. Converting between them requires explicit choices for nesting, delimiters, and value types.

Convert JSON arrays to CSV

The supported JSON shape is an array of objects. Nested objects can become dotted columns such as user.address.city, or nested values can remain JSON strings. Arrays are preserved as JSON text.

CSV delimiters and quoting

Comma, semicolon, tab, and pipe delimiters are supported. Automatic detection is available while importing. Quoted fields correctly preserve delimiters and line breaks inside values.

Spreadsheet formula injection

Spreadsheet software may interpret cells beginning with =, +, -, or @ as formulas. Protection is on by default for CSV export and visibly documented next to the control.

Frequently asked questions

Are CSV values automatically converted to numbers?

No. Import preserves strings by default; optional type inference can convert clear numbers, booleans, and null values.

How much data appears in the preview?

The preview shows at most the first twenty rows while the complete local result remains available to copy or download.