📊CSV ↔ JSON Converter
Convert CSV data to JSON array and back. First row recognized as header; quoted and comma-containing values are properly handled. Useful for sending Excel data to APIs, processing report data, DB backup cleanup, and data migration.
How to use
- 1Paste CSV or JSON text.
- 2Pick direction (CSV→JSON / JSON→CSV).
- 3Copy the result or download as .csv/.json.
FAQ
What delimiters are supported?+
Comma (,) by default. You can switch to tab (\t) or semicolon (;) in settings. TSV (tab-separated) also works.
Can I paste Excel data directly?+
Copying Excel cells gives tab-separated TSV. Set the delimiter to tab and it converts directly.
Korean text is garbled — why?+
If the CSV file is EUC-KR/CP949 encoded, it may break. Convert to UTF-8 first with the Text Encoding tool.
Does it handle large CSVs?+
Tens of thousands of rows work fine. Very large files (tens of MB+) become memory-heavy in the browser.
What happens to nested JSON objects when going to CSV?+
Nested keys are flattened or become JSON strings. Flat 1D structures map best to CSV.
How do I get results into Excel?+
Download as CSV, then in Excel use Data → Get from Text and select UTF-8 encoding for clean import.