SQLite to JSON Converter Online
Export complete SQLite tables or read-only query results to JSON in your browser, preserving NULL, column order and exact large integers. No account or installation required. Your original file stays unchanged.
How to convert
- Open an unencrypted .db, .sqlite or .sqlite3 file in the workspace.
- Select a table to browse it, or write a query. Filters and sorting apply across the database.
- Choose Export data, select JSON, and save the complete export.
What the download contains
Choose a table or write one SELECT query, then use Export data → JSON. The output has columns and rows arrays so duplicate column names are preserved. Large integers are decimal strings, NULL stays null, and BLOBs are objects with a $blob hex field. Successful exports have truncated: false.
SELECT id, name, price FROM products ORDER BY id;Complete export, bounded preview
The grid displays a bounded preview. CSV, JSON, Excel and PDF export runs one read-only SELECT again against the current database; it respects any LIMIT in your query. It does not rerun writes or export cached results. To export a whole table, select Current table with applied filters and sorting. Export one table per download.
File size and browser support
Rows are processed in chunks with progress and cancellation. Browsers with direct file saving write to disk; other browsers use a download limited to 64 MiB. Exceeding that limit fails explicitly instead of downloading a partial result. Large individual values and query execution limits still apply. Saved SQLite imports use browser storage; temporary database imports are limited to 100 MiB.
Keep a database backup
Use Export database for a complete SQLite snapshot, including full BLOBs. CSV and JSON are data formats, not schema-preserving backups. SQL dumps contain transaction commands that the workspace deliberately rejects; restore them in an external SQLite client.
Read the export guide · SQLite viewer · Convert CSV to SQLite