How to Export WordPress Form Entries to CSV

How to Export WordPress Form Entries to CSV (Step by Step)

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 article, we’ll 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:

WPForms is the best WordPress Form Builder plugin. Get it for free!
  • 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.

Thinking about adding a blog to your site? Check out this list of the top ways to use WordPress to make money blogging.

Step 1: Create a WordPress Form

The first thing you’ll need to do is install and activate the WPForms plugin. For more details, see this step by step guide on how to install a plugin in WordPress.

Next, go to WPForms » Add New to create a new form.

On the setup screen name your form and select the template you want to use, depending on the type of form you’re creating.

For our example, we’ll choose the Simple Contact Form template.

Simple Contact Form Template

WPForms will create a simple contact form.

Simple Contact Form

Here, you can add additional fields to your contact form by dragging them from the left hand panel to the right hand panel. With the simple contact form template, you’ll already have the Name, Email, Comment or Message form fields.

Then, click on any of the form fields to make changes. You can also click on a form field and drag it to rearrange the order on your contact form.

For help configuring the rest of your form’s settings, check out this tutorial on creating a simple contact form in WordPress.

Click Save.

Still collecting data using Google Forms? You don’t have to! Check out this list of the best Google Forms alternatives.

Step 2: Add the Simple Contact Form in WordPress

WPForms allows you to add your forms to many locations on your website, including your blog posts, pages, and even sidebar widgets.

Let’s take a look at the most common post/page embed option.

To start, create a new post or page in WordPress and then click on the Add Form button.

Next, select your contact form in the modal popup and click Add Form.

Add Form

Then, publish your post or page so your contact form will appear on your website.

Below is an example of our simple contact form:

Final Contact Form

Make sure to take a look at these shocking digital marketing statistics for some facts that may help your business online.

Step 3: Export WordPress Form Entries as a CSV

After you’ve 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.

Form Entries

Once you’ve chosen your form, click the Download Export (CSV) link.

Download Export (CSV)

You’ll then be able to select whether to save your CSV file on your computer or open it up for viewing.

And there you have it! You now know how to 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 so you can let people upload files to your forms.

So, what are you waiting for? Get started with the most powerful WordPress forms plugin today.

And don’t forget, if you like this article, then please follow us on Facebook and Twitter.

Using WordPress and want to get WPForms for free?

Enter the URL to your WordPress website to install.

Comments

  1. Thanks for reading this article – I hope you found it helpful.

    I wanted to let you know about our new WordPress survey plugin that allows you to build interactive polls and surveys within minutes. You also get best-in-class reporting, so you can make data-driven decisions.

    You can get it 100% free when you purchase WPForms Pro plan.

    Get Started with WPForms Today and see why over 2 million websites choose WPForms as their preferred online form builder.

    Syed Balkhi
    CEO of WPForms

  2. 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 🙂

  3. 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 🙂

  4. 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! 🙂

  5. I’m looking to post the data from a submitted WordPress form on a separate page on my WordPress site. i.e. a password protected user will enter text, images and video which when submitted will be posted or displayed on a separate page on the site. Is this possible in WPForms?

    1. Hi Ron,

      Great question, and the answer depends a bit on how you’d like this to look and work.

      It sounds like our Post Submissions addon might be a good fit — this allows entries to be made into posts on your site. In case it helps, here’s our tutorial where you can get a better idea of how this addon would work.

      Our plugin doesn’t currently have the ability to restrict content (though this is definitely possible when combined with other options like this or this).

      I hope this helps! If you have additional questions, please get in touch and we’d be happy to help 🙂

  6. This is a pre-sales question. I am using a donations plugin (Seamless Donations) that notes the names, donation amount, date, etc. of donors to the site. My client needs this data to be converted to a CSV format for further analysis. And this needs to be schedules at certain intervals. Is this doable by wpforms? How would it work? Thanks.

    1. Hi Marcia,

      We don’t currently have the ability to schedule CSV exports, and this must be done manually as described in this post. I’ve noted this on our feature request list, though, for our team to consider.

      Thanks 🙂

  7. Hi When I export to CSV the address shown is only the first part, eg Box 123,,, building, street province etc don’t appear?
    Am I missing something?

  8. hi
    when i export wordpress form entries to CSV do i lose all the information on wordpress or does it still remain there after i press export. I dont want to lose the info from wordpress.
    thanks

    1. Hi Miriam,

      Great question. No worries — exporting entries to CSV has no impact whatsoever on the entries that are stored on your site. Instead, this process simply produces an additional copy of entry data in CSV format.

      Hope that helps! 🙂

  9. Hi I just upgraded to PRO. I can see two test entries in ENTRIES from my form which was easy to set up and works fine.

    But when I download the CSV file there is nothing in it.

    Instead the first line is this

    
    Fatal error: Call to undefined function apply_filters_deprecated() in /homepages/11/d195938640/htdocs/flamingcow/wp-content/plugins/wpforms/pro/includes/admin/entries/class-entries-export.php on line 290

    How can I fix it? The client needs to access the data easily!

  10. Is it possible to
    1. create a csv automatically each time the form is completed
    2. email this csv to the parties listed in your “Notifications”

    1. Hi Ted,

      We don’t currently have a way to automatically do this, and CSVs must be manually created and emailed. I’ll add your vote for this to our feature request list, though, for our team to consider down the road.

      Thanks for the suggestion! 🙂

    2. I was wondering the same thing – can each form submission’s data be automatically be exported to a csv file
      then downloaded in batches
      I wan to take the data from a customer application and import it all to QucikBooks Online as a customer
      Also, I don’t see the download button when I go to forms on my dashboard and open contact form. I’d like to try exporting the 400+ contacts on there as a test run.
      Trying to compare WP form to Gravity form and a couple others cause am rebuilding our WP web site.
      Thank you
      Patrice

      1. Hi Patrice,

        We don’t currently have a way to auto-export to CSV, though I’ve noted this on our feature request list. And for any issues or questions about CSV exports, we’d be happy to assist! Please get in touch with our support team and we’ll help you get that sorted.

        Thanks! 🙂

      2. Let me add a +1 for this feature request. We are going to use WPForms for our Intranet and would love for the results to go directly to an individual as a .csv file. While I understand these can be downloaded, it would really come in handy. Thanks for the consideration!

  11. HI! I was wondering if there was a way to only download the newest entries in the csv file, instead of the entire csv every time I want to update my lists? any help you can offer would be appreciated!

    1. Hi Jarred,

      We don’t currently have a way to select just a few entries at a time for CSV export, though this is on our feature request list for consideration. If you’d like, however, you can download a CSV of a single entry at a time. That way, you would be able to quickly merge the new data into an existing file/spreadsheet. Here’s our tutorial with details on how to do that.

      I hope this helps! 🙂

  12. Hello,

    I never got an email notification when I signed up to the WPLite form as a test. Now it seems to get entries I have to pay? This really feels like a trap. If I can’t evaluate the Entries review in the lite version, and I didn’t get any notifications when people submitted stuff, it is as if my entries are being held hostage until I pay. Is this really what you are doing, or am I missing something?

    1. Hi Misha,

      I apologize for any confusion, and Lite entries are stored only to the notification email that’s sent. If you decide to upgrade at any point, you’d be able to store new entries to your site. However, notification emails are included within Lite so it sounds like you’re running into email delivery issues (this is when the email is sent, but something prevents it from delivering successfully).

      We’ve shared all of the details on why this happens, and how to fix it, in this tutorial.

      I hope this helps! If you have any questions, please know we provide limited complimentary support to Lite users in our Lite support forum. Thanks!

    1. Hi Dimitrios – We don’t currently have a way to do this automatically, but I’ve noted that on our feature request list for consideration 🙂

  13. Definitely looking for a way to schedule the CSV export. Weekly, monthly – some interval to allow us to confirm all email notifications were received, without having someone manually retrieve it. So hopefully it’s high on your feature update list, or you can recommend an additional plugin that would allow us to do that. Recently switched from Contact Form 7 as I thought this had a nicer interface but seems CF7 has more add-ons.

    1. Hi CF,

      We don’t currently have a way to schedule an export like this, but I’ve noted your request for this on our feature request list for possible consideration. Thanks for the suggestion!

      In case your goal is to use the CSV to add entry details to a spreadsheet, you might consider integrating your forms with Google Sheets. This option can be super useful, as it automatically adds all new entries to a spreadsheet.

      If you have any questions about this, please get in touch. Thanks!

  14. Is it possible to export any notes added to entries after submission? It seems a little odd that the note doesn’t export after being added via the form entries page.

  15. Currently, our WP Form exports a Name (First name, last name) which does not give us the ability to sort on Last name. I don’t see anything in this tutorial that shows me how to change this.

  16. Hello,

    When I click on Download Export (CSV), the file created is all messed up.
    All my fields are on one line and the “answers” are on the line under. No columns, no space at all.

    Do you have any idea on how to fix this ?
    Thanks !

  17. Hi,

    With the Pro version, when creating a form with signature, would it be possible to export all the data gathered, including the digital signature, to an excel/csv file?

    1. Hi Somroth,

      Currently when you export entries as CSV file, the signature will be exported as a link to the signature image that is stored on your site and not the image itself. We don’t have a way to do this right now, but I’ve made a note on our feature request list so we can keep it on our radar! Thanks for the suggestion 🙂

  18. When I export to CSV, name feald is empty, it export only last name and all others feald.And CSV file do not recognise cyrilic font….

    1. Hi nemanja,

      We’d be happy to help! When you get a chance, please drop us a line in support so we can assist.

      Since it sounds like you have a WPForms license, you have access to our email support, so please submit a support ticket.

      Thanks 🙂

  19. Hi, so I’m considering an upgrade based strictly on the ability to download to a CSV file. I’m starting a contest that will have over 1,000 entries and I need to keep all this info. My question is, does the Basic version include this feature? I didn’t see it specifically named on the feature list and I don’t want to upgrade if this feature isn’t there. Thank you.

    1. Hi Geoff,

      Yes, exporting your entries as a CSV file is available with all of our paid licenses, from Basic to Elite. 🙂

  20. I am running a report off entries for my stakeholders to apply to our call center. Is there anyway to have the entries export as a dynamic excel sheet they can refresh themselves so I don’t have to pull the data each time they want an update?
    thanks!

    1. Hi Bryan,

      We don’t have a way to do this right now, but I’ve made a note on our feature request list so we can keep it on our radar! Thanks for the suggestion 🙂

  21. How can we export Transaction ID info for each payment made using WPForms and stripe? I can see the Transaction ID for CC payments when looking at individual entries through WordPress but it is not included in the .csv export file.

    I followed this guide to be able to view the transaction ID in WPForms but we need to be ale to export this data for accounting purposes.

    https://wpforms.com/developers/display-table-of-paypal-stripe-transaction-details/

    1. Hi Leslie,

      We don’t have a way to do this right now, but I’ve made a note on our feature request list so we can keep it on our radar! 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.