I gave up on Excel for working with CSV years ago, but it sounds like I need to go back and try again. It used to drive me crazy how the import function was all "just fuck my shit up, Fam" every time.

Reminds me of the old joke about it: How is Microsoft Excel like an Incel? Both think everything is a date.

> Automatic Data Conversion (hint: Disable everything).

It still butchers long strings of digits if they are more than around 12 and less than around 15 digits long, its very annoying still.

Also textjoin and textsplit and the whole spill functionality.