Databases

Turn SQLite into Excel and back again.

Open SQLite database files without installing database software: see their structure, run read-only SQL queries, and move tables to Excel and back.

Tools

SQLite to Excel

One sheet per table, with an optional summary.

Excel to SQLite

Turn a workbook into a queryable database.

SQLite Schema Viewer

See every table, column, key, index, view and trigger in a database.

Run SQL on SQLite

Query a SQLite database with SQL and get the result as a table.

Which tool do I need?

To find out what a .db file contains, start with SQLite Schema Viewer. To open the data in Excel, use SQLite to Excel; to answer a specific question, Run SQL on SQLite. To build a database from a workbook, use Excel to SQLite.