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, build step, or internet connection required. Fully self-contained with all dependencies bundled locally.

Private by design — your data never leaves your device. Files are parsed, edited, and queried entirely in the browser; there is no backend, telemetry, or analytics. The only network activity is user-initiated: Open URL downloads the file you ask for.

Try the live version

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. Query results are queryable tables too. Up/Down arrows at the start/end of the input recall query history (last 100 queries, persisted across reloads); the History button opens a browsable panel to re-run, edit, or clear past queries
SQL syntax highlighting — Keywords, strings, numbers, comments, and identifiers are color-coded in the SQL console and filter inputs
SQL autocompletion — Context-aware suggestions for table names, column names, and keywords in the SQL console and filter inputs. Tab/Enter accepts, Ctrl+Space opens manually; names needing quoting are inserted bracket-quoted
Inline editing — Double-click a cell to edit it. Or click a cell to select it and press i, F2, or Ctrl/Cmd+U; Ctrl/Cmd+click also edits directly. Tab/Shift+Tab/Enter navigate between cells while staying in edit mode. Enter returns to the column where editing started. Up/Down arrow commits and exits edit mode. Long text scrolls within the cell to keep the cursor visible. Escape to revert
Sort and filter — Click the sort badge (triangle icon) in column headers to sort (multi-column with Shift+click on sort badges). Filter with SQL WHERE expressions including REGEXP. Excel-style column autofilter dropdowns with searchable checkboxes for point-and-click filtering. Status chips in the status bar show active features. Click Sorted or Filtered to clear; click Linked or Formatted to suspend/resume
Multi-window workspace — Draggable, resizable subwindows with edge snapping. Tile, Grid, or Cascade layouts. Tabbing and docking support for IDE-style split layouts
Row and column management — Right-click (or long-press) a row number to insert below or delete. Right-click (or long-press) a column header to rename, sort, insert a column to the right, or delete. Right-click the # corner cell to insert a row or column when the table is empty, or to rename the table. Ctrl/Cmd+click a column header to rename inline (duplicate names are rejected with a red border). Full undo/redo for all structural operations. Columns open auto-fitted to their content; resize any column by dragging column borders — including the row-number column (double-click to auto-fit based on all rows, not just visible ones). When multiple columns are selected, double-click auto-fits all selected columns and drag-resize sets all selected columns to the same width
Column Manager — Open via Edit > Manage Columns (Ctrl/Cmd+Shift+M) or right-click a column header. Searchable vertical list of all columns with multi-select (Shift+click, Ctrl/Cmd+click). Drag to reorder within the list or drop onto table headers. Alt+Up/Down to move selected columns. Double-click a column to scroll the table to it. All reorders batch into a single undo entry when the manager closes. Esc closes from anywhere
Cell selection — Click a cell to highlight its row, column, and row number. Click a column header to select the entire column. Move the selection with arrow keys or vim-style h/j/k/l, extend to a rectangle with Shift+arrow (or Shift+H/J/K/L), Shift+click, or click-and-drag. Click a row number to select the entire row (drag or Shift+click for multiple rows). Ctrl+A selects all cells; Esc deselects all. Clicking the # corner cell toggles between select all and select none. With no cell selected, any arrow key focuses the cell in the middle of the view. Ctrl+←/→ moves the header-selected column
Clipboard — Cut (Ctrl+X), Copy (Ctrl+C), and Paste (Ctrl+V) work on selected cells. A toast notification confirms each operation with the number of cells affected. Data is copied as tab-separated values. When a plugin display transform is active, copy uses formatted values; when formatting is disabled, raw values are copied. Copying with Select All or row selection includes the header row. Copy and cut work from any focus context (column header, titlebar, etc.)
Undo / Redo — Ctrl+Z undoes cell edits, paste, cut, replace, row insert/delete, column insert/delete, column rename, column reorder, and column resize. Ctrl+Shift+Z or Ctrl+Y redoes. A toast notification describes what was undone or redone. Multi-cell paste and cut undo as a single step. Works from anywhere in the window — no cell focus required
Find & Replace — Ctrl+F opens a find dialog for the active table. All matches are highlighted with next/previous navigation that scrolls matches into view; options for match case and entire-cell matching. Replace one match at a time, or Replace All as a single undo entry. Respects active filters and sort
Quick search — The table toolbar's default Search mode (press / in an active table window to focus it) highlights every matching cell — column headers included — without filtering rows; flip the toggle to Filter for SQL WHERE filtering. Matches formatted display values when plugin formatting is enabled, raw values otherwise. Enter or Tab moves the cursor into the first match, Tab/Shift+Tab step through matches, Escape returns to the search box; n/p jump to the next/previous match from anywhere in the table. A match counter and a toast make it obvious when the search wraps around. A Clear button (shown while the box has text) empties the search or filter in one click
Selection statistics — Selecting two or more cells shows Count, Sum, Avg, Min, and Max on the right side of the status bar, temporarily replacing the column count (numeric stats computed over the numeric cells in the selection)
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
Frozen row-number column — The # column stays pinned on the left edge when scrolling horizontally, so you always know which row you're looking at. Column headers use opaque backgrounds so scrolling data never shows through — including when a column is selected
Virtual scrolling — Handles large datasets efficiently

Getting Started

No installation is needed — use the hosted instance at https://app.cbreak.org/csvsql/. Even there, all data processing happens locally in your browser; your files are never uploaded.

Installation (optional)

If you'd rather run a standalone copy:

Option 1: pip

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

All dependencies are bundled locally — no internet connection 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. When no windows are open, the workspace shows a welcome screen with an Open File… button and a Try Example Data button that loads three small sample tables (customers, orders, products) you can query and join right away.

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 a cell to select it; press i, F2, or Ctrl/Cmd+U to enter edit mode; or Ctrl/Cmd+click a cell to edit it directly. Long text scrolls within the cell to keep the cursor visible
Navigate in edit mode — Tab/Shift+Tab to move between cells (stays in edit mode), Enter to save and move down to the column where editing started (stays in edit mode, exits on last row), Up/Down arrow to commit and move to the adjacent row (exits edit mode), Escape to revert the edit
Navigate in select mode — Arrow keys or h/j/k/l to move the selection, Tab/Shift+Tab to move right/left, Enter to move down, Escape to clear quick-search highlights if active, otherwise the selection
Insert/delete rows — Right-click a row number and choose "Insert Row Below" or "Delete Row"
Insert/delete columns — Right-click a column header and choose "Insert Column Right" or "Delete Column"
Empty table entry point — Right-click the # corner cell to insert a row or column when the table has no data
Rename columns — Ctrl/Cmd+click a column header. Duplicate names are rejected with a red border on the input
Reorder columns — Drag a column header to a new position. Click a column header to select it, then press Ctrl/Cmd+←/→ to nudge it
Column Manager — Open from Edit > Manage Columns (Ctrl/Cmd+Shift+M) or right-click a column header. A searchable vertical list of all columns in a lightweight dialog. Click to select, Shift+click for range, Ctrl/Cmd+click to toggle. Drag to reorder within the list or drop onto the table's column headers. Alt+Up/Down moves selected columns. Double-click a column name to scroll the table to it. All reorders are batched into a single undo entry when the manager closes. Esc closes from anywhere
Resize columns — Columns auto-fit to their content when a table first opens (very wide columns are capped at 75% of the window). Drag any column border to resize — the resize handle spans both sides of the divider line, including the # row-number column. Double-click to auto-fit the column to its content (measures all rows, not just visible ones). When multiple columns are selected (e.g. via Ctrl+A), double-click auto-fits all selected columns, and drag-resize sets all selected columns to the dragged column's width on release
Rename tables — Ctrl/Cmd+click the window title, use Edit > Rename Table…, or right-click (or long-press) the # corner cell
Highlight row & column — Clicking a cell highlights its row and column. Click a column header to select the entire column (with header row included for copy). Move the selection with arrow keys or vim h/j/k/l; extend to a rectangle with Shift+arrow (or Shift+H/J/K/L), Shift+click, or click-and-drag. Click a row number to select an entire row (drag or Shift+click for ranges). Ctrl+A selects all; Esc deselects all. Clicking the # corner cell toggles between select all and select none
Cut / Copy / Paste — Select cells and use Ctrl+X, Ctrl+C, Ctrl+V (Cmd on Mac). Data is copied as TSV. When a plugin display transform is active, copy uses formatted values; when formatting is disabled, raw values are copied. Select All and row selection copies include the header row. Works from any focus context (column header, titlebar, etc.)
Undo / Redo — Ctrl+Z / Ctrl+Shift+Z (Cmd on Mac). Undoes cell edits, paste, cut, row insert/delete, column insert/delete, column rename, column reorder, and column resize. Multi-cell operations undo as a single step. Works from anywhere — no cell focus required

Touch Gestures

Edit a cell — Double-tap the cell
Select a rectangle of cells — Tap a cell, then tap and pan to draw a selection rectangle from the first cell to the panned cell
Select rows — Tap a row number, or pan down the row-number column for a range
Context menus — Long-press (hold ~half a second) a row number, column header, or the # corner cell for the same menu as a right-click: insert/delete rows and columns, rename a column or the table, and sort
Reorder a column — Tap a column header, then tap-and-hold the same header and pan to the target position
Move a window — Tap the title bar, then tap the title bar again and pan to drag the window
Dock a window — Long-press the title bar (no prior tap) until the device vibrates, then drag onto another window — the touch equivalent of Shift+drag; drop on a title bar to tab, on a body region to split
Resize — Drag window edges/corners, column borders, dock splitters, and the console divider directly. Double-tap a column border to auto-fit, a splitter to reset the split, or a tab to maximize the dock
Undock a tab — Drag a tab vertically out of the tab bar and drop it on another window or empty space
Touch devices get larger hit targets and always-visible controls automatically; on phone-sized screens new windows open maximized

Sorting and Filtering

Sort — Click the sort badge (triangle icon) in a column header to cycle: ascending → descending → unsorted. Numeric values sort numerically (exact ordering even for integers beyond 2⁵³, so large IDs keep their true order); other values sort alphabetically
Multi-column sort — Shift+click additional sort badges. Numbers inside triangle badges show sort priority
Filter — Flip the toolbar toggle to Filter and type a SQL WHERE expression in the filter bar (without the WHERE keyword):
```
age > 30 AND name LIKE '%Smith%'
name REGEXP 'smith|jones'
```
A Clear button appears while the bar has text and removes the filter, restoring all rows
Quick search (default) — With the toolbar toggle on Search (the default; / also focuses it whenever the table window is active), type to highlight every matching cell, using the same highlight as Find & Replace; rows are not filtered. Column headers are searched too, and header matches come before the data cells when stepping through. The search matches what you see: formatted display values for columns with an enabled plugin format, raw values otherwise (Find & Replace always matches raw values). A match counter next to the input shows your position. Enter or Tab moves the cursor into the first match; Tab/Shift+Tab then step to the next/previous match and Escape returns to the search box. While stepping through matches, any other key acts on the matched cell as usual and ends the match navigation — i/F2/Ctrl+U edit it, arrows move the selection, Shift+arrows extend it — while n/p keep jumping between matches from anywhere in the table. Off-screen matches scroll smoothly into view (respects the OS reduced-motion setting). Wrapping past the last (or first) match shows "wrapped" in the counter and a toast. Pressing / while the toggle is on Filter switches to search mode only temporarily — Escape flips the toggle back to Filter, keeping the highlights until the search is cleared (empty the input — the Clear button next to it does this in one click — or Escape in the table)
Filter autocompletion — The filter bar suggests the table's column names and SQL keywords as you type (see SQL Console below)
Column autofilter — Click the funnel icon on any column header to open an Excel-style dropdown with searchable checkboxes for each unique value. Uncheck values to hide matching rows. Values are listed in numeric order for numeric columns, ordered by the raw value even when a plugin format displays them differently (e.g. as currency). Multiple column filters AND together and combine with the WHERE filter. The funnel fills teal when a filter is active. Click the Filtered chip in the status bar to clear all filters at once
Status chips — Sorted and Filtered chips are always shown in the status bar center. Linking only appears when the table is a link source, Linked only when it is a link target, and Formatted only when a plugin has matching column transform rules. Inactive chips appear with faint outlines. Sorted and Filtered chips clear the sort or filters when clicked (chip becomes inactive). Linked (on target tables receiving link filters) and Formatted chips toggle suspend/resume — suspended features show the chip with strikethrough. A Linking chip (coral red) appears on the source table whose selection drives link filters and on intermediate tables in a transitive chain; click to suspend/resume outbound linking. When a table becomes a link target (receives link filters from another source), any previously suspended Linking state on that table is reset. Keyboard shortcuts: Ctrl/Cmd+Shift+1 (clear sort), 2 (clear filters), 3 (toggle link), 4 (toggle format)
Column badges — The sort badge (orange triangle) and filter button (funnel icon) are rendered inline inside the column header as equal-sized clickable buttons. Both the sort triangle outline and funnel outline light up only when hovering their own button. Click the sort badge to sort; click the filter button to open the autofilter. The sort badge shows a filled triangle when sorted or a faint outline when unsorted. The filter button shows a faint funnel outline when inactive or a filled teal funnel when a filter is active. Small linking (coral red dot), link (green dot), and format (pink dot) badges appear centered over the bottom border of column headers — each badge type only renders when the table is relevant for that feature (link source, link target, or has matching transforms respectively). Active badges are filled, inactive badges show faint outlines. The linking badge appears on columns used for outbound linking; the link badge appears on columns receiving link filters. For transitive links, badges show a depth number (2 for secondary, 3 for tertiary, etc.). Badge colors match the status bar chips

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. The console and filter inputs feature SQL syntax highlighting. Query results open as new queryable tables. A query that matches no rows opens no result table — the console status line says so in amber, the color used for notable-but-non-error outcomes (errors stay red).

Autocompletion: As you type, a dropdown suggests table names (after FROM, JOIN, INSERT INTO, etc.), column names (after tablename. or a query alias, plus columns of any table referenced in the statement), and SQL keywords — filtered to those valid at the cursor position (for example, type names appear only inside CAST(... AS, and commands like VACUUM only at the start of a statement). Tab or Enter accepts the highlighted suggestion, ↑/↓ navigate, Escape dismisses, and Ctrl+Space opens the dropdown manually. Names that need quoting are inserted bracket-quoted automatically. Suggestions never appear inside string literals or comments, and while the dropdown is closed no keys are intercepted. The same autocompletion works in every table's filter bar, where that table's own columns are suggested first.

-- 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. Windows snap to workspace edges and other window edges within 10 px
Resize — Drag any edge or corner. Edges snap to workspace boundaries and other window edges
Maximize/Restore — Double-click the title bar, or click the maximize button. Dragging the title bar of a maximized window restores it to its previous size and moves it
Minimize — Click the minimize button. Restore from the Windows menu
Close — Click the close button. Ctrl/Cmd+click closes all windows
Layout — Use the Windows menu to Tile Horizontally, Tile Vertically, Grid, or Cascade
Proportional scaling — Windows reposition and resize proportionally when the browser window or console panel is resized
Dialog boxes — Prompts (New Table, Save As, Insert Column, Open URL) open as modal dialog boxes: the workspace dims behind them and they block other windows until you confirm, press Esc, or click outside to dismiss. All dialog boxes — including these, the Column Manager, and the About windows — are draggable and resizable but do not snap to window edges. Non-modal dialogs (Column Manager, Plugin About) always stay on top of regular windows, even when you click or focus other windows, and are excluded from layout operations (tile, grid, cascade)

Tabbing and Docking

Windows can be combined into tabbed groups and split layouts for an IDE-style workspace.

Tab windows — Hold Shift and drag a window onto another window's title bar to merge them into a tab group (on touch: long-press the title bar, then drag). Click tabs to switch between windows
Split dock — Hold Shift and drag a window onto the body area of another window (on touch: long-press the title bar, then drag). Drop zones are divided diagonally — drop on the top, right, bottom, or left region to split that direction
Reorder tabs — Drag a tab left or right within the tab bar to rearrange it
Move/undock tabs — Drag a tab away from the tab bar (vertically) to detach it. A ghost preview appears — drop on another window's tab bar to insert at a specific tab position (a vertical indicator shows where), on its body to split, or on empty space to place as a standalone window. Shift+drag skips reorder and enters ghost mode immediately. Dragging a tab never moves the dock itself — a pane's lone tab detaches as a ghost right away; drag the empty tab bar area to move the whole dock
Splitter — Drag the divider between split panes to resize. Double-click to reset to 50/50
Maximize — Double-click a tab or the empty tab bar area to maximize/restore the dock container. Dragging the tab bar of a maximized dock restores it to its previous size and moves it
Rename — Ctrl/Cmd+click a tab to rename the table
Close tab — Click the ✕ on a tab. When a dock reduces to a single tab, it dissolves back to a standalone window

Plugins

Plugins customize how cell values are displayed. A plugin is a JSON file that maps table and column name patterns (regex) to display expressions in the CSVSQL expression language — a safe, sandboxed language with no JavaScript execution.

Multiple plugins can be loaded simultaneously and stack on the same table — each column is governed by the last-loaded plugin with a matching rule. Renaming a table re-evaluates plugin rules against the new name, so transforms activate or deactivate automatically.

Loading: Use Plugins > Load Plugin in the menu, or drag and drop a .json file onto the app. A toast notification confirms success or shows errors. Plugins persist across page reloads.

Plugin management: Loaded plugins appear in the Plugins menu with an ✕ button for quick unloading — the menu stays open so you can unload multiple plugins without reopening it. Click a plugin's name to open an About dialog showing version, author, creation date, description, matching rules, and an Unload button.

Toggle: Columns with an active transform show a pink dot badge (format badge) at the bottom-center of the header. The Formatted chip in the status bar toggles all transforms on/off (Ctrl/Cmd+Shift+4). A Sorted chip appears when sort is active (click to clear), and a Filtered chip when filters are active (click to clear).

Autofilter integration: When a transform is active, the column's autofilter dropdown shows formatted display values and searches against them.

Plugin formats: Two formats are supported. The legacy format has table and columns at the top level. The multi-table format uses a tables array to target different tables with different rules in a single plugin:

{
  "name": "Orders ↔ Customers ↔ Products",
  "version": "1.1.0",
  "author": "CSVSQL",
  "created": "2025-06-13",
  "description": "Cross-table linking with display formatting",
  "tables": [
    {
      "table": "orders",
      "columns": [
        { "match": "^total$", "display": "isNum(value) ? '$' + fixed(num(value), 2) : value" },
        { "match": "^order_date$", "display": "isEmpty(value) ? '' : date(value, 'locale')" }
      ]
    },
    {
      "table": "customers",
      "columns": [
        { "match": "^signup_date$", "display": "isEmpty(value) ? '' : date(value, 'locale')" }
      ]
    }
  ],
  "links": [
    {
      "source": { "table": "customers", "column": "^id$" },
      "target": { "table": "orders", "column": "^customer_id$" }
    },
    {
      "source": { "table": "orders", "column": "^customer_id$" },
      "target": { "table": "customers", "column": "^id$" }
    }
  ]
}

The version, author, created, and description fields are optional metadata displayed in the About dialog. The tables and links arrays are both optional — a plugin can have just display rules, just links, or both.

Cross-table linking: The links array defines relationships between tables. When you select rows in a source table, the target table is automatically filtered to matching values. All table and column patterns are regex. The source table is excluded from its own link targets (even with .*). Link-filtered columns show a green dot badge (link badge) at the bottom-center of the header and a Linked chip on target tables. Outbound linking columns show a coral red dot badge (linking badge). A Linking chip appears on the source table and on intermediate tables in a transitive chain; click to suspend/resume outbound linking — the chip stays visible when suspended. For transitive links, depth numbers appear inside the linking and link badges (2 for secondary, 3 for tertiary, etc.). When a table receives link filters from a new source, any previously suspended Linking state on that table is reset. Clearing the selection clears the link filter. Link filters are separate from manual column autofilters. Links propagate transitively — selecting a product filters orders for that product, which in turn filters customers who placed those orders. Cycle detection and a depth limit prevent infinite loops.

Bundled example plugins and sample CSV files are in the example/ directory: date formatting, USD currency, boolean display, ID zero-padding, and a linked-tables demo with orders, customers, and products.

The in-app Plugins > Expression Reference has the full language documentation including all operators, built-in functions, and examples.

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+← / Ctrl+→ (or Cmd+arrow on Mac)	Move header-selected column left / right
i, F2, or Ctrl+U / Cmd+U	Enter edit mode on the selected cell
Ctrl+click / Cmd+click	Enter edit mode on the clicked cell directly
/ (data window active, not editing)	Quick search: focus the search input (switching a Filter-mode toolbar to Search temporarily)
Enter or Tab (in search input)	Move the cursor into the current quick-search match (starts match navigation)
Tab / Shift+Tab (match navigation)	Step to the next / previous quick-search match; any other key ends navigation and acts normally
Escape (match navigation)	Return the cursor to the search box
n / p (cell selected, quick search active)	Jump to the next / previous quick-search match
Escape (in filter/search input)	Return focus to the current match or selected cell (reverts a temporary / search)
Tab / Shift+Tab (cell selected, not editing)	Move selection right / left
Enter (cell selected, not editing)	Move selection down
Ctrl+Shift+L / Ctrl+Shift+H (cell selected, not editing)	Switch to next / previous table window
Ctrl+H / J / K / L (cell selected, not editing)	Nudge the active window 5 px left / down / up / right
Arrow keys (no cell selected)	Focus the cell in the middle of the view
Arrow keys or h/j/k/l (cell selected, not editing)	Move selection to the adjacent cell
Up / Down arrow (editing)	Commit edit and move to adjacent row (exits edit mode)
Shift+arrow or Shift+H/J/K/L	Extend cell selection — highlights each selected cell's row & column
Ctrl+A / Cmd+A	Select all cells
Esc (cell selected, not editing)	Deselect all cells
Ctrl+X / Cmd+X	Cut selected cells
Ctrl+C / Cmd+C	Copy selected cells
Ctrl+V / Cmd+V	Paste at selected cell
Ctrl+Z / Cmd+Z	Undo
Ctrl+Shift+Z / Cmd+Shift+Z	Redo
Ctrl+Shift+M / Cmd+Shift+M	Open Column Manager
Ctrl+Shift+1 / Cmd+Shift+1 through 4	Clear Sort / Clear Filters / Toggle Link / Toggle Format
Ctrl+Enter / Cmd+Enter	Execute SQL query
Ctrl+Space (SQL console or filter input)	Open the autocomplete dropdown
Tab/Enter, Up/Down, Escape (autocomplete open)	Accept / navigate / dismiss suggestions
Tab / Shift+Tab (editing)	Move to next / previous cell (stays in edit mode)
Enter (editing)	Move down to the column where editing started (stays in edit mode)
Escape	Cancel cell edit

License

CSVSQL is released under the MIT License — see LICENSE.

CSVSQL bundles several open-source libraries in lib/, including Papa Parse, sql.js, SheetJS, and JSZip. Their attributions and full license texts are collected in THIRD-PARTY-NOTICES.md.

Name		Name	Last commit message	Last commit date
Latest commit History 164 Commits
csvsql		csvsql
example		example
lib		lib
test		test
.gitignore		.gitignore
CLAUDE.md		CLAUDE.md
LICENSE		LICENSE
MANIFEST.in		MANIFEST.in
README.md		README.md
THIRD-PARTY-NOTICES.md		THIRD-PARTY-NOTICES.md
app.js		app.js
index.html		index.html
package-lock.json		package-lock.json
package.json		package.json
pyproject.toml		pyproject.toml
run-tests.sh		run-tests.sh
style.css		style.css

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

CSVSQL

Features

Getting Started

Installation (optional)

Option 1: pip

Option 2: No install — open directly

Usage

Opening Files

Editing

Touch Gestures

Sorting and Filtering

SQL Console

Saving Files

Window Management

Tabbing and Docking

Plugins

Keyboard Shortcuts

License

About

Uh oh!

Releases

Packages

Uh oh!

Contributors

Uh oh!

Languages

Folders and files

Latest commit

History

Repository files navigation

CSVSQL

Features

Getting Started

Installation (optional)

Option 1: pip

Option 2: No install — open directly

Usage

Opening Files

Editing

Touch Gestures

Sorting and Filtering

SQL Console

Saving Files

Window Management

Tabbing and Docking

Plugins

Keyboard Shortcuts

License

About

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Contributors

Uh oh!

Languages

Packages