Hacker News new | ask | show | jobs
by UnserMannInK 723 days ago
I have the complete opposite experience. I use CSV files a lot, LibreCalc has a sane import dialog and handles these files near perfect by default. When working with Excel-users I always get a reply along the lines of „the file is weird, can you send me xls?“

And yes, I know that Excel opens CSV just fine. But it is not straightforward enough to explain it to a semi computer-literate office drone…

1 comments

Excel used to give you the option of using the import wizard for CSVs when you opened them. Now they've intentionally hidden that in a submenu, for some bizarre reason.

Libre Office is good enough for basic use, but Excel has a lot of great features for intermediate users. Some of the newer functions they've added in the last few years are great, I use LET with my own lambdas and the quite often. I also kinda like the Power Query/M language, but the implementation in Excel is absolutely horrible.