How do I convert CSV to JSON?

Paste your CSV data (with headers in the first row) and click Convert. Each row becomes a JSON object, with column headers as keys. The output is a JSON array of objects.

Does the CSV need headers?

Yes, the first row should be column headers. These become the JSON property names. If your CSV has no headers, add them manually before converting.

How are data types handled?

Numbers are automatically converted to numeric types, "true"/"false" become booleans, and empty cells become null. Everything else stays as a string.

Can I convert TSV (tab-separated values)?

Currently the tool expects comma-separated values. For TSV data, do a quick find-and-replace to change tabs to commas first, then paste into the converter.

CSV 转 JSON

将 CSV 转为结构化 JSON

CSV 输入

Loading editor...

JSON 输出

Loading editor...

Turn spreadsheet exports into structured JSON

CSV is everywhere — exports from databases, CRMs, analytics tools, and finance systems all show up as comma-separated rows. Converting that into JSON gives you keyed objects, proper data types for numbers and booleans, and an array shape that fits naturally into APIs, app state, and database imports.

Use the converter when you need to

Feed a CSV export into an API

Transform a dataset from analytics or finance into JSON so you can POST it to an internal service or webhook.

Seed test data for an app

Take a sample CSV and produce a JSON array you can drop into fixtures, mock servers, or local databases.

Hand a dataset to a frontend developer

JSON arrays are easier to consume in JavaScript than parsing CSV by hand — convert once, ship the JSON.

How to convert CSV to JSON quickly

1
Paste your CSV (with headers in the first row) into the editor.
2
Click Convert to map each row to a JSON object using header names as keys.
3
Copy the JSON output or download it for direct use in your app.

Keep going

Convert JSON back to CSV

Round-trip the data when a downstream consumer needs CSV instead.

Format the JSON output

Beautify the converted JSON before pasting into code or a request body.

Validate the result

Confirm the converted JSON parses cleanly before sending it to an API.

Explore the converted data

Use the tree view to make sure nested fields and types look right.

Common CSV-to-JSON workflows

Migrate spreadsheet data into an app

Convert a one-off CSV export from a colleague into JSON your code can consume directly.

Build mock fixtures from real data

Take production CSV exports and turn them into JSON fixtures for local dev and tests.

Bulk-create records via API

Convert a CSV of customers, products, or events into JSON your batch endpoint can ingest.

常见问题

粘贴 CSV（第一行是表头），点击 Convert。每一行会变成一个 JSON 对象，表头作为 key。输出是一个对象数组。

必须。第一行需要是列名，它们会作为 JSON 的属性名。如果你的 CSV 没有表头，请先手动补上再转换。

数字会自动转为 number；"true"/"false" 会转为 boolean；空单元格会转为 null；其他内容保持为 string。

目前工具按逗号分隔解析。TSV 可以先快速替换：把 tab 替换成逗号，再粘贴到转换器里。