Hacker News new | ask | show | jobs
by rutthenut 1760 days 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!
1 comments

You should use power query to load csvs into excel that way you can control the parsing of columns.