.sqlite files

Common questions

How do I open a .sqlite file?

On Windows use DB Browser for SQLite; on macOS use DB Browser for SQLite; on Linux use DB Browser for SQLite. A complete relational database in a single file — the most deployed database in the world.

What is a .sqlite file?

SQLite Database. SQLite is a public-domain embedded database engine, and a .sqlite file is the whole database: tables, indexes and data in one portable file. Phones, browsers and desktop apps use it constantly, so most of the databases on your devices are SQLite files under other names.

Can I convert a .sqlite file?

Yes. It is usually converted to .sql, .csv, .db or .json, either by exporting from one of the programs listed above or with a format converter.

Related pages

• .csv — Comma-Separated Values A spreadsheet as plain text, one row per line — the universal data exchange form
• .json — JavaScript Object Notation The standard text format for structured data on the web and in config files.
• .xml — Extensible Markup Language A tag-based text format for structured data, still everywhere in enterprise syst
• .yaml — YAML Data File An indentation-based configuration format, readable but unforgiving about whites
• .log — Log File A plain-text record of what a program did, newest events usually at the bottom.
• .torrent — BitTorrent Metainfo File A few kilobytes of metadata describing what to download and from whom — not the
• .dat — Generic Data File A meaningless extension — .dat says only that some program stored data here.
• .vcf — vCard Contact File One or more contacts as plain text — the standard way to move an address book.
• .sql — SQL Script A text file of database commands — often a full database dump.
• .ics — iCalendar Event A calendar invitation or event feed in a plain-text standard format.
• .db — Generic Database File An extension many programs use for their data — it does not identify one format.
• .bin — Binary File Raw binary data — most often a disc image paired with a .cue, or device firmware