3 ms·
I use LibreOffice to open all my CSV files because somehow, in the year 2024, Excel can’t do that without messing them up. And yes, I know about the import wiza
by bugglebeetle 3y ago
I use LibreOffice to open all my CSV files because somehow, in the year 2024, Excel can’t do that without messing them up. And yes, I know about the import wizard that still manages to mess them up at least some of the time.
- KronisLV 3y ago> I use LibreOffice to open all my CSV files I really love the preview, where you can choose what delimiters and character encoding you want to work with, which row to start from and so on. It's so very user friendly and nice to use.
- bugglebeetle 3y agoIt’s the best! I have no clue how Excel continues to be so awful at this, by contrast.
- BeefWellington 3y agoThe Excel team treats the CSV format like Voldemort. They put no effort into it because it's an open file format they can't seize control of.
- deleted 3y ago[deleted]
- Foobar8568 3y agoYou 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.