Export a SQLite database to Excel
SQLite is the most widely used database in the world: it lives inside phone apps, browsers and lots of programs, and it's the one used in many database courses. With this tool you can see its contents in Excel without installing anything.
Step by step
- In Pro Arsenal, choose SQLite ➔ Excel.
- Pick the database file (
.db,.sqliteor.sqlite3). - Press Convert. The first time you'll see "Loading SQL engine…" for a few seconds.
Database_Export.xlsxdownloads, with one sheet per table.
What gets exported
- Every user-created table. SQLite's internal tables (those starting with
sqlite_) are skipped. - On each sheet, the first row holds the column names, followed by every record.
- Excel limits sheet names to 31 characters: longer table names are trimmed.
Views, indexes and relationships between tables aren't exported — only data. If you need a specific query (a JOIN, for example), first create a table with its result from your SQLite manager.
What it's useful for
- Coursework: quickly checking what data is in the database you were given or have built.
- App data: many notes, finance or fitness apps let you export a SQLite copy.
- Sharing: whoever receives the Excel file doesn't need to know SQL to review or filter the data.
Limits
Excel supports at most 1,048,576 rows per sheet. With very large databases (hundreds of megabytes) the browser may be slow or run out of memory, since the whole database is loaded on your device. Binary data (images stored in the database) won't display usefully in Excel.
Privacy
It uses sql.js, a version of SQLite compiled for the browser. The only thing downloaded from the internet is the engine (public code). Your database is opened in your computer's memory and never leaves it.