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 / 26 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

Not a CLI tool, but I recently started using https://klogg.filimonov.dev/ klogg (which seems to be a successor of glogg) more and more often. - Source: Hacker News / 4 days ago

Glogg is a great tool, but unfortunately it is not developed anymore. I maintain a fork -- klogg (https://klogg.filimonov.dev). It is generally faster for both opening a file and performing searches. Current dev builds that use hyperscan regular expression engine can open a file and do a search while glogg would still be indexing that file. Source: about 2 years ago

Once I had to go through an unusually large log file which was around 2GB. I am a regular Notepad++ user but it couldn't handle the file. In addition to opening the file I also needed to search around the file for keywords like Error or Exception. I found klogg to be just the right tool for me. It allows for viewing as well searching for words within the large text file easily. - Source: dev.to / about 2 years ago

This is still an early stage TUI, many widgets are incomplete or missing (i.e. Text area, partial keyboard support, incomprehensible Documentation) I have very little time to work on it and the progresses are incredibly slow. I develop it in order to create a terminal log viewer that could mimic the features exposed by glogg or klogg. Source: over 2 years ago