CSV Viewer
Inspect quoted CSV cells in a readable table without uploading your data.
Open toolJSON to CSV Converter
Convert a JSON array of objects to CSV online for free. Combine keys into columns, review the result, then copy or download the CSV in your browser. No sign-up required.
Free to useNo sign-upRuns in your browser
Enter your details
Paste object records, then select Convert to CSV.
Your result
Enter your details
Result will appear here
How JSON to CSV conversion works
Turn JSON object records into a table while keeping control over the exported CSV cell text.
Each object becomes one CSV row. The converter collects keys across the records in their first encountered order, then quotes values where CSV requires it.
Missing and null values produce empty cells. Nested objects and arrays stay together as compact JSON text inside a cell.
Numeric tokens retain their digits without rounding during conversion. The limit is 100,000 input characters, 5,000 object records, and 100 columns. Check your spreadsheet import settings before relying on its display of identifiers or dates.
How to convert JSON to CSV online
Paste a JSON array of objects, review the CSV columns, and choose the export treatment for your spreadsheet workflow.
Paste a JSON array of objects
Paste a nonempty JSON array of objects into the JSON array field. In the pictured example, Ada has a city field and Lin has a team field. Each object represents one output row. A single object or an array of scalar values is not supported.
JSON input
Convert records and review CSV columns
Select Convert to CSV and review the headers. This example produces name, city, note, and team columns, collected in the order their keys are first encountered. Check several records: a missing field and a null value both produce an empty cell.
Combined columns
Choose CSV export options
Choose Prefix with an apostrophe or Keep exact cell text for formula-like cells. Select Convert to CSV again after changing that setting. Review the output, then use Copy result or Download converted.csv. Check long numbers and nested values in the receiving application, whose import settings may change how cells are interpreted.
Export result
Convert JSON records for spreadsheets and CSV workflows
Create CSV rows from JSON records with different keys or nested values, then check how your spreadsheet imports the cells.
Prepare JSON records for spreadsheet import
Convert an object array into CSV when a spreadsheet is the next review environment. Inspect the importer treatment of dates, identifiers, and formulas separately. The conversion creates cells but does not set the destination column types or spreadsheet display formats.
Review CSV columns when JSON keys differ
Use a sample where objects have different fields to inspect the union of headers. Empty output cells can represent a missing key or a null value, so retain the JSON source if that distinction affects your interpretation of the table.
Keep nested JSON in a CSV cell
Convert records containing an object or array in a field when a single CSV cell is acceptable for that nested content. The nested value becomes compact JSON text. Use another transformation if the destination requires separate columns for its inner keys.
How nested JSON and missing values appear in CSV
See how JSON objects and arrays, empty fields, and numeric text are represented in the CSV output.
Nested arrays and objects are serialized inside a cell rather than flattened into dotted column names. Null and missing values both become empty cells, which removes that distinction from the table.
Numeric tokens retain their textual digits in the output. A spreadsheet or other consumer can still parse them into a different numeric representation, so test long identifiers at the destination.
Check JSON input and spreadsheet CSV import settings
Check the JSON array structure and CSV export settings before opening the result in a spreadsheet.
Use valid JSON containing a nonempty array of objects. The converter accepts up to 100,000 input characters, 5,000 records, and 100 resulting columns. JavaScript object literals with unquoted keys or trailing commas are not valid JSON.
Formula escaping prefixes selected leading characters and changes the cell text. Review that setting alongside the importer behavior rather than treating it as a guarantee for every spreadsheet environment.
With prefix enabled
The prefix changes exported cell text. Review it with your spreadsheet importer.=SUM(1,2)→'=SUM(1,2)
More CSV, JSON and text tools
Convert an HTML table to CSV, turn TOML into JSON, generate a PHP array from JSON, or compare two texts.
HTML Table to CSV Converter
Extract an HTML table into CSV, expanding row and column spans.
Open tool
TOML to JSON Converter
Convert TOML tables, arrays, and values into formatted JSON.
Open tool
JSON to PHP Array Converter
Generate a PHP array expression from JSON without running code.
Open tool
Text Compare
Compare two pieces of text locally with additions and removals highlighted by word or line.
Open toolConvert your JSON array to CSV
Paste your JSON object records, review the columns, and copy or download the CSV.
JSON to CSV converter: common questions
Answers about JSON input, CSV output, and spreadsheet import settings.
What JSON input does this converter accept?
Paste a nonempty JSON array of objects. A single object, an empty array, or an array of scalar values is not supported. The input limit is 100,000 characters, with up to 5,000 records and 100 resulting columns.
Must every record have the same keys?
No. The CSV headers include keys found across all records, in the order they are first encountered. A missing key or a null value produces an empty cell.
Are nested objects and arrays flattened?
No. Nested objects and arrays become compact JSON text inside one CSV cell. They do not become separate columns for each inner key.
Will a spreadsheet preserve long numbers and identifiers?
The converter preserves numeric token digits in its CSV output. A spreadsheet may still interpret long numbers, leading zeros, or dates differently. Check the destination import settings and use text columns for identifiers where appropriate.
What does the formula escape option change?
The default option adds an apostrophe to cells beginning with =, +, -, @, tab, or carriage return. Keep exact cell text leaves them unchanged. Review the result with your spreadsheet importer; the prefix is not a guarantee against every importer.
Can I copy or download the converted CSV?
Yes. After selecting Convert to CSV, use Copy result or Download converted.csv in the result panel. Conversion runs in your browser and does not require an account.