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
| Keyword | Avg. monthly searches | Competition | Top of page bid (low range) | Top of page bid (high range) |
|---|---|---|---|---|
| Keyword | Avg. monthly searches | Competition | Top of page bid (low range) | Top of page bid (high range) |
Our 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.
Advanced Number Field
Functionality for Number Fields, like rounding or only absolute numbers, fixed point notation, range calculation, custom units like % or m2 & show as slider.
Entry to Database
Integrates Gravity Forms with internal or external databases, offering flexible mapping of form fields to database columns and real-time synchronization between entries and database rows.
Advanced Merge Tags
This Gravity Forms Add-On adds extra Merge Tag modifiers (and a lot of power). From the most common used functions like capitalize and length to changing date formats.
Read tutorials about
Show Previous Gravity Forms Submissions Using Advanced Merge Tags
This step-by-step tutorial shows how to use GravityWP Advanced Merge Tags to count previous Gravity Forms submissions and calculate total submitted value based on a matching email address.
Gravity Forms LeadConnector Integration with OAuth 2.0
This documentation-based tutorial explains how to connect Gravity Forms to LeadConnector/HighLevel with OAuth 2.0, search contacts by email, and map returned CRM values back into form fields using GravityWP API Connector.
Gravity Forms Zoho CRM Integration: How to Auto-Populate Form Fields by Email
Learn how to auto-populate Gravity Forms from Zoho CRM using GravityWP API Connector. This tutorial shows how to search Zoho Contacts by email and fill form fields with the returned data.
How to Create a Public Submission Business Directory in WordPress (Gravity Forms + GravityView)
Build a moderated business directory where users submit listings through a form, admins approve entries, and approved businesses appear in a searchable GravityView directory.
