With GravityView and the addon DataTables it gets really easy to export data from Gravity Forms directly to Excel. Ofcourse, Gravity Forms offers the possibility to export data in a .CSV format. But you probably also want the option to download directly to an Excel format from the front-end of your website.
Create New View & Choose for DataTables
Choose the Fields you want in your View
In de Entries Fields you can choose for visible fields. These fields will also be available for download in Excel after you save the View. After selecting the columns for Excel, you can change the Label names. These new Label Names will be used as Column Names in Excel.
Choose Excel as one of the Download Options
On the left side of the Create View page, you have tab with DataTables Settings. Choose here under ‘Display Buttons’ for XLS.
View online and download Entries to Excel
After these steps, you are ready to publish your View on your website. As you see, you have a few options to Download the data which is shown in DataTables. Click on XLS to download the visible data in Excel. If you filter the results, you can download the filtered results in Excel.
Demo DataTables
, Example data – DatatablesOur Premium add-ons for Gravity Forms
List Text
Add features like textarea, placeholder and custom validation to a column or multiple columns in a Gravity Forms List Field.
Update Multiple Entries
Trigger the update of multiple entries in a target form by submitting an entry in a trigger form.
DateTime Field
The GravityWP - DateTime Field add-on adds a dedicated Date/Time field to Gravity Forms so users can enter both a date and a time in a single input.
Dynamic Labels
One form, different questions: field labels and texts come from another form's entry, such as a grant, vacancy or course.
Read tutorials about
How to Create an Event Registration Form for Workshops
Create an event registration form for workshops in WordPress. Learn which attendee details to collect, how to configure confirmation emails and how to update workshop dates for confirmed registrations using GravityWP Update Multiple Entries.
How to Create Gravity Forms Entries from Comma-Separated Text
Turn a comma-separated task list into separate Gravity Forms entries. Follow our tested Field to Entries setup, mapping, and custom separator example.
How to Validate Repeatable Contact Rows in Gravity Forms
Learn how to validate repeatable Gravity Forms List field rows with GravityWP List Text. This tutorial shows how to add email and regex validation, test invalid values, and confirm that valid team roster data is stored correctly.
Gravity Forms Airtable Integration: Create Records From Form Submissions
Learn how to build a Gravity Forms Airtable integration with GravityWP API Connector. Send form submissions to Airtable, create new records automatically, and save the returned Airtable Record ID and response back to Gravity Forms.
