Formats

JSON → CSV

Convert JSON arrays to CSV format.

How to use it

  1. Open Devly from the wrench in your menu bar, or press ⌃⌥⌘D. Press ⌘P, type JSON → CSV and press Return.
  2. Paste or type your text into Input.
  3. Adjust the Options on the right if you need to. The defaults are listed below.
  4. Press Convert, or ⌘↵.
  5. Use Copy or ⇧⌘C to copy the result. ⌘L clears everything.

Options

OptionValuesDefault
DelimiterField separator characterComma (,), Semicolon (;), Tab, Pipe (|)Comma (,)
Include headersAdd column headers rowOn or offOn
Flatten nested objectsHow deep to flatten nested objectsNone, 1 level, 2 levels, All1 level
Array valuesHow to handle array valuesJoin with ;, JSON string, First valueJoin 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