How to Open a SQLite Database File
Browse the tables inside a .db, .sqlite, or .sqlite3 file in a desktop app — no SQL, command line, or database tools required. 100% offline on Mac & Windows.
Quick Answer
- ✓SQLite files have no built-in viewer — double-clicking a .db or .sqlite file does nothing on Mac or Windows because it's a database, not a document, and needs a database tool to read it.
- ✓Open it like a spreadsheet in FileHop — drag the file in, pick a table, and its rows render as a searchable, sortable grid. No SQL or command line needed.
- ✓Everything stays on your device, read-only. FileHop reads the database locally and never changes it, so you can browse safely and nothing is uploaded.
What is a SQLite file, and why won't it open?
SQLite (.db, .sqlite, .sqlite3, .db3) is a self-contained database packed into a single file. It's used almost everywhere — phone apps store their data in it, browsers keep your history and bookmarks in it, desktop apps use it for local storage, and it's a common format for data exports. One file can hold many tables, each with its own columns and rows.
Because a SQLite file is a database rather than a document, no operating system ships a viewer for it. Double-clicking a .db or .sqlite file usually does nothing, opens a code editor full of unreadable bytes, or asks you to pick an app. To read the data you'd normally install a database browser or type SQL at the command line — unless you open it in a tool that understands the format.
How to open a SQLite file in FileHop
FileHop is a free desktop file browser with a built-in database viewer. It opens SQLite files in read-only mode, so the tables appear as clean, browsable grids in seconds.
Download and open FileHop
It's free for Mac and Windows and opens like Finder or File Explorer — no setup or accounts.
Open the folder with your .db or .sqlite file
Click the file to open it. FileHop recognizes .db, .sqlite, .sqlite3, and .db3 and opens the database in a built-in browser — read-only, so there's no risk of changing your data.
Pick a table to view
A table picker lists every table in the database with its row and column counts. Choose one and its rows load into the grid. A schema sidebar shows each table's columns with their data type (color-coded), a marker on primary-key columns, and which columns allow nulls.
Search, sort, and filter
The table loads into the same fast, paginated grid as other data files. Press Cmd/Ctrl+F for global search, open a column's menu to filter, click a header to sort, and pin important columns to the left so they stay visible as you scroll.
Everything runs on your computer — your data is never uploaded, and the database opens read-only, so it's safe to browse confidential or proprietary databases without changing them.
Other ways to open a SQLite file
FileHop isn't the only option. Here's how the common alternatives compare, and when they make sense.
DB Browser for SQLite
DB Browser for SQLite is a solid, free desktop tool that does far more than view — it can also edit tables and run SQL. The trade-offs are that it's a separate install and is more technical than a file browser when all you want is to read the data.
The sqlite3 command line
If you're comfortable in a terminal, the sqlite3 shell lets you run .tables and SELECT queries directly. But it means writing SQL and reading results as plain text, which is overkill just to glance at what's inside a file.
Export a table to CSV first
You can export a table to CSV and open that in a spreadsheet app, but you have to do it per table, you lose the schema and the links between tables, and it's an extra step for a quick look.
SQLite viewers compared
How opening a SQLite database in FileHop compares with a dedicated DB browser or the command line.
| What matters | DB Browser / CLI | FileHop |
|---|---|---|
| No SQL or setup required | Usually | Yes |
| Safe read-only browsing | Can edit by accident | Yes — read-only |
| Search, sort, filter like a spreadsheet | More technical | Yes — built in |
| Data stays on your device | Separate install | Yes — 100% local |
Frequently Asked Questions
What is a SQLite database file used for?
SQLite is a single-file database used almost everywhere — phone apps, web browsers (for history and bookmarks), desktop applications, and data exports all rely on it. One .db or .sqlite file can hold many tables, so it's a compact way to ship structured data without a database server.
Can I open a SQLite file without SQL or the command line?
Yes. FileHop opens a .db or .sqlite file like a spreadsheet — drag it in, pick a table, and its rows render as a searchable grid. You don't need SQL, the command line, or any database tools.
Which SQLite file extensions does FileHop open?
FileHop opens .db, .sqlite, .sqlite3, and .db3 files in its built-in database browser. Whichever extension an app used, the database opens the same way.
Can I edit a SQLite database in FileHop?
No. FileHop opens the database read-only — it's a browser for inspecting data, not a SQL editor. It won't insert, update, or delete rows or run arbitrary queries, so you can browse safely without any risk of changing the database. For editing, use a tool like DB Browser for SQLite.
How do I see the structure of the tables?
A table picker lists every table with its row and column counts, and a schema sidebar shows each table's columns with their data type (color-coded), a key marker on primary-key columns, and which columns allow nulls — so you can read the structure without writing any SQL.
Can I search and filter the data?
Yes. Once you pick a table it loads into the same grid as other data files, with a global search box (Cmd/Ctrl+F) across every column, per-column filters, click-to-sort on any column, and column pinning to keep key columns in view.
How are BLOB columns shown?
BLOB columns display as text when the contents are decodable. When they aren't, FileHop shows a "[blob: N bytes]" placeholder so you can still see that the cell holds binary data and how large it is.
What other data files can FileHop open?
The same viewer opens CSV, Excel (.xlsx and .xls), OpenDocument (.ods), JSON, and Parquet (.parquet) — so you can inspect almost any data file without special software.
Is my data uploaded anywhere?
No. FileHop reads the SQLite file directly on your computer and never uploads it. That makes it safe for confidential, proprietary, or regulated databases that can't leave your machine.
Does it work on both Mac and Windows?
Yes. FileHop is free and runs on both macOS and Windows, opening SQLite database files the same way on each.
Open any SQLite file in seconds
Free desktop app for Mac and Windows. Browse the tables, search, sort, and filter — no SQL, no uploads.
Download FileHop Free