CSV / JSON

CSV to JSON / JSON to CSV Converter

Paste CSV or JSON, or open a file, and convert it in one step. Quoted values with commas or line breaks are handled correctly, and you can check the result in a table. CSV downloads include a BOM so Excel opens Japanese and other non-English text correctly. Your data never leaves this page.

Files saved from Excel in Shift_JIS can also be opened.

  • The CSV reader follows RFC 4180: values with commas, double quotes or line breaks must be wrapped in double quotes, and a double quote inside a value is written as "".
  • When converting JSON to CSV, all keys that appear in any item become headers, in the order they first appear. Arrays inside items are written as JSON text.
  • CSV is written with CRLF line endings. Everything is processed in your browser and nothing is sent or saved.

About this tool

Convert CSV to JSON (an array of objects or arrays) and JSON to CSV. Commas and line breaks inside quoted values, auto-detected tab and semicolon delimiters and Shift_JIS files saved from Japanese Excel are all handled. Check the result in a table preview, and download CSV with a BOM so it opens correctly in Excel. Your data is converted in your browser and never uploaded.

How to use

  1. Choose CSV → JSON or JSON → CSV from the tabs.
  2. Paste data into the left box, or click Open file to load a CSV or JSON file. Click Sample to try it.
  3. Set options such as Delimiter, Use the first row as headers and JSON format. The result appears on the right.
  4. Check it in the Preview table, then Copy or Download it.

Useful for

  • Turning a spreadsheet into JSON for code or an API
  • Turning JSON from an API into a CSV you can open in Excel
  • Changing the format of product data or contact lists for another system
  • Checking in a table that CSV columns line up

FAQ

Why does my CSV look garbled in Excel?

Excel may not read UTF-8 CSV correctly without a BOM. CSV downloads from this tool include a BOM by default.

Can nested JSON be converted to CSV?

Yes. Nested objects are expanded into columns with headers like a.b (you can turn this off), and arrays inside items are written as JSON text in one cell.

Are commas and line breaks inside values supported?

Yes. Quoted values are parsed according to RFC 4180, including commas, line breaks and doubled quotes.

Is my data uploaded?

No. Everything, including opened files, is processed in your browser.

Contact