• Hi, Im having trouble exporting the data entered into Contact Form 7 via CFDB – whenever I export into Excel, all data (name, subject etc.) end up in a single column, looking like this:

    Submitted,”your-name”,”your-email”,”your-subject”,”your-message”,”Submitted Login”,”Submitted From”,

    i.e.

    2014-05-13 12:00:41
    +00:00,”s”,”s@hotmail.com”,”s”,”s”,”x”,”88.217.134.166″,

    Instead, I would like to have all submissions show up seperately (as they are when entered in the Form – thus name in one column, address in a sepearte column etc.). What am I doing wrong? Interestingly, when Im logged in into WP, I can see all the data in seperate columns – but when I export them into Excel, they all end up in the A column.

    Thanks!

    https://wordpress.org/plugins/contact-form-7-to-database-extension/

Viewing 1 replies (of 1 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    Try the different Excel export options (including . If still having the problem, it is likely that Excel is not recognizing the “,” as the field delimiter. You may need to save the file, then go to Excel and import (not open) the file and see if there is a dialog where you can specify the delimiter.

Viewing 1 replies (of 1 total)

The topic ‘How do I remove single-column export?’ is closed to new replies.