CSV Reporting

0
Hi, (creating a new post for a new issue)

I am not able to export reporting in proper formatting. The exported CSV is unreadable.

Please help
(Screenshot attached)
Attachments:
Responses (1)
  • Accepted Answer

    Joan Vilà
    Joan Vilà
    Offline
    Tuesday, February 02 2016, 08:13 AM - #Permalink
    0
    Hello,
    That's because the format in which you are importing the exported file in excel, is not the appropriate one.

    I know that you can tell excel which is the format of the csv you are importing, but meanwhile, try adding this on the first line of the CSV file:

    sep=;

    I've found this possible solution here: http://superuser.com/questions/180964/how-to-open-semicolon-delimited-csv-files-in-us-version-of-excel

    Tank you,
    Joan
    The reply is currently minimized Show
Your Reply