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.