Calc handles CSV far better, period. Excel has language-dependent unconfigurable separators, quoting problems, whitespace problems, charset problems, BOM problems, weird expansion problems (like interpreting stuff as dates randomly), etc.

I cannot understand how anyone uses Excel with any nontrivial amount of CSV data without going mad...

> Calc handles CSV far better, period.

I wholeheartedly agree. :-) Dealing with CSV was the main reason I had LibreOffice installed on my work laptop.

Power Query