Superintendent.app is a Desktop app that enables you to write SQL on CSV files. No more vlookup. No more 1M row limit on Excel. It is fast and handles large file well (e.g. load 1GB file in 10s).

Very cool! This would be very useful for those who know SQL. What about a UI for users that don't know SQL? Something with drag and drop would be neat.

@winston_fim Yes, this is a great suggestion. While we want to focus on SQL writing, we have plans to support simple operations like sorting, filtering, simple vlookup, and simple pivot tables through UI!

Hello Product Hunters, My name is Tanin, and I'm the creator of Superintendent.app, which is a Desktop app that enables you to load a bunch of CSV files and write SQL to analyze them. In my regular job, we offer accounting reports as CSVs to our customers, so I work with CSV heavily. Before Superintendent.app, the major frustration of working with CSV files was that I had to use either a command-line tool, a custom Python script, or Excel in order to analyze multiple CSV files. I chose Excel most of the times and often struggled with vlookup and pivot tables. Not to mention, Excel has the 1M row limit per sheet, which means it cannot handle a large CSV file. I hope my pain point resonates with you. As a person who knows SQL well, it felt very counter-productive. So, I've decided to build a prototype that later became Superintendent.app. Superintendent.app makes loading CSV files and writing SQL easy and quick. It is backed by Sqlite and sets up table names and columns automatically. It avoids name conflict, so you don't need to think about it. It can load 1GB CSV file within 10s. You just load a bunch of CSV files and start writing SQL immediately! As a novice in launching product, I'd love to get feedback and suggestion on any part (e.g. landing page, product). Please don't hesitate to send me your thoughts by commenting here or, privately, at tanin@superintendent.app. Thank you.