Has Freeform EVER been able to export data as a csv file?  I have this vague recollection of opening Freeform data in Excel in the past?

If I am going mad… is it at all possible to export the data in CSV so it will open in Excel as columns?

Also, I just upgraded to the latest version and the Export button just produces an empty .txt file.

Many thanks

Martin

Hi Martin,

I’m not sure if Freeform has ever been able to export as CSV… not for me anyway

The whole thing is pretty fubar actually.

You’ll have a much easier time just going to the “Manage Database Tables” feature in EE

CP Home ›  Admin ›  Utilities ›  SQL Manager ›  Manage Database Tables

exp_freeform_entries

Then, just hilight/copy/paste into Excel

Ok thanks for the response Pie Man.

I’ve managed to get the export to produce a tab-separated txt file that Excel can read by making a few changes in the Freeform code.

I’ve attached a modified version of the mcp.freeform.php file (for version 2.7.1) if it’s any use. (zipped because php attachments are not allowed)

The changes are in the function ‘export_entries’.
Each change is surrounded by comments ‘START EXPORT FIXES’ and ‘END EXPORT FIXES’.

The changes are:
(1) Comment out all the MSIE-specific stuff regarding headers, as this seems to make things worse rather than better.
(2) Remove carriage-return and line-feed characters from the field data to prevent premature line ends.

Maybe Solspace can comment on the validity of these changes, but they seem to do the trick for me, using IE7.

Thank you saratoga,

I’ll make a note of this to a developer

Brilliant saratoga!  Many, many thanks!

Sorry it’s been a while but just to let you know saratogas new file (above) is working great for us.  Just need to change the .txt extension to .xls once the file has downloaded.

Thanks again!

Also working great for me .. export button now produces easy opened csv file using MS Excel and Firefox .. many thanks.

This just seriously saved the day for me. Solspace needs to incorporate these fixes into their source. Stat.

Great stuff, cheers. Glad we found this, and also can’t believe that almost a year later this isn’t fixed in Freeform. Then again, it’s free so nur.