• Skip to primary navigation
  • Skip to main content

GravityWP

The best information about Gravity Forms, GravityView, Gravity Flow and other addons

  • Tutorials
  • Forms
  • Views
  • Workflow
  • PDF
  • Perks
  • Show Search
Hide Search
Erik van Beek

Excel Export Gravity Forms

Erik van Beek · Oct 15, 2017 ·

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.

Download DataTables Add-On Gravity Forms Try the DataTables demo
  1. Create New View & Choose for DataTables
  2. Choose the Fields you want in your View
  3. Choose Excel as one of the Download Options
  4. View online and download Entries to Excel

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

Add something to the DataTables

Here you can try for yourself: just type something in the fields you want to test and click on submit. After it you will be send to a page where you can check your entry. Be aware, the information you type in will be published, so don't share any personal information.

Step 1 of 4

25%
  • Standard Fields

    Choose at random some of the options. It will show you what the Excel file will look like when you select Standard Fields.
  • Type in a number
  • Advanced Fields

    Choose at random some of the options. It will show you what the Excel file will look like for Advanced Fields.
  • Date Format: MM slash DD slash YYYY
  • :
  • Accepted file types: jpg, png, gif.
    Upload here an image (PNG, JPG, GIF)
Download DataTables Add-On Gravity Forms Try the DataTables demo

Gravity View

© 2021 - This website is made possible by the wonderful services of
WordPress, GravityForms, GravityView, GravityWiz, Genesis Framework & WP Engine

  • About
  • Hire GF developers
  • Charts
  • Cheat Sheet