4 ms·
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 fil
by Someone 5y ago
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.
- cylinder714 5y agoI 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/ https://www.visidata.org/