CSV to JSON
Free online CSV to JSON converter. Paste CSV or upload a file and instantly convert to formatted JSON. Also converts JSON back to CSV. Supports custom delimiters, headers, and data types. No signup.
How to Use the CSV to JSON
Paste your CSV data into the left panel or upload a .csv file. The JSON output appears instantly on the right, formatted with 2-space indentation by default. Use the options row to set your delimiter, toggle headers, choose the output structure (array of objects, array of arrays, or keyed by column), and control type detection. The table preview below shows your parsed data with inferred types so you can verify the conversion before downloading. To convert JSON back to CSV, click the ⇄ toggle at the top.
About This Tool
A bidirectional converter between CSV and JSON formats. CSV (Comma-Separated Values) is the most widely supported data interchange format for spreadsheets, databases, and analytics tools. JSON (JavaScript Object Notation) is the standard format for web APIs, configuration files, and NoSQL databases. This tool’s parser is RFC 4180-compliant — it correctly handles quoted fields containing commas, embedded newlines, and escaped double-quotes. Auto-detect mode identifies the delimiter from the first line, supporting comma, tab, semicolon, and pipe-delimited files. Type inference detects numbers and booleans column-by-column for clean, structured JSON output. Zero external libraries — everything runs in your browser. Related: JSON Formatter for formatting and validating JSON, Word Counter for analyzing text content.
Quick Reference Table
| Output Structure | Best For |
|---|---|
| Array of objects | Most common — each row becomes a named object |
| Array of arrays | Compact — no headers, just nested arrays |
| Keyed by column | Data analysis — one array per column |
Frequently Asked Questions
Why are my numbers being converted to strings?
Type detection checks whether ALL values in a column can be parsed as the same type. If any value in a column is not a valid number — an empty cell, ‘N/A’, or a text value — the entire column stays as strings to prevent data loss. Enable ‘Treat empty as null’ in the options to allow columns with empty cells to still be detected as numbers.
My CSV uses semicolons — how do I handle that?
Set the delimiter to Semicolon (;) in the options. The Auto-detect option will usually detect semicolons automatically if they are more frequent than commas in the first line. Semicolon-delimited CSV is common in European locales where the comma is used as a decimal separator.
Can I convert a multi-sheet Excel file?
This tool converts CSV and JSON text formats. For Excel files (.xlsx), export each sheet from Excel as a separate CSV first (File → Save As → CSV). Excel can only export one sheet at a time as CSV.
What happens with special characters and Unicode?
This tool reads CSV files as UTF-8 text, which supports all Unicode characters including emoji, Chinese, Arabic, and Icelandic. If your CSV was saved in a different encoding, characters outside ASCII may display incorrectly. Re-save your file as UTF-8 before uploading.
What is the maximum file size?
There is no hard limit. Files up to 5MB process instantly. Larger files may take a moment — the tool shows a progress indicator and displays the first 50 rows in the preview while the full conversion completes.