Data file
What is a .sqlite file?
A .sqlite file is a SQLite Database File Format (version 3). This is a data file — structured information used by a program rather than read directly. Confusingly, this extension has been used by 2 different formats over the years — they're all listed below.
This extension has been used by more than one format
2 different formats have claimed .sqlite over the years, so two files with the same extension aren't necessarily the same kind of thing.
How to open a .sqlite file
- Start with the program that produced it; that's almost always the right tool.
- Open it in a text editor to see whether it's readable text or binary.
- For database formats, DB Browser for SQLite or LibreOffice Base can often import it.
The registry records this extension against SQLite Database File Format, SQLite Database File Format, so software from that family is the most likely match.
How to convert a .sqlite file
- If you can view the data, exporting to .csv is usually the most portable option.
MIME type
When a .sqlite file travels over the web, servers label it with this MIME type:
application/x-sqlite3The technical record
For archivists, developers and the merely curious: these are the PRONOM registry entries for .sqlite.
| Format name | Version | MIME type | PUID |
|---|---|---|---|
| SQLite Database File Format | 3 | application/x-sqlite3 | fmt/729 |
| SQLite Database File Format | 2 | — | fmt/1135 |