Excel Results

  1. elpaulli
    Member

    I have searched the pre-purchased forums and think I have have a good idea, but I just want to follow up and make sure, before purchase. So when you export the results to a spread sheet, each question will be or form will be sorted into their own column and value? Would it be possible to see an example of what the exported form results would look like in excel?

    Thanks

    Posted 6 months ago on Monday November 21, 2011 | Permalink
  2. Gravity Forms doesn't export to an Excel spreadsheet file. It exports to a CSV file, which is a comma delimited file. You then import that CSV file into Excel, Google Spreadsheets, or any other application that supports CSV import.

    CSV is a comma delimited list of the field values for that entry. The field names are output as the CSV headers for each column. When you import it into Excel or Google Spreadsheets it does create a column for each field.

    There isn't really much to see as far as an example goes. A CSV file basically looks like this:

    form field name1, form field name2, form field name3, form field name4
    field value1, field value2, field value4, field value 4
    field value1, field value2, field value4, field value 4
    field value1, field value2, field value4, field value 4
    field value1, field value2, field value4, field value 4

    When you import the CSV into Excel or other Spreadsheet app it then creates a columns and rows out of the data above. Each line is a row, each column is the list of values delimited by a comma. Excel, Google Spreadsheets, etc. knows how to import a CSV so that it takes this data and produces a spreadsheet out of it with columns, rows and values.

    Posted 6 months ago on Monday November 21, 2011 | Permalink

Leave A Reply

You must log in to post.