All Projects → vinay20045 → Json To Csv

vinay20045 / Json To Csv

Licence: mit
Nested JSON to CSV Converter

Programming Languages

python
139335 projects - #7 most used programming language

Labels

Projects that are alternatives of or similar to Json To Csv

Jsonexport
{} → 📄 it's easy to convert JSON to CSV
Stars: ✭ 208 (-3.7%)
Mutual labels:  json, csv
Csvreader
csvreader library / gem - read tabular data in the comma-separated values (csv) format the right way (uses best practices out-of-the-box with zero-configuration)
Stars: ✭ 169 (-21.76%)
Mutual labels:  json, csv
Criterion
Microbenchmarking for Modern C++
Stars: ✭ 140 (-35.19%)
Mutual labels:  json, csv
Json 2 Csv
Convert JSON to CSV *or* CSV to JSON!
Stars: ✭ 210 (-2.78%)
Mutual labels:  json, csv
Octosql
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
Stars: ✭ 2,579 (+1093.98%)
Mutual labels:  json, csv
Administrative Divisions Of China
中华人民共和国行政区划:省级(省份直辖市自治区)、 地级(城市)、 县级(区县)、 乡级(乡镇街道)、 村级(村委会居委会) ,中国省市区镇村二级三级四级五级联动地址数据。
Stars: ✭ 11,727 (+5329.17%)
Mutual labels:  json, csv
Uxdm
🔀 UXDM helps developers migrate data from one system or format to another.
Stars: ✭ 159 (-26.39%)
Mutual labels:  json, csv
Ssl Checker
Python script that collects SSL/TLS information from hosts
Stars: ✭ 94 (-56.48%)
Mutual labels:  json, csv
Validation
validation api extracted from play
Stars: ✭ 194 (-10.19%)
Mutual labels:  json, csv
Bancosbrasileiros
Lista de bancos brasileiros | Brazilian banks list
Stars: ✭ 178 (-17.59%)
Mutual labels:  json, csv
Kafka Connect Spooldir
Kafka Connect connector for reading CSV files into Kafka.
Stars: ✭ 116 (-46.3%)
Mutual labels:  json, csv
Unbescape
Advanced yet easy to use escaping library for Java
Stars: ✭ 207 (-4.17%)
Mutual labels:  json, csv
Just Dashboard
📊 📋 Dashboards using YAML or JSON files
Stars: ✭ 1,511 (+599.54%)
Mutual labels:  json, csv
Elasticsearch Dataformat
Excel/CSV/BulkJSON downloads on Elasticsearch.
Stars: ✭ 135 (-37.5%)
Mutual labels:  json, csv
Iso 3166 Countries With Regional Codes
ISO 3166-1 country lists merged with their UN Geoscheme regional codes in ready-to-use JSON, XML, CSV data sets
Stars: ✭ 1,372 (+535.19%)
Mutual labels:  json, csv
Omniparser
omniparser: a native Golang ETL streaming parser and transform library for CSV, JSON, XML, EDI, text, etc.
Stars: ✭ 148 (-31.48%)
Mutual labels:  json, csv
Tabtoy
高性能表格数据导出器
Stars: ✭ 1,302 (+502.78%)
Mutual labels:  json, csv
Filecontextcore
FileContextCore is a "Database"-Provider for Entity Framework Core and adds the ability to store information in files instead of being limited to databases.
Stars: ✭ 91 (-57.87%)
Mutual labels:  json, csv
Django Import Export
Django application and library for importing and exporting data with admin integration.
Stars: ✭ 2,265 (+948.61%)
Mutual labels:  json, csv
Chronicle Wire
A Java Serialisation Library that supports multiple formats
Stars: ✭ 204 (-5.56%)
Mutual labels:  json, csv

json-to-csv

Nested JSON to CSV Converter.

This python script converts valid, preformatted JSON to CSV which can be opened in excel and other similar applications. This script can handle nested json with multiple objects and arrays. Please see the explanation below and the sample files to understand how this works. It can handle non similar objects too. But, more the similarity of the objects, prettier the output.

Written in Python 2.7. Last tested in Python 3.6.3.

Usage

python /path/to/json_to_csv.py node json_in_file_path csv_out_file_path

Source Specification

The script expects the json to be given via a file containing

  • A valid JSON
  • The JSON can be an Array of node Object Ex:-
    {
        "node":[
            {
                "item_1":"value_11",
                "item_2":"value_12",
                "item_3":"value_13",
                "item_4":["sub_value_14", "sub_value_15"],
                "item_5":{
                    "sub_item_1":"sub_item_value_11",
                    "sub_item_2":["sub_item_value_12", "sub_item_value_13"]
                }
            },
            {
                "item_1":"value_21",
                "item_2":"value_22",
                "item_4":["sub_value_24", "sub_value_25"],
                "item_5":{
                    "sub_item_1":"sub_item_value_21",
                    "sub_item_2":["sub_item_value_22", "sub_item_value_23"]
                }
            }
        ]
    }
  • The JSON can be a list of dictionaries
  • If your JSON is a list of dictionaries, the first argument node can be any relevant string
    [
        {
            "item_1":"value_11",
            "item_2":"value_12",
            "item_3":"value_13",
            "item_4":["sub_value_14", "sub_value_15"],
            "item_5":{
                "sub_item_1":"sub_item_value_11",
                "sub_item_2":["sub_item_value_12", "sub_item_value_13"]
            }
        },
        {
            "item_1":"value_21",
            "item_2":"value_22",
            "item_4":["sub_value_24", "sub_value_25"],
            "item_5":{
                "sub_item_1":"sub_item_value_21",
                "sub_item_2":["sub_item_value_22", "sub_item_value_23"]
            }
        }
    ]

Gotchas

I have written a JSON generator which will take care of encoding issues and generate a valid JSON for this tool. However, If you find yourself in the character encoding hell, drop me a mail and I will add support for this This is now fixed.

Read More

Visit converting nested json to csv post on my blog to read more about this script.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].