Superintendent.app

Load multiple CSV files and write SQL

(powered by DuckDB)

Click here to get a trial license key and download the app

As seen on:

Superintendent.app - Write SQL on CSV files (Desktop app) | Product Hunt
Show HN: Work with CSV files using SQL. For data scientists and engineers
Superintendent.app - Write SQL on CSV files (Desktop app) | Reddit

Features

Load multiple CSVs and write SQL
SQL is the most efficient way to analyze and transform multiple CSVs.

No more custom and slow Python script. No more vlookup, no more pivot tables, and definitely no more reaching the row limit on Microsoft Excel or Google Sheets.

Export result to CSV
After you write SQL to retrieve the information that you want, you can export the result back into a CSV file.


Use cases

Clean up CSV files
Reformatting or changing one column in a CSV file is very troublesome. More than often, we would have to write a Python script to do so. With Superintendent.app, it is much more convenient and faster.

Depending on how fast you can type, transforming a 1GB file can take less than 30 seconds in total.

Analyze data from multiple CSV files
Superintendent.app allows you to analyze multiple CSV files (e.g. join them by some columns).

This is particularly useful when you get CSV files from multiple sources like your Bank, Stripe, and Paypal, and you want to reconcile them together.


Pricing

$40 USD/year

We offer 14 days free trial. No credit card required.

Click here to get a trial license key and download the app

If you would like to purchase a license (pay here), please pay and send an email to tanin@superintendent.app.

Students can obtain a free individual license by emailing tanin@superintendent.app.


Does your workplace reimburse software's cost?

If so, you should definitely try Superintendent.app.

While there are a few alternatives, Superintendent.app is much more convenient and can save hours each month.

Let's compare it the alternatives:

Solution Compared to Superintendent.app
Python script Superintendent.app is much faster than a Python script and can load 1GB file within 10 seconds.

A python script loading a 1GB file is likely to take more than 1 minutes on any machine.
Excel, Google sheets Excel cannot handle a CSV file with more than 1M rows. Google Sheets has similar limitation.

If you are familiar with SQL, using SQL is much better than using Excel formula.
Loading CSV into a database Loading CSV into a database often involves using a command-line tool. It's inefficient and inconvenient.

Even if Superintendent.app only saves you 30 minutes per month, it's already worth the minimal price tag that we will charge after beta.


What SQL-dialect is used in Superintendent.app?

Since Superintendent.app is powered by DuckDB underneath, the DuckDB's SQL dialect is used.
You can read more about DuckDB's SQL here: https://duckdb.org/docs/sql/introduction