DIRTY
LITTLE
SQL
Esc ➜ B: Add cell below. Esc ➜ A: Add cell above. Esc ➜ Up/Down Arrow: Move to previous/next cell. Enter Edit selected cell.
Esc ➜ D: Delete cell. Alt-Left: Previous Query in History. Alt-Right: Next Query in History. Ctrl-S: Save results as CSV.
CSV TXT JSON
XLS ODS XLSX
DB SQLITE
Load very large text files, very quickly, so that you can run SQL queries on them straight away.
  • Fast A 10 million line CSV or delimiter-separated file will load in less than 10 seconds. Click + above to select a file to load.
  • Secure All data stays on your computer, you're not uploading anything anywhere.
  • Flexible Load as many files as you like and treat them all as tables in the same database. Field delimiters are automatically detected.
  • Many File Formats Works with Excel, OpenOffice files, JSON files, and even SQLite db files too! You can use Ctrl-s to save your query results as a CSV.
  • Convenient Your queries and results are stored so you can use Alt-Left and Alt-Right to review and rerun them.
  • Fancy You can get the results of your queries as charts. Just use Alt-Enter instead of Ctrl-Enter when running the query. The first column in your results is treated as the X-Axis, and all subsequent columns as values to be plotted on the Y axis.
  • Notebook-Like Use Ctrl-a and Ctrl-b and to add as many new query cells as you like, where you like, and create a notebook for saving results to a PDF.
Under the hood.
  • sql.js The database is a web-assembly version of SQLite called sql.js that runs in your browser.
  • VSV It also uses a SQLite extension called vsv to load delimited text files quickly.
  • Codemirror Syntax highlighting
  • sheet.js Excel and Openoffice support.
  • chart.js Charts
  • LocalForage IndexedDB for efficient local storage.
  • Github You can view the git repository for this project at the author's github page..