Load multiple CSVs and write SQL
SQL is the most efficient way to pull information from, 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.

Make charts and graphs
You can build beautiful line charts, bar charts, and pie charts for your next presentation.

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.

For example, reformatting a date column from mm/dd/yyyy to yyyy-mm-dd can be done with a single SQL like: SELECT *, strftime(date_parse('%m/%d/%Y', birthdate), '%Y-%m-%d') FROM your_csv

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

Analyze data and build charts from multiple CSV files
Superintendent.app allows you to analyze multiple CSV files (e.g. join them by some keys) and build beautiful charts for your next presentation.

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.