Most real-world JSON is significantly more complex than either of these simple examples, to the point where we can say that the problem is not possible to solve in the general case without manual work on your part to separate out and normalize the data you want into a structure which is suitable for representing as a CSV matrix. Once you have done that, you can do the following using Pandas to write the CSV file: import pandas as pd df pd.readjson (r) df.tocsv ('output.csv') Share Improve this answer Follow edited at 8:54 answered at 13:18 n1k31t4 14.4k 2 26 47 well that is perfect answer. This is not typical, but definitely within the realm of valid corner cases that Python could not possibly guess on its own how to handle.)

(Just to make it more interesting, one field is missing, and the dictionary order varies from one record to the next. Many records of the below format are returned:

With open(root_dir + 'filename.json') as json_file: I have a large Jsonl file (6GB+) which I need to convert to.

Json to csv python