SQLite (.db / .sqlite) to CSV / XLSX / SQL
Open app/mobile SQLite databases in-browser and export tables to Excel/CSV/SQL — 100% private client-side processing.
Active Converter
SQLite (.db / .sqlite) to CSV / Excel / SQL: Extracting App Databases Offline
Technical Anatomy of the SQLite 3 Binary File Format
SQLite 3 is the world's most widely deployed embedded SQL database. Every valid .sqlite, .sqlite3, or .db file begins with an exact 16-byte magic header: 53 51 4C 69 74 65 20 66 6F 72 6D 61 74 20 33 00 ("SQLite format 3\0"), followed by a 100-byte database header declaring page size (typically 4,096 bytes), text encoding (UTF-8 / UTF-16), and B-tree root pointers.
Instead of brittle regex scraping, Adawaty Pro executes genuine SQLite compiled to WebAssembly (sql.js) directly inside your browser tab. It queries sqlite_master to discover every user table, executes SELECT * against each table in local RAM, and exports clean Excel (.XLSX) workbooks, UTF-8 BOM CSV files, or portable .SQL CREATE TABLE / INSERT scripts—with zero server uploads.
SQLite 3 Binary Header vs. Extracted SQL & Excel Table Output
# Input: Binary SQLite 3 Header (app_data.sqlite)
00000000: 53 51 4C 69 74 65 20 66 6F 72 6D 61 74 20 33 00 |SQLite format 3.|
00000010: 10 00 01 01 00 40 20 20 00 00 00 04 00 00 00 02 |.....@ ........|
# Extracted Excel / CSV Output (via sql.js WASM):
id,username,plan,created_at
1,"youssef_dev","pro","2026-10-12"
2,"salma_ops","team","2026-11-04"
Real-World Software & Hardware Ecosystem
Mobile developers, forensic analysts, and data journalists extract tables from .db / .sqlite files generated by Android Room / iOS CoreData, Django / Flask / Rails, Chrome / Edge / Firefox, Electron desktop apps, Home Assistant (home-assistant_v2.db), and Raspberry Pi IoT loggers.
Troubleshooting & Edge Cases
- SQLCipher Encrypted Databases: Apps like Signal or encrypted WhatsApp backups use SQLCipher (AES-256), which replaces the
SQLite format 3header with random ciphertext. Encrypted databases must be decrypted with their key before reading. - BLOB Binary Columns: Tables storing raw JPEG thumbnails or binary blobs inside
BLOBcolumns are safely truncated or hex-summarized so Excel cells do not overflow their 32,767-character limit. - Arabic & Unicode Columns: Keep UTF-8 BOM checked when exporting CSV so Arabic/multilingual app data displays cleanly in Excel.
SQLite 3 100-Byte Database Header Layout
| Byte Offset | Field | Technical Role |
|---|---|---|
| 0–15 | Magic String | Literal ASCII SQLite format 3\0 identifying SQLite 3. |
| 16–17 | Page Size | Big-endian power of two between 512 and 65,536 bytes (default 4,096). |
| 28–31 | Database Size | Total number of B-tree pages in the file. |
| 56–59 | Text Encoding | 1 = UTF-8, 2 = UTF-16le, 3 = UTF-16be. |
Handling WAL Checkpoints Before Exporting
If you pulled a database from a running Android app or Home Assistant server and noticed two companion files—app.db-wal and app.db-shm—run a quick WAL checkpoint before exporting so uncommitted writes merge cleanly into the main .db file:
# Merge Write-Ahead Log (.db-wal) into main SQLite file via CLI:
sqlite3 app.db "PRAGMA wal_checkpoint(TRUNCATE);"
# List all user tables & export directly from CLI:
sqlite3 -header -csv app.db "SELECT * FROM users;" > users.csv
Converting Unix Epoch & Apple CoreData Timestamps in Excel
Mobile app SQLite databases rarely store human-readable date strings. Android Room and Chrome history databases typically store Unix timestamps in seconds (e.g., 1763664000) or milliseconds, Chrome uses WebKit microseconds since January 1, 1601, and iOS CoreData/WhatsApp uses Mac Absolute Time (seconds since January 1, 2001). Once you export your SQLite tables to .XLSX via our WebAssembly sql.js engine, convert Unix seconds to an Excel date with =(A2/86400)+DATE(1970,1,1), or Apple CoreData seconds with =(A2/86400)+DATE(2001,1,1), then format the column as Date/Time.
For databases containing multiple relational tables (such as orders, customers, and line_items), export to .SQL as well if you need the complete CREATE TABLE schema alongside your Excel spreadsheets for migrating into PostgreSQL, MySQL, or Supabase.
Before importing extracted CSV sheets into BI tools like Power BI or Looker Studio, verify that nullable integer foreign keys did not convert to floating-point decimals (42.0) and confirm primary-key uniqueness directly in our Interactive Table view.
Frequently Asked Questions
Adawaty Pro loads sql.js—the official C SQLite engine compiled to WebAssembly (WASM)—directly inside your browser. It opens your binary .db buffer in local RAM, runs real SQL queries (SELECT name FROM sqlite_master WHERE type='table'), and exports every table to CSV, Excel (.XLSX), or .SQL dump.
Almost every modern app: Android/iOS WhatsApp & SMS backups, Chrome/Firefox browser history (History / places.sqlite), Apple Photos, Signal, WordPress SQLite plugins, Flutter/React Native apps, and Python/Django development databases (db.sqlite3).
In Write-Ahead Logging (WAL) mode, the most recent uncommitted transactions sit in the .db-wal file until checkpointed. Before converting, ensure the source app closed cleanly or checkpointed WAL into the main .db file so recent rows are included.
Yes. Switch the output preview to Table mode, search or filter rows live, click × on any column header you do not need, and click Export Excel to download a spotless .XLSX workbook.