Published

Updated

How to export multiple Gravity Forms forms to one Excel workbook

Learn how to export entries from multiple Gravity Forms into a single Excel file with separate worksheets using GravityExport Lite (free).

If you’re running multiple Gravity Forms on your site, chances are you’ve needed to pull data from more than one form at a time. Maybe you manage separate forms for different departments, events, or locations.

If you’re exporting each one individually and then manually combining them in a spreadsheet, there’s a much easier way.

With the free GravityExport Lite plugin, you can select multiple forms and download all their entries as a single Excel file, with each form on its own worksheet. No copy-pasting, no juggling files.

I’ll walk you through the entire process step by step.

What you’ll need

Step 1: Install GravityExport Lite

First, we’ll install GravityExport Lite. It’s completely free and available from the GravityKit website.

  1. Log in to your WordPress admin dashboard
  2. Navigate to Plugins and click Add New
  3. Search for “GravityExport Lite” and click Install Now
  4. Once installed, click Activate

That’s it. GravityExport Lite doesn’t require any configuration. Once it’s active, a new bulk action becomes available on the Gravity Forms page.

Pro Tip

GravityExport Lite is all you need for the basic multi-form export covered in this tutorial. If you need more advanced features like filtering, field selection, or automated delivery, you can upgrade to GravityExport later.

Step 2: Select the forms you want to export

Now we’ll choose which forms to include in the export.

  1. In your WordPress admin, hover over Forms and click Forms
  2. You’ll see a list of all your Gravity Forms
  3. Use the checkboxes on the left to select the forms you want to export

You can pick as many or as few forms as you need. To select all forms at once, click the checkbox in the header row.

The Gravity Forms list page with four forms selected using the checkboxes on the left side.

Step 3: Run the bulk export

With your forms selected, the next step is to run the export. First, click the Bulk actions dropdown at the top of the forms list.

The Bulk actions dropdown and Apply button at the top of the Gravity Forms list.

Next, select Download as one file from the dropdown menu.

The Bulk actions dropdown expanded, showing the Download as one file option highlighted.

Finally, click Apply. Your browser will immediately download a single .xlsx file containing all the entries from your selected forms!

Step 4: Review the exported file

When you open the downloaded Excel file, here’s what you’ll see:

  • Each form gets its own worksheet tab at the bottom of the file
  • Each tab is named after the corresponding form
  • Rows represent individual entries
  • Columns represent the form fields (Entry ID, date, name, email, etc.)
The exported Excel file open in a spreadsheet application, showing entries from the Assets form with four worksheet tabs visible at the bottom.

In this example, we exported four forms (Assets, Assignment Submission, Breakfast order form, and Business Listing). Each one appears as a separate tab, making it easy to switch between datasets without opening multiple files.

Pro Tip

The bulk export creates one worksheet per form. It does not merge entries from different forms into a single combined sheet. If your forms share similar fields and you need the data in one flat table, you’ll need to combine the worksheets manually in your spreadsheet application.

Going further with GravityExport (premium)

The free bulk export covers the basics, but if you need more control, GravityExport (the premium version) adds several powerful features:

  • Automate delivery — Send reports automatically to Dropbox, FTP/SFTP, or local storage.
  • Filter entries with conditional logic — Export only entries matching specific criteria, such as entries from the last 30 days or entries submitted by a specific user.
  • Choose which fields to include — Select exactly which fields appear in each export instead of exporting everything.
  • Split multi-value fields — Break checkbox and multi-select responses into separate rows for easier analysis in pivot tables.
  • Create shareable download links — Generate secure URLs that let team members download the latest report without logging into WordPress.

For a detailed comparison of what’s included in each version, see How is GravityExport Lite different from GravityExport?

Wrapping up

Exporting data from multiple Gravity Forms doesn’t have to mean juggling separate downloads and copying data between spreadsheets. With GravityExport Lite, you can select the forms you need, click one button, and get a single organized Excel file,

Ready to try it? Download GravityExport Lite and start exporting in minutes.

Launch Log march 06

Launch log: Stronger spam prevention, inline editing fixes, radius search improvements

This round of updates brings enhanced spam protection to Gravity Forms Zero Spam, fixes for inline editing of dynamically populated fields in GravityEdit, and targted fixes for both GravityCalendar and the Maps Layout. GravityCalendar v2.14.1 This update to GravityCalendar fixes an issue where calendar…

Read article on Launch log: Stronger spam prevention, inline editing fixes, radius search improvements