---
title: ".sqlite file — what it is and how to open it"
description: "A .sqlite file is a SQLite Database. A complete relational database in a single file — the most deployed database in the world. How to open one on Windows, macOS and Linux, and what to convert it to."
url: https://atoneplace.net/file/sqlite/
site: "At One Place"
---

# .sqlite files

**.sqlite file: SQLite Database**

A complete relational database in a single file — the most deployed database in the world.

## What opens a .sqlite file

- **Windows:** DB Browser for SQLite, DBeaver, sqlite3 (command line)
- **macOS:** DB Browser for SQLite, DBeaver, sqlite3 (built in)
- **Linux:** DB Browser for SQLite, DBeaver, sqlite3

## What a .sqlite file is

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. DB Browser for SQLite is the standard free GUI on all three platforms.

## Converting it

A .sqlite file is commonly converted to .sql, .csv, .db or .json. It is a binary format, so a text editor will show unreadable characters rather than its contents.

## Details

- **Extension:** .sqlite
- **Full name:** SQLite Database
- **Category:** Data
- **MIME type:** application/vnd.sqlite3
- **Created by:** D. Richard Hipp / SQLite Consortium
- **Format:** Binary

## 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](https://atoneplace.net/file/csv/)
- [.json — JavaScript Object Notation](https://atoneplace.net/file/json/)
- [.xml — Extensible Markup Language](https://atoneplace.net/file/xml/)
- [.yaml — YAML Data File](https://atoneplace.net/file/yaml/)
- [.log — Log File](https://atoneplace.net/file/log/)
- [.torrent — BitTorrent Metainfo File](https://atoneplace.net/file/torrent/)
- [.dat — Generic Data File](https://atoneplace.net/file/dat/)
- [.vcf — vCard Contact File](https://atoneplace.net/file/vcf/)
- [.sql — SQL Script](https://atoneplace.net/file/sql/)
- [.ics — iCalendar Event](https://atoneplace.net/file/ics/)
- [.db — Generic Database File](https://atoneplace.net/file/db/)
- [.bin — Binary File](https://atoneplace.net/file/bin/)

## Sources

- Media Types Registry — IANA (https://www.iana.org/assignments/media-types/)
- Official vendor product documentation — At One Place (/about/)