Do you want to create a download link to an Excel file with all your Gravity Forms entries data from a form (or even forms)? Doeke Norg created a wonderful plugin to do exactly that.
Create a download link to Excel
The plugin adds a settings page to your Gravity Form. On this page you can change the General settings:
- See and copy the (secured) download link
- Regenerate the url (sometimes needed when you copy a form)
- Select a Data Range: show only entries within this range in the downloaded Excel
- Enable notes: Includes the entry notes in the Excel (can be very handy when you have a lot of changes and feeds on the entry)
- Order by: Select how you want to order the rows in the excel. You can pick any form field and choose Ascending or Descending
- Create a custom file name for the excel
- File extension: choices are xlsx and csv (comma seperated values, like with the export function in Gravity Forms)
- Attach single entry to notification: attaches the customized Excel file of the current entry to the notification (e-mail)
And you can also change the Field settings:
- Remove fields from the Excel. It will be clearly visible which fields are disabled and you can easily add them back to your Excel download.
- Change the order of columns in the Excel. By dragging fields to a different position, you can change the order of fields in the downloadable Excel file.
Download multiple forms to Excel
An awesome feature of Gravity Forms Entries in Excel is to download entries of multiple forms to Excel. It generates automatically multiple tabs in your Excel file with all the entry date of the form in each individual tab. You can select on the Forms overview page (wp-admin/admin.php?page=gf_edit_forms) the form entries you want to include in the Excel file. Under ‘Bulk Actions’ you will find an extra option: Download as one Excel file.
Plugin settings in Gravity Forms
The Entries in Excel Settings page (wp-admin/admin.php?page=gf_settings&subview=gf-entries-in-excel) gives you some general options for all your generated Excel files.
- Multiple columns: Split multi-fields (like name, address) into multiple columns
- Notes: Enable notes to be included in the Excel by default
- Sections: Include sections as (empty) columns in your Excel file
- File upload: disable or enable file upload links to be included in the Excel file (enabled by default)
- Hyperlinks: Enable hyperlinks on url-only columns (enabled by default)
- Product fields: Export prices as numeric fields, without currency symbol ($) (especially handy when you want to do calculations in your Excel)
- Enabled meta fields: all meta fields are by default enabled.
Review of Gravity Forms Entries in Excel (and possible improvements)
Let’s face it, the plugin is amazing. The plugin is well structured (and excellently coded!), the most important functions are available through a pleasant User Interface (WP worthy) and it really solves a problem / adds value for a lot of users of Gravity Forms. Because of the highly intuitive way in which you can include or exclude data from the Excel, you can make it fully GDPR compliant.
But all plugins that add a functionality to export data could also leak data, so we think a few things could help this plugin even further:
- Make it easier to only make the link accessible for logged-in users (preferably even to specify which kind of user role(s) can have access to the download. This should be available in the general settings (and maybe even forced there) and on form level.
- Add functionality to filter the results in the Excel (based on the general filter rules available in GF). So to be able to only show entries that meet certain filter rules (based on fields inside the form).
- Possibility to add custom excel fields in which you can use Merge Tags and Merge Tags modifiers.
Donate to the developer
We can’t stress it enough: this developer spends a lot of time creating this functionality and answering (very quickly) all questions asked in the plugins support forum. A nice way to say thanks (and let him buy a beer) is to donate something. Click here to donate
Our Premium add-ons for Gravity Forms
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.
n8n Connector
Connect Gravity Forms to n8n and automate your workflows with secure, flexible, and powerful webhooks. Go beyond simple notifications and build advanced, two-way automations.
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.
List Text
Add features like textarea, placeholder and custom validation to a column or multiple columns in a Gravity Forms List Field.
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.
