At my company we have a data warehouse which imports some .csv files that are directly supplied by the business side. Some of these are manually created from Excel files, some of them are .csv files where someone has to add a column to, for example, calculate a certain value.
Predictably, it has happened that some people opened the files directly in Excel by double clicking on them and thanks to auto-formatting it lead to import errors. Using import 'From text' in Excel works fine, but it's very prone people not using it. Notepad++ does not lend itself to editing the data.
I know a few good .csv viewers, but are there any good editors out there? I found similar questions, but most of them are fairly old and the suggestions don't even exist any more. Libre Office gets suggested quite a bit, but the comments read as if it's better at Excel at not auto-formatting the data (not a high bar to clear), but not perfect or close to it. OS is Windows.