Query and visualize CSV files using SQL

You can use SQL to query and visualize gigabytes of CSV files on your local machine. Superintendent.app is an offline desktop application and ensures .

Enjoyed by 100+ of data scientists, engineers, analysts, and consultants!

Achieve what you want in seconds

1 1-click installation

It takes seconds to download and install with a single click.

2 Add CSV files

Add or drag-and-drop CSV files. It adds within seconds.

3 Write SQLs

Filter, transform, and sort CSVs. Build beautiful reports and charts.

Why use Superintendent.app?

	Comparison
Superintendent.app Excellent for working with CSVs	Easy installation Easy to use Supports large files Installed with a single click, the UI-based app is purposefully built for your productivity. You can build your reports within seconds. In addition, it supports large CSV files e.g. importing 1GB file in 10 seconds.
Spreadsheet apps Microsoft Excel and Google Sheets	Easy installation Easy to use Supports large files Spreadsheets like Excel and Google Sheets are clunky with SQL and don't support CSVs larger than 1 million rows.
Database tools DBeaver and MySQL Workbench	Easy installation Easy to use Supports large files This alternative requires a database setup and often offers a myriad of unnecessary functionalities (e.g. configuring database) that get in the way for users who work with CSVs.
Command-line tools csvkit and q	Easy installation Easy to use Supports large files This alternative often requires Python setup. Managing multiple CSVs and SQLs in a terminal is clunky. While the tools don't impose a restriction on the file size, they are not performant when handling large files.
Databases SQLite and DuckDB	Easy installation Easy to use Supports large files Managing multiple CSVs and SQLs directly in a database's terminal is extremely clunky, even more clunky than using a command-line tool.

Features

Built for your productivity. Excellent at handling large amount of data.

Manage many SQLs

Make a draft, rename, delete, move tabs around, and re-run.

Save your workspace

Load it back later, send it to your colleague. Never lose your work.

Export CSVs

Once you finish, you can export your results to CSVs.

Build charts

Visualie your results in line charts, bar charts, stacked bar charts, and pie charts.

Copy columns

Click on columns and press Ctrl+C to copy. Copy millions of cells or as much as your memory allows.

Run a part of SQL

Highlight a part of SQL and see its result when you aren't sure what the SQL entails.

Sort columns

Click on multiple columns to sort ASC or DESC. Only one click away for your convenience.

Auto-detect CSVs

Just import CSV. The names and types are automatically handled for you.

What other people said

I use superintendent.app (made by @tanin) basically let's you run SQL on raw CSVs

SandeepDinesh on Twitter

Cool app to query CSV’s with SQL! superintendent.app

LukebAbell on Twitter

Handige tool! Superintendent, SQL-tool voor CSV bestanden superintendent.app

gvenk on Twitter

This cool tool allows you to use SQL to search and manipulate your CSV files. superintendent.app

mrkledal on Twitter

In my last job I was forced to use VBA with Excel for some large automation tasks. Coming from Python Pandas and SQL background, it was... bad. This looks very cool!

NINTSKARI on Reddit

¿Una aplicación o producto ha mejorado considerablemente tu trabajo del día a día? Empiezo yo: superintendent.app

DannyProl on Twitter

Get started

Query CSVs and write SQLs today. No credit card required.