CSV doesn't do what you want and excel doesn't support CSV files. Why insist on a completely wrong tool and file format combination? If the excel developers ca

CSV doesn't do what you want and excel doesn't support CSV files. Why insist on a completely wrong tool and file format combination? If the excel developers cared about CSV support they would have added more settings to the CSV import tool that let you specify everything. Every single data base tool that lets you import CSV files has worked better than Excel. It simply means Excel wasn't built to import CSV files. Tough luck. .xlsx file extension is well supported by many open source libraries. If you insist on working with Excel then you should use the appropriate file format, which is .xlsx. I do that all the time and it just works.