PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Can the fields in a "list" export in separate colums?

  1. Hello everyone,

    I've set up a form with a list where people can submit their team roster. The fields in my list are:

    Player Number, Player Name, Team Name, Address, etc...

    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?

    Posted 9 years ago on Friday October 26, 2012 | Permalink
  2. David Peralty

    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?

    Posted 9 years ago on Friday October 26, 2012 | Permalink
  3. It currently separates each column by this: |

    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...

    Posted 9 years ago on Saturday October 27, 2012 | Permalink
  4. Can you send me a sample of the export you're using? Please send it to chris@rocketgenius.com

    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.

    Posted 9 years ago on Monday October 29, 2012 | Permalink
  5. Hi Chris,

    I just sent it. The subject is "Export sample."

    Thanks!

    Posted 9 years ago on Tuesday October 30, 2012 | Permalink
  6. 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.

    Posted 9 years ago on Wednesday October 31, 2012 | Permalink
  7. I think that will work, thanks Chris!

    Posted 9 years ago on Saturday November 3, 2012 | Permalink

This topic has been resolved and has been closed to new replies.