4 ms·
You should use Power Query for this usage, something like Get Data, From File, yada yada
by Foobar8568 3y ago
You should use Power Query for this usage, something like Get Data, From File, yada yada
- bugglebeetle 3y agoI should double click on the file and it open correctly, like LibreOffice does when I set it as the default for this file type.
- Foobar8568 3y agoThe 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.
- bugglebeetle 3y ago…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.