I have noticed that CSV export is not handled by Excel correctly if field description has new lines in it together with commas and quotes.
The only way that I have found to workaround it is to:
- Open file in text editor like Notepad++
- Add separator value at the first line like "sep=|" - no quotes
- Replace first line column name separator from comma to |
- Search and replace "," combination with "|"
- Check for occasional empty new lines ...
Then I can open it in Excel and analyse data.
Could some kind improvement be added for this?
May be sanitise descriptions for new lines, commas and quotes?