It also behaves differently if you open the csv from inside excel rather than if you doubleclick the file in explorer.

And we haven't even gotten to file encodings yet.