I just found out - when i enter a hyphen in front of the Option text it makes an Error #Name? when importing the CSV to Excel

without it works fine

I append the CSV Export files 1 (Import - the error showing perhaps because of the hyphen) and 2 import OK

so far the export works fine

hope now its clearer

CommentFileSizeAuthor
#7 Screen Shot 2016-10-14 at 8.52.32 PM.png43.87 KBjrockowitz
#4 Screen Shot 2016-10-05 at 3.38.26 PM.png15.91 KBjrockowitz
onlineanmeldung_nfb (2).xls36.71 KBlomale@bluewin.ch
onlineanmeldung_nfb (1).xls34.42 KBlomale@bluewin.ch

Comments

lotmatthu created an issue. See original summary.

jrockowitz’s picture

jrockowitz commented

I was able to duplicate this issue and this is the problem.

http://superuser.com/questions/224983/stop-excel-recognizing-a-dash

jrockowitz’s picture

jrockowitz commented
Status: Active » Needs work

Here are some more references...

http://superuser.com/questions/393134/open-csv-file-in-excel-having-lead...
http://stackoverflow.com/questions/4438589/bypass-excel-csv-formula-conv...

jrockowitz’s picture

jrockowitz commented
StatusFileSize
new Screen Shot 2016-10-05 at 3.38.26 PM.png15.91 KB

So the below example isolates the specific issue which is Excel is interpreting the dash as a formula.

Column1,Column2
"-a", "-One'
"- A","- One"
="-a", ="-One'
="- A",="- One"

Display as ...

This seems super frustrating to fix. This might be why Webform provides a dedicated export to Excel feature.

lomale@bluewin.ch’s picture

lomale@bluewin.ch commented

Yes I got to the same point.

This means never use extra signs like hyphen's in front of the Option text. It could have fatal impact on further processes like export.

jrockowitz’s picture

jrockowitz commented

I am going to have do some major reworking of the result exporting to get an Excel friendly export format working.

I am leaning toward generating an HTML table which can be easily imported into Excel (this is an old school trick). I am not up for writing an export plugin that generates Excel XML markup. Once I refactor the export handling, someone else could write an Excel XML exporter.

jrockowitz’s picture

jrockowitz commented
Status: Needs work » Needs review
StatusFileSize
new Screen Shot 2016-10-14 at 8.52.32 PM.png43.87 KB

I don't have Excel support working but you can now export the data as HTML table which can be imported into Excel.

jrockowitz’s picture

jrockowitz commented
Status: Needs review » Fixed

I created #2822560: Provide Excel submission exporter to address this issue. For now, I recommend using the HTML table exporter.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.