5 ms·
Excel definitely opens CSV files, and Windows file associations tend to set that up by default. However, Excel then goes ahead with changing the content to ofte
by rutthenut 5y ago
Excel definitely opens CSV files, and Windows file associations tend to set that up by default.
However, Excel then goes ahead with changing the content to often wrongly-assumed formats. My favourite hate is how it will convert mobile numbers from a string of digits to an unusable exponential-format number. Hey, it doesn't even set column widths to make the content visible!
- nojito 5y agoYou should use power query to load csvs into excel that way you can control the parsing of columns.