Re:Ask HN: If your job involves continually importing CSVs, ...
by iamwil on Thursday December 29, 2016 @01:02AM
(#13275906)
What sort of people provide the CSVs?
I myself have had to integrate with 3rd party logistics companies, and the way we got them to send out our inventory was to send them a CSV of our orders twice a day.
For example a lot of CSV data is used for plotting/visualization, because all they have is numbers. If they had more metadata they probably would have ported them to JSON.
Another observation: A lot of CSV dumps online are really that: data dump. It's a huge size file that's meant to be used after downloading, not for streaming like JSON/XML. You don't see many JSON apis that return huge size data, but it's common to see a lot of huge sized CSV files.