SQLITE3 to JSON
Turn SQLite database files into JSON data files on your own Mac, Windows or Linux computer. Asteria is free, works offline, and never uploads your files.
How to do it
- Download Asteria and open it. It's free and needs no account.
- Drop your SQLITE3 files onto its window, or press ⌘O (Ctrl O on Windows) to choose them. Drop as many as you like.
- Type sqlite3 to jsonand pick SQLite to JSON. Every table as a list of row objects.
- Press ⌘↵ (Ctrl ↵ on Windows) to save. The JSON files appear next to the originals, which stay exactly as they were.
What it needs
Nothing. This conversion is built into Asteria, so it works the moment the app is open, even offline.
How it was tested
A real SQLITE3 file was converted on macOS on Apple silicon and Linux, and the JSON that came out was opened and checked with Python parser to make sure it is what it says it is.
Download Asteria
Free for Mac, Windows and Linux. Other systems and first-launch help