3 ms·
I don't get it. Are JSON and XML files more friendly to import vs CSV files? I always assumed CSVs were the standard. Any reasons to prefer structured formats?
by shubhamjain 1y ago
I don't get it. Are JSON and XML files more friendly to import vs CSV files? I always assumed CSVs were the standard. Any reasons to prefer structured formats?
Shameless plug: I am working on a similar problem of Excel not being a great tool for large datasets. My desktop app[1] lets you import raw data files and query them using SQL. (The website needs to be updated, the app looks much better than the current screenshots).
[1]: https://textquery.app https://textquery.app
- Botlabs 1y agoyes they are a lot easier to work with when inserting into the database