Csv are easy to open in any spreadsheet software. You can even copy/paste it straight into some of them, e.g. LibreOffice Calc
Comment on abandonware empires
doctorcrimson@lemmy.today 7 months ago
My bank started using Quickbooks file format if I want to download a transaction history, what a fucking nightmare. It’s not abandoned yet but nothing except the QuickBooks proprietary software seems to open them so far.
Lifter@discuss.tchncs.de 7 months ago
Stretch2m@lemm.ee 7 months ago
Beware opening CSV in Excel. You will lose all your leading zeroes, among other “helpful” edits. Sometimes the leading zeroes are there for a reason!
hangonasecond@lemmy.world 7 months ago
Newest update to excel asks before applying default formatting and type conversion just as an FYI.
doctorcrimson@lemmy.today 7 months ago
OH BOY I LOVE OPENING A DATA DOCUMENT AND SPENDING THE NEXT HALF OUR FORMATTING IT MYSELF, TYSM
Honytawk@lemmy.zip 7 months ago
CSV isn’t nightmarish, it is just a table structure in text form. You can open it with any text editor.
frezik@midwest.social 7 months ago
The problem is that it’s not really a standard. It’s reinvented ad-hoc by whomever programs it today.
Should there be any whitespace after the comma? Do you want to use pipes or some other character instead of commas (ASCII 0x1E is sitting over there for exactly this purpose, but it’s been ignored for decades)? How do you handle escaping your separator char inside the dataset? Are you or or ? None of these questions have a set answer. Even JSON has more specification than this.