5 ms·
Doesn't Excel by default capture the .csv extension so that it gets called automatically when you try to open the file? Since Excel is one of the few standard
by mark-r 6y ago
Doesn't Excel by default capture the .csv extension so that it gets called automatically when you try to open the file?
Since Excel is one of the few standard pieces of software that knows how to open CSV, it gets used a lot of times when it shouldn't. There's another post I made comparing Excel to a swiss army knife, and there's a reason for that.
- adwww 6y agoI don't know many engineers - even in the data team - with an Office license.
- mark-r 6y agoI think our company has a company-wide license for Office. When IT sets up a machine you get it automatically. Microsoft works hard to get those kind of setups to be common-place.
- adwww 6y agoLast time I worked in a big corporate you had to fill in a long form to request a license for anything you needed. If you didn't use it again within a fortnight or so it got yoinked away... The startups I've worked at since have all been big on GSuite.
- foobar1962 6y agoThe problem with Excel is that it changes the data, silently.
- jugg1es 6y agoSure it does but it doesn't give a f*k - once you open it in excel, it does its' own formatting and will save that incorrect formatting even if you save the CSV as a CSV