Microsoft Excel by default incorrectly reads CSV files with escaped characters.
Here is what you cat try to work around this:
- Instead of opening the csv file import it with "load data from text" function https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba . This mostly works but in some special cases data will still read incorrectly.
- Use Libre Office. Opening CSV file should work without any configuration
- If you are using a Mac try using Numbers