https://legacy.forums.gravityhelp.com/topic/commas-in-export-data Gravity Support Forums Topic: Commas in export data en-US Mon, 20 Apr 2026 08:22:50 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/commas-in-export-data#post-61118 Fri, 01 Jun 2012 09:36:18 +0000 David Peralty 61118@https://legacy.forums.gravityhelp.com/ <p>The only way to know if any of those programs will open it by default is to test it or search Google to make sure. I definitely don't know off hand if Excel, OpenOffice or LibreOffice will open a semicolon as a delimiter by default. </p> https://legacy.forums.gravityhelp.com/topic/commas-in-export-data#post-61107 Fri, 01 Jun 2012 09:22:48 +0000 haylc 61107@https://legacy.forums.gravityhelp.com/ <p>OK so it works if I tell the program to use a pipe as the delimiter. My problem is that there are about six different admins who will all be exporting form data, and I know this will end up causing a lot of confusion. If I set the delimiter to a semicolon (or a tab, if that's possible?) rather than a pipe, do you know if Excel, OpenOffice Calc etc will recognise that by default, without having to change it in the program settings?</p> <p>Thanks heaps. </p> https://legacy.forums.gravityhelp.com/topic/commas-in-export-data#post-61103 Fri, 01 Jun 2012 09:14:25 +0000 haylc 61103@https://legacy.forums.gravityhelp.com/ <p>Pasted at <a href="http://pastebin.com/8Ei4EzRt" rel="nofollow">http://pastebin.com/8Ei4EzRt</a></p> <p>Thanks </p> https://legacy.forums.gravityhelp.com/topic/commas-in-export-data#post-61094 Fri, 01 Jun 2012 08:49:05 +0000 Chris Hajer 61094@https://legacy.forums.gravityhelp.com/ <p>I suspect though that whatever program you are using to open it needs to be told that the pipe is the field delimiter now, not the comma. In OpenOffice Calc, it looks like this <a href="http://minus.com/mfF7eoPoD/" rel="nofollow">http://minus.com/mfF7eoPoD/</a></p> <p>Uncheck the "Comma" box and check "Other" with your new field delimiter, a pipe in the example I linked to. </p> https://legacy.forums.gravityhelp.com/topic/commas-in-export-data#post-61093 Fri, 01 Jun 2012 08:45:01 +0000 Chris Hajer 61093@https://legacy.forums.gravityhelp.com/ <p>Can you post your functions.php file to pastie.org or pastebin.com so we can take a look? Thanks </p> https://legacy.forums.gravityhelp.com/topic/commas-in-export-data#post-61092 Fri, 01 Jun 2012 08:43:34 +0000 haylc 61092@https://legacy.forums.gravityhelp.com/ <p>Hi, </p> <p>Thanks for the response, although I think I may need some more help here. I've copied and pasted the example code from your link, and now my csv data looks even more strange. It's still separating at the commas, but ONLY at the commas now. Other than the commas, the questions and results are all compressed in a single column, with the pipe and its quotation marks "|" displayed in the cell. Have I done something wrong? I've just copied and pasted the code exactly into functions.php. Happy to email you the csv file if it helps explain things.</p> <p>Thanks. </p> https://legacy.forums.gravityhelp.com/topic/commas-in-export-data#post-61091 Fri, 01 Jun 2012 08:27:13 +0000 Chris Hajer 61091@https://legacy.forums.gravityhelp.com/ <p>Hi. You can use the gform_export_separator filter to use a field separator other than a comma (anything not in your data.) The example on this page shows using a pipe character.</p> <p><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>Let us know if you need help implementing this. The code will be added to your theme's functions.php </p> https://legacy.forums.gravityhelp.com/topic/commas-in-export-data#post-61089 Fri, 01 Jun 2012 07:44:48 +0000 haylc 61089@https://legacy.forums.gravityhelp.com/ <p>Hi,</p> <p>I've just started creating my first form, and I've noticed that if I include a comma in the field label, the csv export data gets all messed up. The question gets broken at the comma, but the responses keep filling every column in the csv file, so the responses end up in all the wrong columns. It would be great to have the columns separated by something other than a comma, or to somehow escape the question with quotation marks etc.</p> <p>I've had a little look on the forums and it looks like the same thing can happen if users include commas in their responses? I'm only just starting out with Gravity Forms so I haven't come across this second problem yet, but I imagine it might be a similar cause/fix. I'm a little confused about the various conversations shared on the forums, so I'm just wondering if you can please share the best way to fix this? I'd rather not have to edit the plugin files, but happy to with a little guidance!</p> <p>Thanks for your help. </p>