Sometimes you need to convert large JSON files to other formats, like CSV, TSV, Excel, XML, or SQL.
If you don’t like to program, you can try Withdata DataFileConverter, a native GUI tool, support Windows, Linux, and macOS.
Here’s how to.
A huge JSON file for test, 8M_lines.json 6.38 GB.
Run DataFileConverter, click “Start a New Convert”.
From “JSON”, To “CSV”.
You can convert to other formats also, TXT, TSV, Excel, XML, Html, or SQL.
Open JSON file.
Set CSV file.
Click “Save Session” button, then enter a session file name.
click “OK” button.
Click the “Open a Saved Session” in task window, select a session file.
Then the wizard form shows, click “Next”, and “Next”.
Run in command line
When you save session, you can click “Save & Make Batch File”.
The “Save & Make Batch File” form shows.
Click “OK” button, you’ll create a batch file, in Windows, like this:
C: cd "C:\Users\pansh\AppData\Local\Programs\DataFileConverter" DataFileConverter session="C:\Users\pansh\Documents\8M_lines.dfc" logfile="C:\Users\pansh\Documents\8M_lines.log"
You can run this batch file in command line.
Run as scheduled task
On Linux/macOS, you can use Crontab.
For macOS, How to Fix Cron Permission Issues in macOS.
On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.
And then, with scheduled task wizard, step by step.
You’ll see created task listed in scheduled task list.