onlinejsontools logo

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.
ever need to work with xml? <foo>bar</foo>
We also have Online XML Tools — utilities for working with XML documents. Check it out!
fullscreen fullscreen_exit
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
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.
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
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
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 color code the syntax of a JSON file.
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 convert JSON to a PNG, GIF, JPG or BMP Image.
Quickly encode JSON to base64.
Quickly decode base64 to JSON.
Quickly convert JSON to URL-encoding.
Quickly convert URL-escaped JSON back to JSON.
Quickly convert JSON data to plain text.
Quickly edit a JSON file in a neat JSON editor in your web browser.
Coming soon These json tools are on the way
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 Bencode
Convert a JSON data structure to Bencode encoding.
Convert Bencode to JSON
Convert Bencode data to JSON data.
Convert JSON to BSON
Convert a JSON data structure to binary BSON data.
Convert BSON to JSON
Convert binary JSON data structure (BSON) to JSON.
Convert JSON to a LaTeX Table
Generate a LaTeX table from a JSON object.
Truncate JSON
Loop over JSON structure and truncate all values.
Convert JSON to Data URI
Convert a JSON data structure to a data URL.
Compare Two JSON Files
Diff JSON files and show differences visually.