How is the CSV formatted?

  • Hello.

    I can’t understand how the exported CSV is formatted.

    If I try to import in in a .xls file, columns and rows are messed up, whatever separator I use (tab, semicolumn, comma, space etc.).

    I couldn’t find a way to show it properly in a tab.

    What am I missing?

Viewing 5 replies - 1 through 5 (of 5 total)

  • Just open csv file in Excel or Google drive.

    Thread Starter mrprainx

    (@mrprainx)

    Thank you @wpdebuglog. I know how to open a .csv file. My issue is that I can’t put it in a proper table, with a header, columns, rows…etc.
    Usually you can import it in an Excel table by stating which is the separator and few others settings.

    The problem is on separators: if you have commas in the message body, then when you try to convert the CSV into columns, the data are splitted in the wrong way.

    So the question is: is there a way to export the CSV using another symbol as a separator? I.e.: ;

    Thank you

    Thread Starter mrprainx

    (@mrprainx)

    Anyone has a solution for this?

    Thread Starter mrprainx

    (@mrprainx)

    Does this plugin still have support?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘How is the CSV formatted?’ is closed to new replies.