onlinejsontools logo
build

Csv to json converter

World's simplest json tool

Free online CSV to JSON converter. Just paste your CSV in the input field below and it will automatically get converted to JSON. There are no ads, popups or nonsense, just an awesome CSV to JSON transformer. Paste CSV, get JSON. Created by developers for developers.
settings
fullscreen fullscreen_exit
swap_horiz
star
Import from file
Save as...
Copy to clipboard
Can't convert.
An error has occured.
Export to Pastebin
Save as...
Copy to clipboard
Characters
Column separating character
Skip lines starting with this
Use a custom quote character
Converting
First row is treated as header
Don't convert empty lines
Don't quote numbers and bools
Indentation
Indent output with two spaces
Indent output with one tab
Output minified result
help
Csv to json converter tool What is a csv to json converter?
This tool transpiles CSV (Comma Separated Values) to JSON (JavaScript Object Notation) files. You can change column separating character, field quote character, skip commented lines, skip empty lines, disable or enable CSV headers, set custom indentation, and choose if you want to quote numeric and boolean values.
books
Csv to json converter examples Click to use
Simple example
This example converts a four-column CSV to a JSON array and it skips empty lines.
season,weather winter,cold spring,warm summer,hot autumn,chilly[ [ "season", "weather" ], [ "winter", "cold" ], [ "spring", "warm" ], [ "summer", "hot" ], [ "autumn", "chilly" ] ]
Required options
These options will be used automatically if you select this example.
Don't convert empty lines
Always use CSV headers
This example turns CSV headers option on, which converts column titles to JSON object keys. It also minifies the output.
foo,bar,baz,moo 1,2,3,4 a,b,c,d[{"foo":"1","bar":"2","baz":"3","moo":"4"},{"foo":"a","bar":"b","baz":"c","moo":"d"}]
Required options
These options will be used automatically if you select this example.
First row is treated as header
Output minified result
info
Pro tips Master online json tools
You can pass input to this tool via ?input query argument and it will automatically compute output. Here's how to type it in your browser's address bar. Click to try!
https://onlinejsontools.com/convert-csv-to-json?input=season%2Cweather%0Awinter%2Ccold%0A%0Aspring%2Cwarm%0A%0Asummer%2Chot%0Aautumn%2Cchilly&convert-skip-empty=true
dashboard
All json tools
Didn't find the tool you were looking for? Let us know what tool we are missing and we'll build it!
Quickly beautify a JSON data structure.
Quickly compress a JSON file.
Quickly check JSON for errors and report them.
Quickly escape special JSON characters.
Quickly unescape an escaped JSON string.
Quickly convert a JSON data structure to an XML file.
Quickly convert an XML file to a JSON data structure.
Quickly convert a JSON data structure to a YAML file.
Quickly convert YAML markup to a JSON data structure.
Quickly convert a JSON file to a TSV file.
Quickly convert TSV data to a JSON file.
Quickly convert a JSON document to a CSV document.
Quickly convert a CSV document to a JSON document.
Quickly encode JSON to base64.
Quickly decode base64 to JSON.
Quickly convert JSON data to plain text.
airport_shuttle
Coming soon These json tools are on the way
Preview JSON in a Browser
Add syntax highlighting to JSON and show it in your browser.
Display JSON Statistics
Display detailed information about a JSON data structure.
Flatten JSON
Loop over JSON structure and extract all values as a list.
Convert JSON to a HTML
Create a HTML table from JSON object keys and values.
Convert JSON to a LaTeX Table
Generate a LaTeX table from a JSON object.
Compare Two JSON Files
Diff JSON files and show differences visually.
URL-encode a JSON object
URL-encode a JSON data structure.