Question 1

How does CSV to JSON conversion work?

Accepted Answer

The first row of the CSV is treated as headers (column names). Each subsequent row becomes a JSON object with keys matching the headers. Values are automatically converted to numbers, booleans, or null where appropriate.

Question 2

Does it handle quoted fields with commas and newlines?

Accepted Answer

Yes. The CSV parser fully supports RFC 4180 standard: fields enclosed in double quotes can contain commas, newlines, and escaped quotes (represented as "").

Question 3

How does JSON to CSV handle nested objects?

Accepted Answer

Nested objects are flattened using dot notation (e.g., {"address":{"city":"NY"}} becomes address.city). Arrays are joined with semicolons. You can also choose to keep arrays as JSON strings.

Share this tool