CSV and JSON for everyday data work
CSV (comma-separated values) is a plain-text format for rows and columns. It is easy to export from spreadsheets and databases, but its cells are text and must follow quoting rules when they contain delimiters, line breaks, or quotation marks. JSON (JavaScript Object Notation) represents structured values such as arrays and objects. A JSON array of records can retain clear property names and can be consumed directly by many applications and APIs.
This converter runs entirely in your browser and supports CSV-to-JSON and JSON-to-CSV workflows. For CSV input, the parser recognizes quoted cells, doubled quotes, and embedded line breaks, so a value like "New York, NY" remains one field. You can select comma, semicolon, or tab as the delimiter. With the header option enabled, the first CSV row supplies property names; when disabled, rows become arrays. JSON-to-CSV accepts an array of objects, collects their keys as columns, and can write or omit a header row.
How to convert and export data
Select the conversion direction, choose the delimiter used by the CSV, and set whether the first row contains headers. Paste your input, then select Convert. The converter shows the output along with row and column counts. Use Copy output to copy the converted text or Download file to save it locally as a CSV or JSON document. The conversion direction determines the downloaded file extension.
Empty input, malformed quoting, invalid JSON, unsupported JSON shapes, and inputs over 200,000 characters are reported clearly. CSV values are strings; converting them to JSON does not guess whether text such as 0012 should become a number, since that could discard meaningful leading zeros. When headers repeat or are empty, the converter makes unique property names so one column does not silently overwrite another. Missing JSON object properties produce empty CSV cells.
Common uses and data considerations
Developers can use CSV-to-JSON to prepare small fixtures, inspect a spreadsheet export, or create sample records for a local project. JSON-to-CSV is useful for reviewing a list of similarly shaped objects in a spreadsheet or sharing a simple tabular extract. Semicolon-separated files are common in some regional spreadsheet settings, while tab-delimited text is convenient for copying rows between applications. The selected delimiter is respected inside and outside quoted fields according to CSV quoting rules.
Before importing converted data into a production system, review headers, row counts, character encodings, and any application-specific expectations. CSV does not preserve nested object types, and this tool serializes nested JSON values as JSON text inside a CSV cell. Large datasets are better handled by a dedicated streaming or command-line process. No input or output is uploaded or saved by this page. For related tasks, try the JSON Formatter, JSON to TypeScript Generator, or Text Formatter.
Frequently asked questions
Does the converter handle quoted commas and newlines?
Yes. The CSV parser supports quoted fields, doubled quote escapes, commas or other selected delimiters inside quoted values, and line breaks inside quoted fields.
What does the first row as header option do?
For CSV to JSON, the first row becomes object property names. When disabled, each record is represented as an array of values. For JSON to CSV, the option controls whether property names are written as the first CSV row.
Which JSON input shapes are accepted?
JSON to CSV expects a top-level array of objects. The CSV columns are the union of object keys, and missing values are written as empty cells.
Is my data uploaded or saved?
No. Parsing and conversion run locally in your browser. The tool does not call an API or store your input.