I have just been trying to export some of the data collected through Freeform for use in Excel. Unfortunately some of the entries contain line breaks between paragraphs which causes a new line in Excel rather than single cells containing multiple paragraphs of text.

Is there anyway to get around this problem?

cheers Kenny

How are you currently exporting the entries?

Anyways, what seems to really work is the SQL Manager:

CP Home › Admin › Utilities › SQL Manager › Database Query Form › exp_freeform_entries › Query Result

Highlight the page, copy and paste into Excel… it seems to get it right.

Hi,

I’m also having the same problem.

A field that contains embedded line-breaks must be surrounded by double-quotes so I’m thinking this will take some tweaking to the Freeform code?

Don’t you just love Excel!!!

Cheers,

Dave.

How are you exporting the entries?

I’m having the same issue. Some fields are collections of checkbox data, and each line looks like it has a line break after it, which is hosing the output in Excel. I am certainly not going to instruct my client to go browsing DB tables with the SQL manager when there is an export button available. Might there be a simple hack that I can apply to the export function, or should I just go with the CSVee plugin from a third party? Anyone have any thoughts one way or the other?

+1 on this issue - for multiple clients / websites.

I’ve resorted to CSVee for now.

I too am having this issue.

It seems that when someone submits a comment thru the form, it’s inserting a linebreak into the database which, in turn, throws a line break into the CSV file and throws off excel.

Is there a way to NOT have line breaks in the form convert to line breaks (ie..\n) in the database?

Thanks

We are looking into this for the next release of Freeform

Thanks for the reply and I look forward to the next version!