JSON to CSV
Convert a JSON array of objects, or a single object, into CSV. Missing keys become empty cells; values are escaped safely.
Runs on your device Processed locally in your browser. Nothing is uploaded.
Convert CSV or TSV to a JSON array. Handles quoted commas, headers, optional data types and custom options.
.csv / .tsv file with File, paste
cells copied from a spreadsheet with Google Sheet Style, or load Sample Data..json result in a new tab.What CSV to JSON does: it converts CSV to JSON entirely in your browser — a free CSV to JSON converter for turning a CSV to JSON array of objects, using the first row as keys. It is built for the common case: paste CSV, get valid JSON out.
Header row. The first line of the CSV becomes the object keys for every row after it. A CSV
with headers name,age and a data row Raj,50 becomes { "name": "Raj", "age": "50" }. Header
names are matched exactly as written, including case and spacing.
Quoted fields and commas inside fields. A field wrapped in double quotes may contain commas or
line breaks without being split into extra columns — for example "Lives in NY, USA" stays one
field. A double quote inside a quoted field is written as two double quotes (""), the standard
CSV escape, for example "He said ""yes""" becomes the text He said "yes".
Values stay strings unless you ask. By default every value in the output JSON is a string,
even when it looks like a number, such as "age": "50" rather than "age": 50, because guessing
would silently change IDs, postal codes or phone numbers with a leading zero. Turn on Auto detect
data types to write numbers and true/false as JSON numbers and booleans. Even then a value is
converted only when nothing can be lost: 30 becomes 30, but 00124, 1.50 and very long
integers stay strings. Dates are never converted.
Empty and null values. Convert empty values to null writes an empty cell as null instead
of "". Custom null values lets you list exact tokens, such as NA, N/A, that should also
become null.
Output shapes. Array of objects (the default) gives one object per row. Array of arrays
gives the header row followed by one array per row. JSON Lines gives one compact object per line.
Add metadata wraps the result as { "meta": { "rowCount", "columnCount", "columns" }, "data" }.
Browser-based processing. No upload is required. The CSV you paste is parsed on your own device, in a background worker, and never sent to a server.
What this tool does not do. This is a CSV to JSON converter only — for the reverse direction, use
JSON to CSV. It does not read Excel or .xlsx files, only plain CSV text. It
does not import data into a database, read live Google Sheets, or use AI to clean up messy data.
Related developer and data tools. Once you have JSON, format or validate it with JSON Formatter & Validator, or convert it back with JSON to CSV. For other everyday encoding tasks, see Base64 Encode & Decode and URL Encode & Decode.
Yes, by default the first row is the column headers and every row after it becomes one JSON object
using those headers as keys. Turn off First row as header and the columns are named
column_1, column_2 and so on.
By default values stay as strings: age,50 becomes "age": "50". Turn on Auto detect data
types to get "age": 50 and real booleans. Values such as 00124 or 1.50 stay strings even
then, so IDs and codes are never changed.
Yes. Wrap a field in double quotes to include a comma or a line break inside it, for example
"Lives in NY, USA". A double quote inside such a field is written as two double quotes ("").
Yes. Choose the delimiter in Parsing Options, or pick Auto detect and the tool uses the most frequent of comma, semicolon, tab and pipe on the first line.
Not as a file. Export your spreadsheet to CSV first, or select the cells, copy them, and paste them into the Google Sheet Style tab, which reads the tab-separated text a spreadsheet copies.
No. CSV to JSON online, right in your browser, with no account and no installation.
No. Conversion is a deterministic, rule-based CSV parser — the same input always produces the same output.
Not on this page, but JSON to CSV does exactly that — the reverse of this tool.
No. Parsing happens entirely in your browser. Nothing you paste is sent to a server.
The conversion stops with a clear error naming the duplicate header, rather than silently overwriting one column's data with another's.
The conversion stops with a clear error naming the line number of the row, rather than guessing which columns are missing or extra.