SQLite Table Editor - Edit Database Tables Visually

Edit SQLite tables with a spreadsheet-like interface. Add, update, delete rows. Download modified database. Browser-based.

Database

Drop SQLite file here or click to browse

Load a database and select a table

Yes. Click 'Add Row' to insert a new row. Fill in values and they're added to the in-memory database.

Click any cell to make it editable. Press Enter or click outside to save the change.

Yes. Select rows using the checkbox column, then click 'Delete Selected' to remove them.

Changes are made to an in-memory copy. Download the modified database to save changes permanently.

No. All editing happens locally using SQL.js. Your data never leaves your browser.

Individual edits can't be undone, but you can reload the original file to start over.

SQLite uses dynamic typing. Values are stored as entered. The editor shows declared types for reference.

Column structure changes aren't supported. Use SQL ALTER TABLE commands in the Query Runner for that.

The editor loads rows in pages. You can navigate through large tables without loading everything.

Click column headers to sort. Use the query box for filtered views.