Ctrl-Enter:
Ctrl-B:
Ctrl-A:
Ctrl-D:
Tab:
Load very large text files, very quickly, so that you can run SQL queries on them straight away.
- 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.