Formats
JSON → CSV
Convert JSON arrays to CSV format.
How to use it
- Open Devly from the wrench in your menu bar, or press ⌃⌥⌘D. Press ⌘P, type JSON → CSV 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 | Comma (,), Semicolon (;), Tab, Pipe (|) | Comma (,) |
| Include headersAdd column headers row | On or off | On |
| Flatten nested objectsHow deep to flatten nested objects | None, 1 level, 2 levels, All | 1 level |
| Array valuesHow to handle array values | Join with ;, JSON string, First value | Join with ; |
Example
Real output from Devly, with the default options.
Input
[{"name":"Base64","category":"Encoding"},{"name":"JSON Formatter","category":"Formats"},{"name":"Cron Parser","category":"Dev Utils"}]category,name Encoding,Base64 Formats,JSON Formatter Dev Utils,Cron Parser
From Terminal
With the free command-line tool installed:
Terminal
devly json2csv --path input.txt # or pipe text in pbpaste | devly json2csv
Quick Switch also finds it by: json, csv, convert, spreadsheet, table, export.
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