← Back to tools

CSV to JSON

Paste CSV data, get a JSON array. Auto-detects types and headers.

CSV Input
JSON Output 

      

    

  











CSV (Comma-Separated Values) is the simplest tabular data format — just rows and columns separated by commas. It's the universal export format for spreadsheets, databases, and analytics tools. But modern APIs and web applications expect JSON, so conversion between the two is one of the most common data tasks.


The first row of a CSV is typically the header row, defining column names. Each subsequent row becomes a JSON object where the keys are the header names and the values are the cell contents. This tool auto-detects data types: numbers become JSON numbers (not strings), "true"/"false" become booleans, and empty cells become null.


CSV parsing has edge cases that trip up naive implementations: values containing commas must be quoted ("New York, NY"), values containing quotes must escape them by doubling (""quoted""), and newlines within quoted values are valid. This tool handles all RFC 4180 edge cases correctly.




This tool in other languages:


Français:
Convertisseur CSV en JSON


Español:
Convertidor de CSV a JSON


Deutsch:
CSV-zu-JSON Konverter


Português:
Conversor de CSV para JSON


日本語:
CSVからJSONへの変換


中文:
CSV 转 JSON 工具


한국어:
CSV를 JSON으로 변환


العربية:
محول CSV إلى JSON









  
Frequently asked questions


  

    How do I convert CSV data to JSON?
    

      
Paste your CSV (with or without header row) into the input and click Convert. The first row is treated as headers, and each subsequent row becomes an object in the output array. Click Copy JSON to grab the result.

    

  


  

    Does the converter auto-detect data types?
    

      
Yes. Numeric values become JSON numbers, true/false become booleans, empty cells become empty strings (or null), and everything else stays as strings. Quoted values in CSV are always treated as strings, even if they look numeric.

    

  


  

    Can I paste data directly from Excel or Google Sheets?
    

      
Yes. Copy a range of cells from Excel or Sheets and paste — the clipboard format is typically tab-separated (TSV), which this tool auto-detects. For genuine comma-separated CSV, just paste normally.

    

  


  

    How does the tool handle CSV fields with commas or quotes inside them?
    

      
Standard CSV rules: values containing commas, newlines, or quotes are wrapped in double quotes, and literal double quotes are escaped by doubling (""). The parser handles these correctly — a value like "Smith, Jane" parses as a single field.

    

  


  

    What if my CSV file uses semicolons or tabs instead of commas?
    

      
The converter auto-detects common delimiters: comma, semicolon, and tab. European Excel exports often use semicolons as separators; TSV files from spreadsheets use tabs. All three work without configuration.