The problem is that Excel let you open a file with a random format. Same for LO, CSV data is usually so dirty that you shouldn't manage them without an proper loading process.

…but Excel already does it without a proper loading process and just breaks the files. LibreOffice figured this out. Just have a small modal that pops up when you open with sane defaults. This works the vast majority of the time.