Related and definitely worth checking out is miller[0] which the author describes as "like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON"
1. Good idea!
2. Thanks, will look it over.
3. I limited it on purpose, not to overload html.
4. Didn’t think of it. Good idea!
5. Yes, you should be able to query it by SELECT profile->firstName
- Tad does this for CSV, and much more, like pivots
- XLS can be natively queried with SQL with many tools, for example dbeaver
- I am not aware of JSON tool, but this is trivially achievable with postgresql by just adding json as only field in the table and then using SQL to query it, even index it.
No single tool tho, but you can easily automate any of the above via script and have it locally, without browser which is instant show stopper for any serious work.
Files are not stored anywhere - everything works within your browser. When you add a file with 100k rows, it gets added instantly and you are ready to query.
[0]: https://github.com/johnkerl/miller