JSON to CSV Converter

Convert between JSON and CSV in both directions — for spreadsheets and for code.

Bridging data and spreadsheets

JSON is how code passes data around; CSV is what spreadsheets open. Constantly you need to cross between them — turning an API's JSON into a CSV someone can open in a spreadsheet, or a exported CSV into JSON your code can consume. This converts either way, mapping a JSON array of objects to rows and columns and back.

Paste JSON to get CSV, or CSV to get JSON.

Where the two formats disagree

The conversion is cleanest when the data is flat — a list of records with the same simple fields. The friction comes from JSON's ability to nest: an object or array inside a field has no natural CSV cell, so nested data has to be flattened or serialised, and that is where a round trip can lose shape. CSV also has its own quoting rules for commas and quotes inside values, which proper conversion handles. For tabular data, the two map neatly; for deeply nested JSON, expect to flatten it first.

Common questions

What JSON converts cleanly to CSV?

A flat array of objects with the same fields maps neatly to rows and columns. Nested data has to be flattened first.

Does it handle commas inside values?

Yes — CSV quoting for commas and quotes inside fields is handled in both directions.

Is my data uploaded?

No. The conversion happens in your browser.

More Convert tools