csvsql 0.7.7

A browser-based CSV database with SQL query support

CSVSQL

A browser-based CSV database application. Open CSV, Excel, and compressed files as database tables, run SQL queries, edit data inline, and save — all in a multi-window interface with no server or build step required.

Features

• Multiple file formats — CSV, TSV, PSV, Excel (.xlsx/.xls), Gzip (.csv.gz), and ZIP archives
• SQL queries — Full SQLite syntax from the built-in console, including joins, subqueries, aggregates, UNION, CASE, and REGEXP
• Inline editing — Click any cell to edit. Tab/Enter to navigate, Escape to cancel
• Sort and filter — Click column headers to sort (multi-column with Shift+click). Filter with SQL WHERE expressions including REGEXP
• Multi-window workspace — Draggable, resizable subwindows. Tile, Grid, or Cascade layouts
• Row and column management — Add/delete rows, insert at position (right-click), add/rename/reorder columns
• SELECT INTO — Create new tables from query results (SELECT ... INTO tablename ...)
• CREATE TABLE — New tables created via SQL auto-open as editable windows
• Drag and drop — Drop files directly onto the window to open them
• Open from URL — Load data files from any HTTP/HTTPS URL
• Save — Write directly back to the original file (Chrome/Edge) or download. Save As supports CSV, TSV, PSV, Excel, Gzip, and ZIP formats
• Virtual scrolling — Handles large datasets efficiently

Installation

Option 1: pip (recommended)

pip install csvsql
csvsql

This starts a local server and opens CSVSQL in your browser. If csvsql conflicts with another command on your system, use csvsqlw instead — it's an identical alias.

csvsql --port 9000          # custom port (default: 8000)
csvsql --no-browser          # don't auto-open browser
csvsql --host 0.0.0.0       # bind to all interfaces

Option 2: No install — open directly

No dependencies needed. Clone the repo and open index.html in your browser:

git clone https://github.com/markuskimius/csvsql.git
open csvsql/index.html

Or serve with any static file server:

python3 -m http.server 8000
# open http://localhost:8000

Usage

Opening Files

Use File > Open (Ctrl+O / Cmd+O), File > Open URL, or drag and drop files onto the window.

Format	Extensions	Notes
CSV	.csv, .txt	Delimiter auto-detected (comma, tab, pipe, etc.)
TSV	.tsv	Tab-delimited
PSV	.psv	Pipe-delimited
Excel	.xlsx, .xls	Each non-empty worksheet opens as a separate table
Gzip	.csv.gz, etc.	Decompressed in browser; inner file opened by type
ZIP	.zip	All recognized data files inside the archive are opened

Editing

• Edit cells — Click any cell to edit
• Navigate — Tab/Shift+Tab between cells, Enter to move down, Escape to cancel
• Add rows — Click + Row in the toolbar, or right-click a row number to insert above
• Delete rows — Right-click a row number and choose Delete Row
• Add columns — Click + Col in the toolbar
• Rename columns — Ctrl/Cmd+click a column header
• Reorder columns — Ctrl/Cmd+drag a column header to a new position
• Rename tables — Ctrl/Cmd+click the window title

Sorting and Filtering

• Sort — Click a column header to cycle: ascending → descending → unsorted
• Multi-column sort — Shift+click additional headers. Numbers next to arrows show sort priority
• Filter — Type a SQL WHERE expression in the filter bar (without the WHERE keyword):

  age > 30 AND name LIKE '%Smith%'
  name REGEXP 'smith|jones'
  

SQL Console

The SQL Console at the bottom runs queries against all open tables using SQLite syntax. Press Ctrl+Enter (Cmd+Enter on Mac) to execute.

-- Query a loaded table by its filename (minus extension)
SELECT * FROM sample WHERE name LIKE 'A%'

-- Aggregate queries
SELECT department, AVG(salary) as avg_salary FROM employees GROUP BY department

-- Join across tables
SELECT a.name, b.value FROM table1 a JOIN table2 b ON a.id = b.id

-- REGEXP (case-insensitive)
SELECT * FROM employees WHERE name REGEXP '^(John|Jane)'

-- Create a new table from query results
SELECT name, salary INTO high_earners FROM employees WHERE salary > 100000

-- Create an empty table
CREATE TABLE projects (id, name, status)

Table names are derived from the filename (e.g., employees.csv → employees). All column values are stored as TEXT.

INSERT, UPDATE, DELETE, ALTER TABLE, and DROP TABLE all work. Changes to existing tables are reflected in their windows immediately.

Saving Files

• Save (Ctrl+S / Cmd+S) — Writes directly back to the original file on Chrome/Edge (via File System Access API). On Firefox, triggers a download
• Save As — Prompts for a new filename. Supports CSV, TSV, PSV, Excel (.xlsx), Gzip, and ZIP formats
• ZIP archives — Saving any table from a ZIP re-packs all tables from that archive into the same ZIP
• Excel workbooks — Saving any sheet re-packs all sheets into the same workbook

Window Management

• Move — Drag the title bar
• Resize — Drag any edge or corner
• Maximize/Restore — Double-click the title bar, or click the maximize button
• Minimize — Click the minimize button. Restore from the Windows menu
• Close — Click the close button. Ctrl/Cmd+click closes all windows
• Layout — Use the View menu to Tile Horizontally, Tile Vertically, Grid, or Cascade

Keyboard Shortcuts

Shortcut	Action
Ctrl+O / Cmd+O	Open file
Ctrl+S / Cmd+S	Save table
Ctrl+N / Cmd+N	New table
Ctrl+W / Cmd+W	Close window
Ctrl+Enter / Cmd+Enter	Execute SQL query
Tab / Shift+Tab	Navigate between cells
Enter	Move to next row
Escape	Cancel cell edit

License

MIT — see About dialog in the app for full text.