Last updated: March 2026
How to Convert CSV to JSON
Step 1: Paste your CSV data or upload a .csv file. Step 2: Choose your output format (array of objects is the most common). Step 3: Copy the JSON or download as a .json file.
The converter automatically detects headers from the first row and converts numeric strings to actual numbers. Both features can be toggled off if needed.
CSV to JSON Output Formats
Array of objects (default): Each row becomes a JSON object with column headers as keys. This is the most common format for APIs and JavaScript applications.
Array of arrays: Each row becomes a simple array of values, without keys. Useful for data processing and charting libraries that expect tabular data.
Keyed by column: Each column becomes a key with an array of all values in that column. Useful for statistical analysis and column-oriented operations.
Frequently Asked Questions
How do I convert CSV to JSON?
Paste your CSV data into the input box with the CSV → JSON tab selected. The converter automatically parses headers from the first row and creates a JSON array of objects. Adjust output format, delimiter, and number detection as needed.
What JSON output formats are available?
Three formats: Array of objects (default) where each row becomes an object with header keys, Array of arrays where each row is a simple array, and Keyed by column where each column becomes an array of values.
Does it auto-detect numbers?
Yes, by default. Values like '42', '3.14', 'true', and 'false' are automatically converted to their JSON types instead of remaining strings. You can disable this if you want all values as strings.
What delimiters are supported?
Comma (default), tab, semicolon, and pipe. European CSV files often use semicolons since commas are decimal separators in many European locales. Tab-separated files (.tsv) are also common.
How are quoted fields handled?
The converter properly handles RFC 4180 CSV quoting. Fields containing commas, newlines, or quotes are enclosed in double quotes. Escaped quotes (doubled quotes) are handled correctly.
Can I convert Excel spreadsheets?
Not directly — this tool accepts CSV text. First export your Excel file as CSV (File → Save As → CSV), then paste the contents here. Or save as .csv and upload the file using the Upload button.