Can anyone advise me on right application to use to convert JSON file to excel?
The file is over 50gig
Somebody please tell me what to use . PM if you got an idea

(April 5, 2022, 08:01 AM)cvalgalaxy Wrote: Can anyone advise me on right application to use to convert JSON file to excel?
The file is over 500g 
Somebody please tell me what to use .

500GB the fuck you converting?

https://github.com/zemirco/json2csv

Which programming language are you looking to integrate it in?

(April 6, 2022, 11:07 PM)Minori Wrote:

(April 5, 2022, 08:02 AM)vince Wrote:

(April 5, 2022, 08:01 AM)cvalgalaxy Wrote: Can anyone advise me on right application to use to convert JSON file to excel?
The file is over 500g 
Somebody please tell me what to use .

500GB the fuck you converting?

500GB files are common + he saud 59 not 500.

He edited it to 50+. But what files are 500gb+? Thats more than my ssd space..

If you are used to work with Python, I recommend to use pandas library.

df = pd.read_json()
df.to_csv()

thanks for sharing

(August 29, 2022, 01:26 PM)STAN10169 Wrote: thanks for sharing

I do believe it's less about the tool to convert but more about the time and computation power you have for the converting process, and maybe RAM too, a good idea to make your own code as to not read the whole Json file and overload your RAM or something. I might be wrong though

I found this https://github.com/cuikangjie/JsonExportExcel and https://github.com/rikkertkoppes/json2xls. It looks promising, depends on how complex your json is.

thanks for sharing