Looking for a way to export form entries in WordPress? With the right plugin, you can export to Excel, CSV, or XML with just a few clicks!
Approximate read-time: 4 mins
If you are looking for a way to export form data from WordPress, it pays to use the right form builder. If your form plugin doesn't have easy options to export WordPress form entries, then you may be facing a challenge.
Before we show you an easy way to take control of your form submission data, let's see if you can access your existing form data. The first thing is to check your form builder. Many plugins come with the option to export data built-in. Look for that first!
If you are using a free form builder plugin, make sure that the feature is included in the free version. It might be that the feature is only included in the premium version of the plugin you are using.
Your form data might be saved in your WordPress database, even if there is no export option. Here's the problem: it might be very challenging to crack into the WordPress database and piece it all together. Plus, the risk of breaking your site would be high.
Don't worry though - there is a better way.
How to use WordPress to export form entries
As promised, we do have another solution that will work for you going forward. Your WordPress forms can export to Excel, CSV, or XML without any extra work. Read on to learn how you can control your WordPress form submissions the easy way!
Step 1: Install & activate Formidable Forms
This part is easy. Download the free version of Formidable Forms. You can search for it just like any other plugin you would add from your WordPress admin section.
With Formidable, it's easy to export your data. You can export Forms, Entries, Views, and Styles from the Formidable Import/Export page. The exported data can be uploaded to sites that use Formidable as well.
If you want your WordPress forms to export to CSV or Excel, you can do that too. We'll show you how below!
Step 2: Create and publish a form
Once you've installed Formidable, we just need to make a contact form for testing purposes.
From your WordPress admin, go to Formidable → Forms and click Add New.
From there, click Create Form and give your form a name.
Now you should be in the Formidable form builder. All you need to do here is drag some form fields from the left column over to the right form-building area.
You'll probably want to include a Text field, an Email field, and a Paragraph text field if you are building a contact form. Feel free to play around here for a while, then we'll move to the next step!
Step 3: Attach a form CSV to emails
This step is completely optional. Attaching a CSV of the form submission to emails can improve workflows, enable automations, and backup and automatically export data.
To include the form export to CSV, go to the form Settings → Actions & Notifications tab. Select the Email Notification action to edit the existing email, or click the Send Email icon to add a new notification.
Now, click the toggle to Attach CSV export of entry to email. The rest will be automatically handled for you.
Step 4: Export your form data
In Formidable, we have a dedicated entries page where user data and form submissions are stored. Remember the contact form we just created? Once that has a few entries, they will be stored here too.
For testing purposes, we can actually create a few fake entries. Click on the Entries tab and click on the Add New button. Your contact form will appear - so fill it out a few times!
After that, here are the steps to follow to export your data:
- Go to the Formidable → Import/Export page.
- Choose your Export Format. If you want your download your entries to CSV:
- Pick the type of Data you want to export. In the free version of Formidable, you can only export form data (more on that later).
- Choose your newly created contact form.
- Click Export Selection. Then your browser will download the data as a CSV file. Voila! Your WordPress contact form has exported to CSV (or whatever format you happened to choose).
Once you have your exported CSV, you can open or import it in whatever software you need. This includes Google Sheets, Microsoft Excel, and more.
Want an even simpler way to export your form data?
The above method works great.
But, what if you want an even simpler way to send your form data to a spreadsheet?
Well, now you can! With Formidable Forms Google Sheets add-on, sending your form data straight to a custom spreadsheet on Google Sheets is easier than ever.
Before, you need extra plugins and extra fees. Now, Formidable does it all natively. No extra plugins needed.
So there you have it. Exporting entries could be as simple as clicking the download button. All you need is a WordPress form plugin with CSV export functionality. Or in the case of Formidable forms, XML and Excel exports too.
Alternatively, you can setup a custom listing table on a website to export entries to Excel.
If you want even more export options, be sure to look into the premium version of Formidable Forms. There's more info about the extended features on our form export documentation page.
We hope this article has helped you out. Stay tuned to the Formidable Forms blog for all things WordPress - forms and beyond.