Why isn’t there a decent file format for tabular data?

Re:Why isn’t there a decent file format for tabular data? by Someone on Wednesday May 04, 2022 @02:32AM (#31257393)

Indeed, it’s because people use an editor that isn’t designed for editing csv to edit csv.

Every csv files is a text file, but not every text file is a csv file, but people use text editors to edit them.

A csv editor would forbid you from entering that quote, automatically add a matching one, ask you for your intentions, or whatever, but it shouldn’t silently corrupt your file.

A spreadsheet-like UI, but without formulas, automatic single header row, etc. would be a better UI for csv files.

If you use zip to edit a .xlsx or .docx file, you easily get an invalid file, too.

[ Parent | on HN ]

Re:Why isn’t there a decent file format for tabular data? by cylinder714 on Thursday May 12, 2022 @11:17AM (#31355418)

I think you just described VisiData:

VisiData is an interactive multitool for tabular data. It combines the clarity of a spreadsheet, the efficiency of the terminal, and the power of Python, into a lightweight utility which can handle millions of rows with ease.

https://www.visidata.org/

[ Parent | on HN ]