JSON to CSV and CSV to JSON converter
Turn JSON records into a table for a spreadsheet, or convert a CSV export into JSON objects. Choose the delimiter and header setting, then check how identifiers, empty cells and nested values come through.
Runs in your browser — your input is not uploaded to ToolsNow.
How to use
- Choose the direction. JSON → CSV accepts an array of objects or a single object. CSV → JSON reads rows using the delimiter you select.
- Set Delimiter and the header option. Choose comma, semicolon, tab or pipe. First row is a header reads column names in CSV → JSON and includes a header when exporting CSV.
- Decide how to handle types. For CSV → JSON, turn off Detect numbers & booleans to keep every cell as text, especially IDs and phone numbers.
- Review the converted rows. Check the row and column count, then inspect a record with quotes, blank cells or unusual values before copying or downloading.
If an app rejects your CSV or reads it as one column, use the CSV import doctor to check the separators, column names and rows before converting it.
Questions
Which cells become numbers, booleans or null?
With detection on, 42 becomes a number, lowercase true and false become booleans, and empty cells or the word null become null. "007" and "1.00" stay strings, but a digits-only phone number can become a number. Turn detection off when the characters themselves are important.
What happens to nested objects and missing values?
JSON objects and arrays inside a record become JSON text within a CSV cell; converting back leaves that cell as a string. Columns include all keys seen across the records. Missing keys and null values both export as empty cells, so a round trip cannot preserve every distinction.
Can fields contain commas, quotes or newlines?
Yes. Quoted fields can contain delimiters and line breaks, and a quote within one is written as two quotes: "He said ""hello""". The parser is permissive rather than a strict CSV validator, so malformed quoting may not produce an error.
Why did a column disappear when importing CSV?
The first row defines the columns. Extra cells beyond its width are dropped, and repeated header names overwrite earlier values in the same record. Give each column a unique name and check rows with a different number of cells. With the header option off, names are column1, column2 and so on.
Will a spreadsheet preserve the exported values exactly?
Not necessarily. Spreadsheet software may reinterpret dates, leading zeroes and long numbers. It may also treat a cell beginning with = as a formula; this converter does not neutralise formulas. Import untrusted or identifier-heavy columns as text and check the import settings.
Published by ToolsNow. How tools and sources are checked · Report a problem