I have a csv file (comma delimited and quoted). When csv file is opened directly from explorer excel correctly interprets the cells that are mutliline, but it messes up the character encoding (utf-8).
Therefore I have to use import function (Data/Get External Data/From Text). However, when I use import text function in excel (where I can set file encoding explicitly) it interprets the newline as start of the new row instead of putting multiline text into a single cell and breaks the file layout.
Can I somehow overcome the situation by either
- forcing the explorer open command to use
65001: Unicode (UTF-8)encoding
- forcing the Text Import Wizard to ignore quoted line breaks as record delimiters