100% Client-Side Privacy
Adawaty Pro • adawaty-pro.com
48+ Offline Client-Side Converters & Technical Guides
Home / Legacy Data & Business / SQLite (.db / .sqlite) to CSV / XLSX / SQL
Read Technical Guides →

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.

100% Client-Side JS

Active Converter

Smart Auto-Fix:
1. Source File(s) or Paste Input: No file selected
2. Live Output (Editable):
WebAssembly SQLite 3 Engine (sql.js + SheetJS)

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 3 header 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 BLOB columns 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–15Magic StringLiteral ASCII SQLite format 3\0 identifying SQLite 3.
16–17Page SizeBig-endian power of two between 512 and 65,536 bytes (default 4,096).
28–31Database SizeTotal number of B-tree pages in the file.
56–59Text Encoding1 = 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

How can a web browser open a binary SQLite (.db / .sqlite / .sqlite3) database without installing DB Browser?

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.

What mobile apps and desktop programs store user data in SQLite .db files?

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).

What if my SQLite database uses WAL mode (.db-wal and .db-shm companion files)?

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.

Can I filter rows or drop internal sqlite_sequence columns before exporting to Excel?

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.