Exporting data from a form in Excel

  • Profile Image
    crb3024
    Asked on February 01, 2021 at 05:25 AM

    On this form I collect registrations for a charity walks event. There is one set of data - call it Header -(eg the person making the registration and the payment details) and multiple (1 or 2 now but this will be extended to 10) sets of data for each Entrant.

    I would like to receive this on a spreadsheet and ideally with one spreadsheet row per Entrant with the Header repeated on each.

    Could you please advise which integration app would be most suitable?

    Bob Keightley

  • Profile Image
    Bojan_J
    Answered on February 01, 2021 at 07:07 AM

    Greetings Bob.

    You can download the Excel file with all information from the Tables:

    screenshot_3541.png

    Let us know if this resolved your problem.

  • Profile Image
    crb3024
    Answered on February 01, 2021 at 07:31 AM

    Hi Bojan

    Thanks for that but how do I get to the screen you displayed?

    Would any of the integration apps give me more flexibility? As I said, I would like to set it up so that I get one spreadsheet row per Entrant with the Header repeated on each.

  • Profile Image
    Bojan_J
    Answered on February 01, 2021 at 08:51 AM

    My apologies.

    If you are in the form builder, you can open Tables from the upper left corner of the page:

    screenshot_3543.png

    If you are on the My Forms page, you can open it from the More dropdown:

    screenshot_3544.png

    You can also click on the submission number underneath the form name:

    screenshot_3545.png

    Each entry will be saved as a new row in the table. You can only add a field from the form, static test won't be shown.

    Let us know if you have any additional questions.