Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Do people really edit csvs in a text editor? It's horrific, the columns don't line up at all, empty cells are represented by a bunch of commas in a row (which, are you supposed to count all the commas?)

And in terms of versioning, I have seen people commit diffs of csvs before, and they're equally unreadable.

CSV is a plain text format, but that basically buys you nothing. As long as you're going to be loading it into excel or whatever anyway, might as well just pick a good binary format like parquet.



I create and edit CSVs by hand daily. To create/modify simple examples to provide technical support for a data transformation tool.


I frequently edit CSVs by hand. As long as you understand your data, and stakes are low (e.g. it's a one off analysis not prod code) it's pretty easy and convenient.


I frequently use the table syntax in org-mode. No, I wouldn’t edit CSVs because they are miserable, but a friendly syntax with some basic text editor support, absolutely.


Rainbow CSV in VSCode makes it a lot easier to deal with.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: