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.

How to sort export data

Gravity Support Forums » Plugin Support » Gravity Forms

  1. Jens Fleron
    Member

    Hi
    When I export the data from a form and open it with excel all data comes in one column but seperate rows.

    Here´s a pic of how it looks.
    http://img99.imageshack.us/img99/6454/gravityk.jpg

    Does anyone know how I can seperate it to several columns?
    One coulmn for the name, one for the streetadress, one for the mail etc.

    Othervise I don´t know how to work with the data. As a exampel I would like to write a letter in word and use the autoadress function and collect the adress from the CSV.file when I print the letters.

    Posted 14 years ago on Thursday April 29, 2010 | Permalink

  2. Carl Hancock
    Administrator

    The export file is a CSV file, try making sure when you import into Excel that you are letting Excel know it is a CSV file. It should import it properly.

    Posted 14 years ago on Thursday April 29, 2010 | Permalink