Imperva Cyber Community

Expand all | Collapse all

Malformed Excel

Jump to Best Answer
  • 1.  Malformed Excel

    CHAMPION
    Posted 12-09-2020 07:02
    Hello,

    Many reports generated by MX contain very long queries and when opened in excel is malformed. The only solution so far is if we upload them to google sheets, they are perfectly formatted. Has anyone had this issue?
    #AllImperva

    ------------------------------
    Sabajete Elezaj
    SNT Albania
    ------------------------------


  • 2.  RE: Malformed Excel

    Community Manager
    Posted 12-11-2020 10:51
    thanks @Sabajete Elezaj for the question.  Maybe @Stefan Pynappels or @Craig Burlingame could help with this question.

    FYI: @Patrick McCrudden​​​

    ------------------------------
    Christopher Detzel
    Community Manager
    Imperva
    ------------------------------



  • 3.  RE: Malformed Excel
    Best Answer

    Posted 12-12-2020 17:37
    Hi @Sabajete Elezaj

    The issue might be because Excel doesn't recognize UTF-8 Encoding automatically when opening files.
    I assume your queries might have some non-English chars?

    One workaround can be to open your CSV is notepad first, then clicking "save as" and choosing ​​"UTF-8 with BOM".
    Another workaround is to open Excel, choose "Data -> From text/CSV " and then choose UTF8 or another encoding.

    Finally - It can be a nice Feature Request to have the MX create CSV reports already with BOM (Byte Order Mark).

    I hoe this helps,
    Roee

    ------------------------------
    Roee Sharon
    RSECURE
    ------------------------------



  • 4.  RE: Malformed Excel

    CHAMPION
    Posted 12-14-2020 06:05
    Thank you Roee, it helped a lot :)

    ------------------------------
    Sabajete Elezaj
    SNT Albania
    ------------------------------