https://legacy.forums.gravityhelp.com/topic/csv-export-labels-are-all-in-one-column Gravity Support Forums Topic: csv export - labels are all in one column en-US Sun, 19 Apr 2026 10:12:20 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/csv-export-labels-are-all-in-one-column#post-140615 Sun, 03 Feb 2013 17:23:05 +0000 beedle 140615@https://legacy.forums.gravityhelp.com/ <p>Thanks Chris.</p> <p>Yes, the entry data has always formatted fine for me as well. It's only ever been the header row.</p> <p>I couldn't see what it didn't like either. I did an export and a copy paste into Notepad and resaved (replicating the process that we used via pastebin.com that worked for whatever reason) and that works. Even with what appear to be identical files. So my only thought was something with the encoding?? But that's not something I really fully understand so it's just a guess.</p> <p>Thanks again and let me know if you figure it out.</p> <p>I wouldn't mind the process of a copy/paste/resave, but I want to be easy for the client who may be exporting multiple times along the way. </p> https://legacy.forums.gravityhelp.com/topic/csv-export-labels-are-all-in-one-column#post-139116 Sat, 02 Feb 2013 00:05:56 +0000 Chris Hajer 139116@https://legacy.forums.gravityhelp.com/ <p>Ah, it's better to work with the original file. I have the same issue with the file in Google Spreadsheets now that you do. However, opening it in OpenOffice.org work as expected. Looks like there is something in the file that Google does not like. If you skip the header row, it works fine (if you scroll down, you will see that the first data row is going to import correctly.)</p> <p>I can't see what it is about the first row that Google does not like.</p> <p>I just exported some entries on my server and I have the same experience as you in Google Spreadsheets. I've never tried to open a Gravity Forms entries CSV in Google Spreadsheets, so this is interesting.</p> <p>At least now we can recreate the problem. I will look into some other entry exports and see if we can open those in Google Spreadsheets at all. Sorry for the inconvenience. </p> https://legacy.forums.gravityhelp.com/topic/csv-export-labels-are-all-in-one-column#post-139104 Fri, 01 Feb 2013 23:56:06 +0000 beedle 139104@https://legacy.forums.gravityhelp.com/ <p>Ok. Interesting. I copied the text from pastbin.com like you guys did, saved, and then imported. Worked perfectly. </p> <p>It still does not work with the actual original file however. Or any additional files downloaded directly from the plugin.</p> <p>Here's the actual exported file (with redaction) that still does not work. Can you try it with this one? <a href="http://goo.gl/0TMpZ" rel="nofollow">http://goo.gl/0TMpZ</a></p> <p>Thanks for staying with me on this. </p> https://legacy.forums.gravityhelp.com/topic/csv-export-labels-are-all-in-one-column#post-139052 Fri, 01 Feb 2013 23:06:00 +0000 Chris Hajer 139052@https://legacy.forums.gravityhelp.com/ <p>Most programs require text fields with spaces and possible commas to be double quoted. Your experience is unique. The way Gravity Forms is quoting the fields now is the standard way of doing it.</p> <p>If you want change the field separator, you can do so using the gform_export_separator filter <a href="http://www.gravityhelp.com/documentation/page/Gform_export_separator" rel="nofollow">http://www.gravityhelp.com/documentation/page/Gform_export_separator</a></p> <p>I don't think that is your problem though. Google should be able to handle tab, semicolon, comma, etc.</p> <p>Here is a screenshot of me importing the CSV you posted at pastebin.com previously: <a href="http://minus.com/lbqUf9sQKCup42" rel="nofollow">http://minus.com/lbqUf9sQKCup42</a></p> <p>I didn't have to do anything at all except import, then upload the file, and you can see in the preview that the file will be imported into multiple columns. </p> https://legacy.forums.gravityhelp.com/topic/csv-export-labels-are-all-in-one-column#post-139023 Fri, 01 Feb 2013 22:20:20 +0000 beedle 139023@https://legacy.forums.gravityhelp.com/ <p>One last point, interestingly, Google Spreadsheets seems to remove the quote marks from the fields when Tab is selected as the separator character. Of course it still ends up in one column as we are using commas.</p> <p>I'm wondering, though, if using Tab as the separator would make the export compatible with all systems... assuming there are some that require the quotes. </p> https://legacy.forums.gravityhelp.com/topic/csv-export-labels-are-all-in-one-column#post-139020 Fri, 01 Feb 2013 22:17:03 +0000 beedle 139020@https://legacy.forums.gravityhelp.com/ <p>So I'd thought I'd just try something and removed the quotation marks from the field names only and then save and imported. Works perfectly.</p> <p>The quotes around the entries themselves seem to give it no trouble.</p> <p>Are there systems that require double quotes around the field names? Or can you update the plugin to remove those? </p> https://legacy.forums.gravityhelp.com/topic/csv-export-labels-are-all-in-one-column#post-139013 Fri, 01 Feb 2013 22:13:17 +0000 beedle 139013@https://legacy.forums.gravityhelp.com/ <p>Thank you both for the replies. I'd like to go directly from the CSV into Google Spreadsheets as David indicated he was able to do.</p> <p>I created a very short Screenr video to show you what happens on my system as well as on other computers and using other Google Accounts.</p> <p><a href="http://www.screenr.com/IJn7" rel="nofollow">http://www.screenr.com/IJn7</a></p> <p>David, did you do this in a different way? Either of you see anything in my method that might create an issue? </p> https://legacy.forums.gravityhelp.com/topic/csv-export-labels-are-all-in-one-column#post-136412 Wed, 30 Jan 2013 11:08:25 +0000 Chris Hajer 136412@https://legacy.forums.gravityhelp.com/ <p>I opened your CSV in OpenOffice.org. I changed the delimiter from Tab to Comma and it opened in columns as expected. </p> https://legacy.forums.gravityhelp.com/topic/csv-export-labels-are-all-in-one-column#post-136392 Wed, 30 Jan 2013 10:54:51 +0000 David Peralty 136392@https://legacy.forums.gravityhelp.com/ <p>I just went to Google Drive - Created a new spreadsheet, and Imported the downloaded text file of your data, and it worked flawlessly. I am not sure where the issue lies currently, but the data is formatted correctly, and Google Drive Spreadsheets can import it. </p> <p><a href="https://docs.google.com/spreadsheet/ccc?key=0Anmp832ToqVpdHpPVVMxSm0wQnJBaFY4OVU3QVU5ekE" rel="nofollow">https://docs.google.com/spreadsheet/ccc?key=0Anmp832ToqVpdHpPVVMxSm0wQnJBaFY4OVU3QVU5ekE</a> </p> https://legacy.forums.gravityhelp.com/topic/csv-export-labels-are-all-in-one-column#post-135876 Wed, 30 Jan 2013 02:21:03 +0000 beedle 135876@https://legacy.forums.gravityhelp.com/ <p>Thought the same thing, so rather than use the AUTO function when importing to Google Spreadsheet, I forced COMMA. Same result.</p> <p><a href="http://pastebin.com/s3vTMCc3" rel="nofollow">http://pastebin.com/s3vTMCc3</a> </p>