Ctrl + Enter
Result
How to open a .SQLITE3 file online
Three steps, a few seconds.
01
Open your .SQLITE3 file
Drop the file on the box or click to choose it. It opens.
02
Browse the tables
Pick a table to page through its rows, sort any column or filter by text. The Structure tab shows its columns, keys and indexes.
03
Run a query
Write any SELECT or JOIN and export the result as CSV or JSON. Changes live in memory until you download a copy.
What is a .SQLITE3 file?
The most widely deployed database engine in the world.
A .sqlite3 file is a complete relational database stored in one binary file by SQLite, the same format as .sqlite and .db. It holds structured tables of data, not a readable document. Open it with the free DB Browser for SQLite (Windows/macOS/Linux) to browse and query tables, or use the sqlite3 command line. To get data into Excel, export a table to CSV first.
Programs that open .SQLITE3 files
Windows
DB Browser for SQLite, DBeaver, SQLite (sqlite3 CLI)
macOS
DB Browser for SQLite, SQLite (sqlite3 CLI), TablePlus
Linux
DB Browser for SQLite, SQLite (sqlite3 CLI)
Web
SQLite Viewer (sqliteviewer.app)
.SQLITE3 format details
| Full name | SQLite 3 Database |
|---|---|
| Developer | D. Richard Hipp / SQLite Development Team (public domain) |
| First released | 2004 (SQLite 3 file format; SQLite itself since 2000) |
| Category | Data & Other |
| MIME type | application/vnd.sqlite3 |
| Signature | 53 51 4C 69 74 65 20 66 6F 72 6D 61 74 20 33 00 ("SQLite format 3\000" - 16-byte header string) |
Related viewers
Other free tools to open and preview your files.
Frequently asked questions
Is my .SQLITE3 file uploaded anywhere?
No. The SQLite engine (compiled to WebAssembly) is downloaded once to your browser and opens your .SQLITE3 file locally. Your data never reaches FileExtension.org.
Can I change data with UPDATE or DELETE?
Yes - any SQL works, but changes only live in memory. Use Download database to save a modified copy; your original file is never touched.
Why does my .db file say it isn't SQLite?
Many programs use the .db extension for their own formats (for example Windows Thumbs.db or Paradox tables). The viewer checks the file's signature and tells you what it really is.
Can it open encrypted databases?
Not yet. Encrypted databases (SQLCipher, used by some messengers) look like random data without the key, so they can't be read.
What about the -wal and -shm files next to my database?
They hold recent changes that haven't been merged into the main file yet. Open the main database file; very recent changes stored only in the -wal file won't be visible.
Was this tool helpful?
Your rating helps us decide which tools to improve next.
Be the first to rate this tool.
Found a problem?