WPForms Blog

WordPress Tutorials, Tips, and Resources to Help Grow Your Business

How to Export WordPress Form Entries to CSV

How to Export WordPress Form Entries to CSV

by Courtney Robertson on Aug 15, 2016

Do you want to download the entries from your WordPress forms to a software-ready format? With WPForms, you can download these form submissions into a CSV spreadsheet. In this tutorial, we will show you how to export WordPress form entries to CSV.

What can you do with a CSV file?

A CSV file is useful for many different things. CSV, short for comma-separated values, is a file type that can be understood by spreadsheet programs such as Microsoft Excel or Google Sheets. Aside from reading the data in spreadsheet software, you can use it in other ways:

  • It can be imported into other form plugins.
  • You can add the contact information to your email marketing software.
  • Spreadsheet software can help you analyze the results of advanced form fields or surveys.
  • CSV files can be used to create mail-merges in word processing programs.

Getting Started:

The first thing you need to do is install and activate the WPForms plugin. Here’s a step by step guide on how to install a WordPress plugin.

Once you have activated the plugin, let’s go ahead and create a new form.

You can do this by going to WPForms » Add New.

Add New WPForm

On the next screen, you need enter your form name and select from one of our pre-built form templates or start with a blank form.  For this tutorial, we will begin with a simple contact form.

How to create a simple contact form

In the form builder, simply drag and drop the fields you want from the left column.

You can click on each field to customize the settings. To rearrange the fields, hover your mouse on the far right side and simply drag to reorder.

Once you are done customizing the field, click on the Save button to make sure that your changes are saved.

Add the Simple Contact Form in WordPress

WPForms allow you to add your forms in various locations from your blog posts, pages, and your sidebar (widget-ready areas).

First let’s take a look at the most common post / page embed option. Start by creating a new post or page in WordPress and then click on the Add Form button there.

Insert simple contact form into page

After that simply publish your page and view it.

Below is an example of our simple contact form:

Published Contact Form

Export WordPress Form Entries as a CSV

After you have published your form and gathered some entries, you’re ready to download these entries.  Begin by going to WPForms » Entries in your WordPress admin dashboard.

Next, in the top right corner select the form you want to download entries from then select Download Export (CSV) in the top area of the screen.

How to Export WordPress Form Entries to CSV

Now you can select where to save your CSV file on your computer.

That’s it. You have successfully downloaded your WordPress form entries. We hope this article helped you export WordPress form Entries to CSV. You might also want to check out our guide on How to Create a File Upload Form in WordPress.

If you like this article, then please follow us on Facebook and Twitter for more free WordPress tutorials.

Comments

  1. Would it be possible, either now or in the future, to display a column of entries on a webpage? In other words, if 12 people sign up for my event using a form, can I then post the entries “Name” column (data) to live update on a webpage so that participants can see who has already signed up?

    1. Hi John,

      Great question. We don’t currently have any built-in way to display your form entries or select portions of entries. I can definitely see the value of this feature for tons of scenarios, though, and it’s on our list to add in the near future!

    1. Hi Mike,

      Yes, that’s correct. Due to the rules of WordPress.org, our Lite version doesn’t actually store any entries to the database — so entries can only be stored in this way when collected with our Pro version. With Lite, entries are kept only in the notification email that gets sent. Sorry about any confusion with this, and I hope that helps 🙂

  2. Hello! I am interested in making the jump to WPForms! My current form builder solution allows me to provide a submission download URL to whomever needs to see submissions. The download URL supplies a fresh CSV each time. Is this something that is currently built-into WPForms? Please tell me yes!

    1. Hi Ryan,

      For our plugin CSV exports are only available to admin site users, mainly as a security measure. We do have code to easily open access up to Editor roles, though they’d still need to log into the site to be able to download a CSV export.

      If you have any other questions about this, please feel welcome to get in touch 🙂

  3. Hello! Is there any way to customize which fields show up on the csv file? I am imported it into an Access database and don’t want to have to delete the fields I don’t want to store. Thanks!!

    1. Hi Heather,

      We don’t currently have any ability to customize what fields are included in a CSV export, but I’ll go ahead and note that as a feature request. For now, the workaround is to delete those fields after import as you mentioned.

      Thanks for the suggestion! 🙂

    1. Hi Raph,

      Great questions. Some data, like the Status column, is generally dynamically pulled based on communication with an integration like Stripe or PayPal. The CSV export doesn’t include it because this data isn’t stored in the same way as the other entry contents. I agree it would be super useful to be able to include this type of information though, and we’ve gotten a couple similar requests. I’ll make note of your request as well, and we’ll keep this in mind to consider down the road.

      Thanks for the suggestion! 🙂

Add a Comment

We're glad you have chosen to leave a comment. Please keep in mind that all comments are moderated according to our privacy policy, and all links are nofollow. Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.