Export Excel of all Form Submissions with Fields

SHANE EBERT asked on October 19, 2017 17:28

Hello,

We have over 100 unique forms across different pages/landing pages. How can I easily export all leads from all forms with all the data they filled out?

So far, all I can do is go to contact manaagement and get the Name/IP/Time, but that doesn't help me. I need to know what they submitted in the other form fields.

Thanks

Recent Answers


Brenden Kehren answered on October 19, 2017 17:58

You can export the form data in the Forms app, unfortunately, one form at a time. Another option is to create a query in the Reporting app in Kentico which will get all the data in a tablar format and then export it from there in one sweep for all forms.

0 votesVote for this answer Mark as a Correct answer

SHANE EBERT answered on October 19, 2017 18:01

Thanks Brenden, but I don't know database query language :(

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on October 19, 2017 18:07

Your query would be something like:

SELECT *
FROM form_table_name

You would need a new query statement for every form table. Benefit of using the reporting engine is once you have the query built, you can run the query whenever you want after you have it created. So yes it could get messy but it does work well after you get it setup one time.

1 votesVote for this answer Mark as a Correct answer

Peter Mogilnitski answered on October 19, 2017 23:31

For each form you can simply go to recorded data and click the hamburger menu and choose advanced export:

Image Text

But If you have hundreds of forms you probably will be better off with SQL Management Studio. Right click on Kentico DB, Go to Tasks and then Export data, you'll then see an easy to use wizard.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.