> Why is CSV support in Excel so poor? CSV isn't a proprietary Microsoft format. In fact worse: It competes with Microsoft's proprietary formats. Microsoft wo

> Why is CSV support in Excel so poor? CSV isn't a proprietary Microsoft format. In fact worse: It competes with Microsoft's proprietary formats. Microsoft would like everyone to be sending data to one another using xlsx, but not so much that they'll make generation/processing libraries and tooling free cross-platform, just enough to sabotage everything that isn't that. Microsoft made these decisions during their "evil" years, and never back-tracked. So regardless that CSV is used in multiple industries for data exchange (e.g. financial, order/invoicing, scientific, etc) they'll just keep on corrupting them until you use what they want you to use.