CSV to JSON Converter

Convert CSV to JSON online. Paste or upload CSV, get clean JSON instantly

Use this free CSV to JSON converter to convert CSV to JSON online in one step. Paste CSV text or upload a file, auto-detect delimiters, and get pretty-printed JSON with headers as object keys. Works as a CSV to JSON tool for exports from Excel, Google Sheets, databases, and APIs. 100% client-side. Your data never leaves your browser.

From the blog
Emergent Leader Pattern in Distributed Systems

How peer-to-peer clusters pick a coordinator by age, without ever running a leader election

Read

Developer tools Latest posts Explainers

JSON
JSON output will appear here

CSV Quick Reference

CSV Rules

delimiter,   tab   ;   |
"quoted"Fields with commas or newlines
""Escaped quote inside quotes
headerFirst row → JSON keys
BOMUTF-8 BOM is stripped

Output Shapes

headers on[{ "a": "1" }, …]
headers off[["a", "1"], …]
empty cell""
all stringsNumbers stay as text
pretty2-space indented JSON

CSV to JSON Guide

What is a CSV to JSON converter?

A CSV to JSON converter turns tabular plain text into structured JSON that APIs, frontends, and scripts can consume. CSV is common for spreadsheet exports and data dumps. JSON is the default interchange format for web apps and most modern services.

This tool runs in your browser. Paste CSV, upload a file, or drop one onto the input panel. You get pretty-printed JSON you can copy or download. No account, no upload to a server.

Headers vs arrays

With First row is header enabled (the default), the first row becomes object keys and every following row becomes an object. That is the usual shape for APIs and configuration.

Turn headers off when your file has no header row, or when you want a raw matrix as a JSON array of arrays. Empty cells become empty strings so column counts stay aligned.

Delimiters and quoting

Most files use commas. Spreadsheet exports may use tabs (TSV) or semicolons. Leave Delimiter on Auto to sniff the first non-empty line, or pick Comma, Tab, Semicolon, or Pipe yourself.

  • Quoted fields: Wrap values that contain the delimiter or newlines in double quotes.
  • Escaped quotes: Inside a quoted field, write "" for a literal quote.
  • UTF-8 BOM: A leading BOM from Excel is removed automatically.

Using this CSV to JSON tool

  • Convert: Parses the CSV and updates the JSON panel. Conversion also runs as you type (debounced).
  • Copy / Download: Copy JSON to the clipboard or save a .json file.
  • Sample / Clear: Load an example or reset both panes.
  • Upload: Open a .csv, .tsv, or .txt file from disk.

Need to validate or beautify the result afterward? Use the free JSON Validator & Formatter. Working with YAML configs instead? Try the YAML Validator. For encoding payloads, see the Base64 Encoder & Decoder.

CSV to JSON FAQ

How do I convert CSV to JSON online?

Paste your CSV into the input area or upload a .csv file. The converter detects the delimiter, treats the first row as headers by default, and shows pretty-printed JSON on the right. Click Copy or Download to use the result.

What is CSV to JSON conversion?

CSV to JSON conversion turns rows of delimited text into a JSON array. With headers enabled, each row becomes an object whose keys come from the first row. Without headers, each row becomes an array of string values.

Does this CSV to JSON converter support tabs and semicolons?

Yes. Choose Auto to detect the delimiter, or pick Comma, Tab, Semicolon, or Pipe manually. Auto works well for TSV exports and European CSV files that use semicolons.

Is my CSV data safe when using this tool?

Yes. Conversion runs entirely in your browser with JavaScript. Your CSV is never uploaded to a server. Processing stays on your device.

How are quoted fields and commas inside values handled?

The parser follows RFC 4180 rules. Fields wrapped in double quotes can contain commas, newlines, and escaped quotes written as "". Unclosed quotes produce a clear error with line and column information.

Can I convert an Excel CSV export to JSON?

Yes. Export your spreadsheet as CSV or TSV, then paste the text or upload the file. If Excel used semicolons or tabs, set Delimiter to Auto or choose the matching option.

What JSON structure does the converter produce?

With First row is header on, you get [{ "column": "value", ... }, ...]. With headers off, you get [["value", ...], ...]. Values are strings; empty cells become empty strings.

Is this CSV to JSON converter free?

Yes. It is free to use with no signup. After the page loads, it also works offline because all parsing happens in your browser. You can also validate the output with the JSON Validator.