CSV

Paste CSV or TSV here

Or drag and drop a file anywhere in this pane. You can also paste anywhere on the page: Ctrl+V / ⌘V

JSON

Convert CSV to JSON or turn a JSON array into CSV. Paste your data or choose a file, then copy or download the result.

  1. Convert CSV and JSON in both directions
  2. Preserve CSV identifiers and leading zeros
  3. Process files locally in your browser

Move tabular data between CSV and JSON

Convert comma separated rows into a JSON array of objects, or turn a flat JSON array into CSV. CSV column names become object keys, and CSV values remain strings so identifiers and leading zeros are preserved.

How to convert CSV and JSON

  1. Choose CSV to JSON or JSON to CSV.
  2. Paste your data, choose a local file, or load the example. The result updates automatically.
  3. Copy or download the result. Use the arrow between the panes to switch direction and use the result as your next input.

Preserve identifiers during conversion

Load the CSV example. The identifier 002 remains the string "002" in JSON, and 9007199254740993 remains a quoted string with every digit intact. When entering JSON yourself, put large integer identifiers in quotation marks.

Turn spreadsheet rows into JSON records

Prepare a flat export for an API or spreadsheet

Use CSV to JSON when each spreadsheet row should become a record with named fields. Use JSON to CSV when you have an array of flat records to review in a spreadsheet. The first CSV row supplies the field names.

Keep identifiers intact

A CSV value such as 00123 becomes the JSON string "00123", not the number 123. This keeps postal codes and product IDs intact. CSV does not describe data types, so the converter leaves values as strings rather than guessing whether they are numbers or booleans.

Rows from a table connect to separate record groups, with matching colors linking each row to its data.

CSV and JSON conversion questions