Exporting data from a form in Excel

  • crb3024
    Asked on February 1, 2021 at 5: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

  • Bojan Support Team Lead
    Replied on February 1, 2021 at 7:07 AM

    Greetings Bob.

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

    screenshot 3541 Screenshot 10

    Let us know if this resolved your problem.

  • crb3024
    Replied on February 1, 2021 at 7: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.

  • Bojan Support Team Lead
    Replied on February 1, 2021 at 8: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 Screenshot 10

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

    screenshot 3544 Screenshot 21

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

    screenshot 3545 Screenshot 32

    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.