Skip to content

Latest commit

 

History

History
18 lines (13 loc) · 762 Bytes

README.md

File metadata and controls

18 lines (13 loc) · 762 Bytes
Raw

JSON to CSV converter

Parse nested JSON file and convert to CSV; Convert Yelp dataset to JSON

Usage

We need to first populate all the possible fields (JSON keys and sub keys). Ideally, place your JSON file under data folder.

$ php extract-fields.php data/[file_name].json

This will generate [file_name].json under fields folder. This file will be used in the next step. If you want to change the order of the fields in the CSV file or remove some fields, you can modify this file. However you need to be careful not to break JSON syntax.

Next, use convert-to-csv.php script to finally convert your JSON file to CSV.

$ php convert-to-csv.php data/[file_name].json

This will generate [file_name].csv file under output folder.