Skip to main content

A command tool easily convert json file to csv or xlsx.

Project description

jsoncsv : easily convert json to csv or xls[x]

jsoncsv (with mkexcel) is a command tool to convert json file to csv/xlsx file.

It’s simple, and no need user to specify the keys.

Just use them.

Quick Start :

cat the raw.json to csv/xls use command line tool

cat raw.json | jsoncsv | mkexcel > output.csv
cat raw.json | jsoncsv | mkexcel -t xls > output.xls

make sure each line of raw json text file is a json object

$cat raw.json
{"id":1, "name":"A", "year": 2015}
{"id":2, "name":"S", "zone": "china"}
$cat raw.json | jsoncsv | mkexcel > output.csv
$cat output.csv

This is easily and needn’t care the different keys from any two object.

if input file is an json_array, use -A/–array to decode it

$cat raw.json
[{"id":1, "name":"A", "year": 2015}, {"id":2, "name":"S", "zone": "china"}]
$cat raw.json | jsoncsv -A | mkexcel > output.csv
$cat output.csv

another way to convert file step by step

$jsoncsv raw.json expand.json
$mkexcel expand.json -t xls output.xls

get more options with –help.

jsoncsv --help
mkexcel --help


pip install jsoncsv


see #QuickStart and get more options with –help.

just expand/restore the json, the expand json is one layer json.

jsoncsv raw.json expand.json
jsoncsv -r expand.json raw.json
cat raw.json | jsoncsv | jsoncsv -r > raw2.json

mkexcel the expanded json (one layer)

mkexcel expand.json output.csv
mkexcel -t xls expand.json > output.xls
mkexcel -t csv expand.json > output.csv

-e, –expand

expand json, 展开 json

$jsoncsv -e raw.json expand.json
$cat raw.json expand.json
{"s.2.w": 1,"s.0": 1,"s.1": 2}

{“s”:[1,2,{“w”:1}]} will transformed to {“s.2.w”: 1,”s.0”: 1,”s.1”: 2}

the output “expand.json” is only one layer json, it can be easy change to csv or xlsx (with mkexcel)

-r, –restore

restore the expanded json 重构被展开的json

jsoncsv -r expand.json raw.json
cat expand.json raw.json
{"s.2.w": 1,"s.0": 1,"s.1": 2}
{"s": [1, 2, {"w": 1}]}

{“s.2.w”: 1,”s.0”: 1,”s.1”: 2} change to {“s”:[1,2,{“w”:1}]}

-s, –separator

separator used for combine the keys in the tree

default separator is .


on safe mode, use escape separator to avoid confilct


[‘aa’, ‘bb’, ‘’] –> ‘’


‘’ –> [‘aa’, ‘bb’, ‘’]


dump expanded (by jsoncsv) json file to csv or xls file

mkexcel expand.json output.csv

-t, –type

chose dump type in [‘csv’, ‘xls’] default is ‘csv’

cat expand.json|mkexcel -t csv > output.csv
cat expand.json|mkexcel -t xls > output.xls


1. dict keys can’t be just array indexes


echo '{"0":1,"1":[1,2]}'|jsoncsv -e| jsoncsv -r
[1, [1, 2]]

2. mkexcel enable hooks

wait next next version

3. unicodecsv is not good enough

but better than python strand library csv.

4. Windows is poor support


try use instead

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

jsoncsv-2.2.5.tar.gz (8.9 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page