CSV Export does not handled by Excel correctly

Issue #7 closed
Areg Vrtanesyan created an issue

Hi

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?

Regards, Areg

Comments (8)

  1. Areg Vrtanesyan Account Deactivated reporter

    Hi

    Just wondering if you have any news about this?

    Regards, Areg

  2. [NPES] Alexey Dorofeyev repo owner

    Hi Areg, we're finally released new version of our app with this bug being fixed.

  3. Log in to comment