You can use my SQL spreadsheet app: https://superintendent.app I had a similar problem at work where I needed to do some formula on a 5 GB CSV file. Excel can't handle more than 1M rows. Database is too clunky. Eventually I built a GUI wrapper on SQLite, and it grew into Superintendent.app. - Source: Hacker News / 22 days ago

Desktop first made me think of Superintendant[0] which I’ve enjoyed using 0: https://superintendent.app/. - Source: Hacker News / 10 months ago

Project 3: Electron with typescripts. 15 paying users. Source: 12 months ago

That is exactly https://superintendent.app (disclaimer: I'm the creator). - Source: Hacker News / over 1 year ago

Well, shameless plug. https://superintendent.app (paid with free trial) enables you to load a bunch of CSVs and write SQL on those CSV files. It's a much faster to work with if you know SQL well. It can also handle millions of rows easily (e.g. Loading 1GB CSV file takes 10s on Macbook Pro). I initially built it because I had to identify the mismatched transactions between 2 giant CSVs using "full outer join". - Source: Hacker News / over 1 year ago

Cloudquery: https://cloudquery.io/. Source: about 1 year ago

Looks nice! If you are interested in enabling ELT of Plunk data to any destination you can take a look at building a CloudQuery plugin powered by your new Plunk SDK. (Disclaimer: Founder @ CloudQuery). Source: about 1 year ago