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.
Preview
- 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
- Choose CSV → JSON or JSON → CSV from the tabs.
- Paste data into the left box, or click Open file to load a CSV or JSON file. Click Sample to try it.
- Set options such as Delimiter, Use the first row as headers and JSON format. The result appears on the right.
- 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.
Updates to this tool
All updatesReleased 19 new tools, including find and replace, date and business-day calculators, a tsubo/m² converter, image cropping, transparent PNGs, .htaccess redirects, robots.txt and a timer, for 44 tools in total
Other free tools
All 183 free tools- JSON Formatter and ValidatorFormat or minify JSON and find syntax errors with their position.
- Encoder and DecoderConvert URL encoding, Base64, HTML entities and Unicode escapes both ways.
- Hash and UUID GeneratorCalculate MD5 and SHA hashes of text or files, verify checksums and generate UUID v4 in bulk.
- Regex TesterTest JavaScript regular expressions with highlighted matches, groups and a replacement preview.
- Unix Timestamp ConverterConvert Unix timestamps (seconds or milliseconds) to and from dates in Japan time, UTC and ISO 8601.
- Color Code Converter (HEX, RGB, HSL, CMYK)Convert colors between HEX, RGB, HSL, HSV and CMYK, find the nearest color name and copy CSS.
- Markdown Preview and Markdown to HTML ConverterWrite Markdown with a live preview and copy the converted HTML. Tables and task lists supported.
- JWT DecoderDecode a JWT to view its header and payload, with exp and iat converted to dates.