https://legacy.forums.gravityhelp.com/topic/can-the-fields-in-a-list-export-in-separate-colums Gravity Support Forums Topic: Can the fields in a "list" export in separate colums? en-US Sun, 19 Apr 2026 22:06:04 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/can-the-fields-in-a-list-export-in-separate-colums#post-87023 Sat, 03 Nov 2012 10:17:18 +0000 VSC 87023@https://legacy.forums.gravityhelp.com/ <p>I think that will work, thanks Chris! </p> https://legacy.forums.gravityhelp.com/topic/can-the-fields-in-a-list-export-in-separate-colums#post-85404 Tue, 30 Oct 2012 23:53:46 +0000 Chris Hajer 85404@https://legacy.forums.gravityhelp.com/ <p>I replied to your email with my configuration for OpenOffice.org. Let me know if the information is helpful for what you're trying to do. </p> https://legacy.forums.gravityhelp.com/topic/can-the-fields-in-a-list-export-in-separate-colums#post-85224 Tue, 30 Oct 2012 11:43:39 +0000 VSC 85224@https://legacy.forums.gravityhelp.com/ <p>Hi Chris,</p> <p>I just sent it. The subject is "Export sample."</p> <p>Thanks! </p> https://legacy.forums.gravityhelp.com/topic/can-the-fields-in-a-list-export-in-separate-colums#post-84522 Mon, 29 Oct 2012 00:01:27 +0000 Chris Hajer 84522@https://legacy.forums.gravityhelp.com/ <p>Can you send me a sample of the export you're using? Please send it to <a href="mailto:chris@rocketgenius.com">chris@rocketgenius.com</a> </p> <p>Sounds like, as David mentioned, that you can use both comma and pipe as delimiters in your import, and it would split on both of those delimiters, so you would get all the fields separated by commas into separate columns and also the list field, split into multiple columns, by the pipe delimiter. You will have to configure Excel to use both delimiters when you first go to import the CSV. </p> https://legacy.forums.gravityhelp.com/topic/can-the-fields-in-a-list-export-in-separate-colums#post-84293 Sat, 27 Oct 2012 14:35:50 +0000 VSC 84293@https://legacy.forums.gravityhelp.com/ <p>It currently separates each column by this: |</p> <p>But it's still all in one Excel column. I really need each column from the list to be separated into a separate Excel column... </p> https://legacy.forums.gravityhelp.com/topic/can-the-fields-in-a-list-export-in-separate-colums#post-84029 Fri, 26 Oct 2012 14:18:47 +0000 David Peralty 84029@https://legacy.forums.gravityhelp.com/ <p>When you import it into Excel, you should be able to set it up to also have a second separator, so not just the comma, but also the pipe character or whatever it is currently set to be. Would that work okay for you? </p> https://legacy.forums.gravityhelp.com/topic/can-the-fields-in-a-list-export-in-separate-colums#post-84008 Fri, 26 Oct 2012 12:21:10 +0000 VSC 84008@https://legacy.forums.gravityhelp.com/ <p>Hello everyone,</p> <p>I've set up a form with a list where people can submit their team roster. The fields in my list are:</p> <p>Player Number, Player Name, Team Name, Address, etc...</p> <p>When I export the entries from that form, it treats the data as one column in excel, rather than give each field its own column. I'd like Player Number, Player Name, Team Name, Address, etc... to export to separate columns in Excel. Is this possible? </p>