December 6, 2020
Using Excel for CSV files is like using Word for developing code. You could do it if you like suffering and mostly program in Malbolge, but for everyone else, it’s just the wrong tool for the job. Let’s first cover the main functionality Excel has that Modern CSV does not: Figure plotting Formulas Macros Pivot Tables Individual cell formatting (font, color, etc.) Embedding pictures, videos, etc. As a general spreadsheet tool, Excel is great when you need these things, but it’s a poor tool for dealing with CSV files. Here are the main complaints people have about it: Automatically formats […]