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
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.
JWT Prefill
Fill forms with data you can trust. Prefill Gravity Forms fields with a secure token instead of links with editable url parameters, so your data is accurate, tamper-proof, and ready to use.
List Number Format
With this Gravity Forms Add-on you can change List Field columns into a number field, do calculations within a row or column. Extra merge tags are available with total counts of columns.
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
Gravity Forms Discount Code Field: Apply Fixed or Percentage Discounts in a Form
Learn how to create a Gravity Forms discount code field that applies fixed or percentage discounts. This tutorial shows how to calculate subtotals, discount amounts, and final totals using tested form logic.
Gravity Forms Zoom Integration: Create Zoom Meetings From Booking Forms
Learn how to connect Gravity Forms to Zoom without Zapier using GravityWP API Connector. This step-by-step tutorial shows how to create Zoom meetings from booking form submissions and save the returned meeting details back to Gravity Forms.
Gravity Forms monday.com Integration: Create New Items From Form Submissions
Learn how to connect Gravity Forms to monday.com without Zapier using GravityWP API Connector. This step-by-step tutorial shows how to create new monday.com items from form submissions and save the returned monday.com item ID back to Gravity Forms.
Gravity Forms Pipedrive Integration: Send Form Contacts to Pipedrive Without Zapier
Learn how to connect Gravity Forms to Pipedrive without Zapier using GravityWP API Connector. This step-by-step tutorial shows how to send form contacts, custom fields, and the returned Pipedrive Person ID directly from WordPress to Pipedrive CRM.
