How to Open SQLite Files on Windows 10 and 11

Windows doesn’t come with a SQLite viewer. So when you double-click a .db or .sqlite file, you get the “How do you want to open this file?” box. None of the suggested apps help. Notepad shows random symbols. Excel says the format isn’t supported.

This guide shows three reliable ways to open a SQLite file on Windows 10 and Windows 11. One needs no install at all. The other two are free programs. We’ll also cover setting a default app, finding hidden app databases, and fixing common errors.

Method 1: Open it in your browser (no install)

This is the fastest option and works on any Windows PC, including work laptops where you can’t install software.

1. Open Chrome, Edge or Firefox.
2. Go to our free SQLite viewer.
3. Click Choose file.
4. In the file dialog, browse to your database. If you can’t see it, change the file type filter at the bottom right to All files.
5. Select the file and click Open.

Your tables appear in the sidebar with row counts. Click a table to see its rows, sort by any column, or search across all columns. The Run SQL tab lets you run queries, and you can export any table to CSV for Excel.

Your file is read inside the browser. It isn’t uploaded anywhere. That’s important if the database holds personal information.

Drag and drop

You can also drag the file straight from File Explorer onto the viewer’s drop zone. It’s quicker than using the file dialog.

Method 2: Install DB Browser for SQLite

If you’ll be working with SQLite files often, a desktop app is worth installing. DB Browser for SQLite is free, open source and popular.

1. Go to the official site, sqlitebrowser.org, and open the Download page.
2. Pick the Windows installer (64-bit for almost every modern PC).
3. Run the installer and follow the prompts.
4. Open DB Browser for SQLite from the Start menu.
5. Click Open Database and pick your file.
6. Go to the Browse Data tab and choose a table.

There’s also a portable version that runs without installing, handy on shared computers.

DB4S is excellent for editing data directly in cells and for designing tables. For a comparison with the browser approach, read DB Browser for SQLite online.

Method 3: Use the sqlite3 command-line tool

Developers often prefer the official command-line shell. It isn’t included with Windows, but setup takes a couple of minutes.

Download and set up sqlite3

1. Go to sqlite.org and open the Download page.
2. Under “Precompiled Binaries for Windows,” download the sqlite-tools zip.
3. Create a folder, for example C:\sqlite, and extract the zip there.
4. You should now have sqlite3.exe in that folder.

Open a database

Open Command Prompt or PowerShell and run:

cd C:\sqlite
sqlite3.exe "C:\Users\YourName\Desktop\mydata.db"

Then try these commands:

.tables
.headers on
.mode column
SELECT * FROM customers LIMIT 10;
.quit

Optional: add sqlite3 to your PATH

To run sqlite3 from any folder:

1. Press the Windows key and type environment variables.
2. Click Edit the system environment variables, then Environment Variables.
3. Under your user variables, select Path and click Edit.
4. Click New and add C:\sqlite.
5. Click OK, then open a new terminal window.

Now you can type sqlite3 mydata.db from anywhere.

Which method should you use?

Set a default app for .db files

If you install DB4S and want .db files to open with it on double-click:

1. Right-click a .db file in File Explorer.
2. Choose Open with, then Choose another app.
3. Pick DB Browser for SQLite. If it isn’t listed, click Choose an app on your PC and browse to its install folder.
4. Tick Always use this app to open .db files.
5. Click OK.

Repeat for .sqlite and .sqlite3 if you use those extensions too.

Be careful with Thumbs.db files. They’re Windows thumbnail caches, not SQLite databases. You don’t need to open them.

Where to find SQLite files on Windows

Many Windows apps keep SQLite databases in hidden folders. The most common locations are:

• C:\Users\YourName\AppData\Local
• C:\Users\YourName\AppData\Roaming

AppData is hidden by default. To get there quickly, press the Windows key and R, type %LOCALAPPDATA% or %APPDATA%, and press Enter.

For example, Chrome’s history database is at:

%LOCALAPPDATA%\Google\Chrome\User Data\Default\History

It has no file extension, but it’s a SQLite database. Our Chrome history guide explains how to read it.

Always copy first

Apps lock their databases while running. Close the app, then copy the file to your Desktop before opening it. This avoids “database is locked” errors and protects the original. If you still see a lock error, read our guide to the SQLite database is locked error.

Check whether a file is really SQLite on Windows

Before you spend time on a file, confirm it’s a SQLite database. Windows has a built-in way to peek at the first bytes.

Open PowerShell in the folder that holds the file and run:

Format-Hex .\mydata.db | Select-Object -First 1

This shows the first 16 bytes. On the right side, in the text column, you should see “SQLite format 3.” If you see something else, the file isn’t a plain SQLite database.

You can also open the file in Notepad and look at the very first characters. The rest will look like gibberish, and that’s fine. Close Notepad without saving, so you don’t damage the file.

Even easier: drop the file into our viewer. It checks the header for you and tells you straight away if the file isn’t SQLite.

Opening SQLite files from Android or iPhone backups on Windows

Many people find SQLite files after copying data off a phone. A few tips when you’re on Windows:

• Android databases often come as .db files, for example mmssms.db for text messages. Our Android guide explains where they live.
• iPhone backups made with iTunes or the Apple Devices app store files under long hashed names with no extension. Many of them are SQLite databases.
• WhatsApp backups end in .crypt14 or .crypt15 and are encrypted. A normal viewer can’t read them. See our WhatsApp msgstore.db guide.

Show file extensions in Windows

Windows hides file extensions by default, which makes it hard to tell a .db from a .sqlite file. To show them:

• Windows 11: In File Explorer, click View, then Show, then File name extensions.
• Windows 10: In File Explorer, open the View tab and tick File name extensions.

Open SQLite data in Excel

Excel can’t open SQLite files directly. The easy way around it:

1. Open the database in our online viewer.
2. Click the table you need.
3. Click Export CSV.
4. Open the CSV in Excel.

For more options, including keeping special characters intact, see how to convert SQLite to Excel.

Common errors on Windows

“File is not a database”

The file might be encrypted, zipped or not SQLite. Check the first bytes for “SQLite format 3.” Our file is not a database guide has the full list of causes.

“Unable to open database file”

This usually means a wrong path. Wrap paths with spaces in quotes. Also check you have permission to read the folder.

Data looks out of date

Look for files ending in -wal and -shm next to your database. Close the app that owns the database, then copy all the files together.

Garbled characters in Excel

This happens when Excel guesses the wrong text encoding. Our viewer adds a marker to CSV exports so Excel reads accents and non-Latin characters correctly.

Want the technical detail? See the official SQLite download page.

Frequently asked questions

Does Windows 11 have a built-in SQLite viewer?

No. You need a separate tool. The quickest is a browser-based viewer.

Is DB Browser for SQLite safe?

Yes, when downloaded from the official site. It’s open source and widely used.

Can I open SQLite files in Microsoft Access?

Only with extra ODBC drivers and setup. For most people, a SQLite viewer is much simpler.

Can I open a SQLite file on Windows without admin rights?

Yes. Use the browser viewer, or the portable versions of DB4S or the sqlite3 tools.

Why does Windows say it can’t open this type of file?

Because no installed app is linked to the .db or .sqlite extension. It doesn’t mean the file is broken. Use one of the methods above and it will open normally.

Summary

To open a SQLite file on Windows 10 or 11, use our free online SQLite viewer for a quick, private look with no install. For regular work, install DB Browser for SQLite. For scripts, download the sqlite3 tools. Whatever you choose, copy the file first and show file extensions in File Explorer so you know exactly what you’re opening. For a broader overview, read how to open a SQLite file.