Export a SQLite table to CSV — in your browser
Sometimes the database isn't the destination — a spreadsheet is. You have a .sqlite or .db file and you need one table as a clean CSV to open in Excel, hand to a colleague, or feed into another tool. editsqlite opens the database in the tab, shows every table, and exports the one you want as correctly-quoted CSV. The database is read once and never modified, and nothing is uploaded.
How to export SQLite to CSV
- Open the database. Click Open a database and choose your .sqlite / .db file, or drop it on the page.
- Pick the table. Switch to it using the tabs or the schema panel on the left.
- Export CSV. Click ⬇ CSV (this table). The .csv downloads, quoted so it opens cleanly anywhere.
Export a query, not just a whole table
If you only want part of the data — certain columns, rows matching a condition, or the result of a join or a GROUP BY — run it in the SQL console first. Any result set has its own ⬇ CSV button, so you can export exactly the shape you need instead of the entire table. It's the difference between "give me this database as a spreadsheet" and "give me this answer as a spreadsheet."
Good to know
- Fields with commas, quotes or newlines are quoted and escaped;
NULLexports as an empty field. - Binary blob columns export as a
[BLOB]placeholder — CSV is a text format and can't carry raw bytes. - Your original database file is never written to. Editing here always rebuilds a fresh file rather than touching the source.
- Need to go the other way? See CSV → SQLite.