Formats
CSV → JSON
Convert CSV data to JSON format.
How to use it
- Open Devly from the wrench in your menu bar, or press ⌃⌥⌘D. Press ⌘P, type CSV → JSON and press Return.
- Paste or type your text into Input.
- Adjust the Options on the right if you need to. The defaults are listed below.
- Press Convert, or ⌘↵.
- Use Copy or ⇧⌘C to copy the result. ⌘L clears everything.
Options
| Option | Values | Default |
|---|---|---|
| DelimiterField separator character | Auto-detect, Comma (,), Semicolon (;), Tab, Pipe (|) | Auto-detect |
| First row is headersUse first row as property names | On or off | On |
| Parse numbersConvert numeric strings to numbers | On or off | On |
| Trim whitespaceRemove leading/trailing spaces | On or off | On |
| Output FormatJSON structure format | Array of Objects, Array of Arrays | Array of Objects |
Example
Real output from Devly, with the default options.
Input
name,category,offline Base64,Encoding,true JSON Formatter,Formats,true HTTP Client,Dev Utils,false
[
{
"category" : "Encoding",
"name" : "Base64",
"offline" : true
},
{
"category" : "Formats",
"name" : "JSON Formatter",
"offline" : true
},
{
"category" : "Dev Utils",
"name" : "HTTP Client",
"offline" : false
}
]From Terminal
With the free command-line tool installed:
Terminal
devly csv2json --path input.txt # or pipe text in pbpaste | devly csv2json
Quick Switch also finds it by: csv, json, convert, spreadsheet, table, data.
More Formats tools
JSON FormatterFormat, validate, and minify JSON with syntax highlightingJSON Path QueryQuery JSON data using JSONPath expressionsJSON ↔ YAMLConvert between JSON and YAML formatsYAML FormatterFormat, validate, and beautify YAML documentsXML FormatterFormat, validate, and beautify XML documentsXML ↔ JSONConvert between XML and JSON formats