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]

https://img.shields.io/pypi/v/jsoncsv.svg https://api.travis-ci.org/alingse/jsoncsv.svg?branch=master https://coveralls.io/repos/github/alingse/jsoncsv/badge.svg

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
id,name,year,zone
1,A,2015,
2,S,,china

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
id,name,year,zone
1,A,2015,
2,S,,china

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

Install

pip install jsoncsv

Usage

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":[1,2,{"w":1}]}
{"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 .

–safe

on safe mode, use escape separator to avoid confilct

expand:

[‘aa’, ‘bb’, ‘www.xxx.com’] –> ‘aa.bb.www.xxx.com’

restore:

‘aa.bb.www.xxx.com’ –> [‘aa’, ‘bb’, ‘www.xxx.com’]

mkexcel

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

NOTE/TODO

1. dict keys can’t be just array indexes

example:

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.

Project details


Download files

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

Files for jsoncsv, version 2.2.5
Filename, size File type Python version Upload date Hashes
Filename, size jsoncsv-2.2.5.tar.gz (8.9 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page