Text area content breaks the csv file?

CSV export should work correctly according to spec, including line breaks. As a test case, I exported a form that had a text area where I input line breaks. The resulting CSV is the following. It has a header line and 2 entries. Line breaks are preserved but since all the fields are quoted, it is valid CSV. I can import this into Excel for example.

"Submitted","name","message","Submitted Login","Submitted From",
"2014-06-03 11:39:17 -04:00","mike","yet another
multiline
entry","msimpson","10.0.1.20",
"2014-06-03 11:39:07 -04:00","mike","here is
my stuff
   that I wan to say
blah","msimpson","10.0.1.20",

Is the problem you are experiencing related to something like Excel reading the file? If the plugin is messing up the quotes, that could cause a problem. Could you post a sample?

Hi and thank you for your reply!
I actually got same results with your example.

Here is picture what I get when I import it to Excel 2010 (data tab, from text)

excample picture

Any further advice?

If Excel is not reading it in correctly, try exporting in the Excel TSV option. That removes the line breaks and is specifically for Excel.

Thank you but no luck with TSV, same result.

Are you able to import that code that you provided correctly to Excel, since I cannot, it will spread to wrong columns. But if I clear the empty spaces like below, it will spread out correctly.

"Submitted","name","message","Submitted Login","Submitted From",
"2014-06-03 11:39:17 -04:00","mike","yet another multiline entry","msimpson","10.0.1.20",
"2014-06-03 11:39:07 -04:00","mike","here is my stuff that I wan to say blah","msimpson","10.0.1.20",

I am able to import the code that I provided in Excel and the columns are correct using both CSV and Excel TSV export files. The Excel TSV export strips out the newlines. If that one doesn’t display in excel correctly then I think something is wrong with your Excel.

There are 2 ways to get the file into Excel and sometimes they behave differently. Try both
1. Open the .csv file with Excel
2. Create a new Excel document, then File -> Import the .csv into the doc. Indicate that comma is the delimiter for CSV and tab for TSV.

Oh my, it opened correctly just by opening csv file with excel, not importing it! Stupid me ??

One more, I have also field to upload an image, is there any way to get that image transferred to excel?

Where does this store the data, are uploaded images downloadable via ftp?

Thanks for all your help!

Images will not import into Excel but the URLs for them will. On the plugin’s Options page, set “Export URLs instead of file names for uploaded files” to “true”