News for hackers. Stuff that matters.
Re:Time to retire the CSV? by bluedino on Wednesday August 18, 2021 @12:32PM (#28223608)
Except that won't open in Excel
Re:Time to retire the CSV? by WorldMaker on Wednesday August 18, 2021 @02:20PM (#28225135)
Excel actually has really good JSON import… it's just "hidden" in the Data tab on the ribbon and users don't want to learn how to use it.

I feel so much of what keeps CSV in use is that it's a format that you can relatively easily generate without pulling in a lot of library dependencies and relatively quickly generate something that users can just "double click it opens in Excel".

What the Excel team could really gift to developer humanity at this point is some dumb file extension Excel registers like XLJSON that you could just rename a JSON file to and Excel opens it like a spreadsheet on double click.

Re:Time to retire the CSV? by cogman10 on Wednesday August 18, 2021 @12:53PM (#28223912)
Correct. That'd be a moving goalpost. The original claim was that JSON doesn't work well with columnar data.

If the primary usecase is to take data give it to a non-programmer to evaluate it, then CSV isn't terrible. Add a transformer that's ran when someone manually requests to see the data.

However, for machine to machine communication, CSV should never be used.