Automatically recognize unicode CSV file automatically
Currently, to open Unicode encoded CSV file in Excel, you would need to go through cumbersome import process. for example:
Just opening the CSV file will cause some characters displayed as garbled.
Please add the functionality for Excel to automatically recognize CSV contains Unicode and display it properly (like Notepad for example).
This is similar as an ask for Excel for Mac:
Yeah, it's quite silly that in today's global world, with CSV being a format used specifically for data interchange, that Excel always assumes the encoding of the CSV is the system default.
Default assumption should be UTF-8, and users should be able to tell Excel to use a different encoding if needed. (Without having to jump through hoops with the import text wizard)
Hedvig Skirgård commented
Yes, someone please fix this ASAP. This is ridiculous.
Kenneth Barber commented