4 ms·
It sounds like SO isn't really an expert on Excel. The correct answer (Data > From Text/CSV) is sitting at the bottom with 0-1 votes. Most answers are from the
by bzxcvbn 4y ago
It sounds like SO isn't really an expert on Excel. The correct answer (Data > From Text/CSV) is sitting at the bottom with 0-1 votes. Most answers are from the early 2010's and outdated.
- iLoveOncall 4y agoThis does not work even in Excel 2019. In any case, not supporting when you just double-click a CSV to open it with Excel means that it's not usable for the vast majority of users. We faced the issue when we were exporting data to customers in CSV format, and "Replacing new lines with '/'" ended up being a preferred solution over having the user perform any action.
- bzxcvbn 4y agoMaybe stop using outdated software?
- iLoveOncall 4y agoThe mainstream support for Office 2019 ends on October 10, 2023 and the extended support on October 14, 2025. It's not outdated software.
- bzxcvbn 4y agoSupported doesn't mean current. They'll fix security holes and help paying customers use the software as it is, but that is it. Not introducing new features or backport improvements.