The SQLite to CSV Exporter turns any table inside a SQLite database into a clean, spreadsheet-ready CSV file without a command line or desktop app. It reads the database file directly in the browser, lets you pick a table, and produces a standards-compliant CSV download. This is the fastest way to move data out of a .db file and into Excel, Google Sheets, pandas or a BI tool.
How it works
SQLite stores each table as a b-tree of pages inside one file. The exporter first reads the database header to find the page size, then reads the sqlite_master table (rooted on page 1) to discover every table, its root page and its CREATE TABLE statement.
When you choose a table, the tool walks that table’s b-tree from its root page: interior pages are followed down to their children, and leaf pages yield the rows. Each row is a record made of varint-encoded serial types plus column bodies, which decode to NULL, integers, floats, text or blobs.
Column headers come from parsing the table’s CREATE TABLE statement, splitting the column list at top-level commas and skipping table-level constraints like PRIMARY KEY and FOREIGN KEY. Every value is then escaped per RFC 4180 and joined with CRLF line endings so the file imports cleanly everywhere.
Tips and notes
- The downloaded file is named after the table, for example
users.csv. - An
INTEGER PRIMARY KEYcolumn that SQLite stores as NULL is restored to its actual rowid in the export. - If a table is empty, you still get a valid CSV containing just the header row.
Everything runs locally in your browser — no upload, no account.