How to Save Your Contact Form Data in WordPress Database

Want to save your form submissions in your WordPress database? With WPForms, all your entries are stored in two database tables, and you can easily manage your entries from your WordPress dashboard. In this post, we’ll show you how to save your contact form data in your WordPress database, and how to manage your entries from the dashboard.

How Entries are Stored in the Database

WPForms store all form data in two tables within the native WordPress database. They are:

  • wp_wpforms_entries: In this table, the field values for entries are stored.
  • wp_wpforms_entry_meta: This table contains meta information about your entries such as IDs associated and the date that entries were submitted.

Most web hosting providers offer easy to use web applications like phpMyAdmin to manage databases. It allows users to manage their database using a web-based graphical interface.

Let’s take a look at how to view form entries in your WordPress database using phpMyAdmin.

In phpMyAdmin, select your WordPress database and then, click on the table, wp_wpforms_entries.

database table

You can find the form entries in the fields column.

fields column-wordpress database

For more reference, you can read this beginner’s guide to WordPress database management with phpMyAdmin.

How to Manage Entries in WordPress

WPForms allows you to easily access your form entries and manages them inside your WordPress dashboard.

Let’s take a look at how to manage your form entries.

Before we get started, let’s create a simple contact form with WPForms. If you need help, you can refer to this article on how to create a simple contact form with WPForms.

After publishing the form, make sure to add a form entry, so we can access the entry from your WordPress dashboard. Additionally, in your form builder, go to Settings » General and make sure that entry storing in WordPress is not disabled.

enable storing form data in wordpress database

Once an entry is added, you can navigate to WPForms » Entries in your WordPress dashboard to access it.

form entries

WPForms allows you to favorite your entries, mark them as read, and even delete the ones you don’t want.

Under the Actions column, click on the View link to view your form entry.

click view entry management

Here’s how an individual entry will look like. See the screenshot below.

individual entry

If you enjoyed this article, you might also want to read our article on how to export WordPress form entries to CSV.

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

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

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 1 million websites choose WPForms as their preferred online form builder.

    Syed Balkhi
    CEO of WPForms

    1. Hi Kenneth,

      We don’t currently offer the ability to search entries, though this is on our list to consider adding down the road 🙂

      If it helps in the meantime, a quick option is to create a CSV export of entries and run a search within that (you can open the CSV in a spreadsheet program like Excel if that’s easiest).

      I hope that helps! 🙂

  2. Hi!

    For some reason form entries are not displayed in the entry management. I’ve checked that the settings are correct and data should be stored. I checked our site database through phpAdmin and it seems that the “wp_wpforms_entries” is named wp_7_wpforms_entries should the table be renamed?

    Thanks for your help!

    1. Hi Sam,

      A quick thing to try is toggling the activation of the WPForms plugin (deactivating it, then reactivating it). Though pretty rare, every once in a while when a WordPress plugin is activated something doesn’t connect quite right. If that doesn’t do the trick, please contact us in support and we’ll work to troubleshoot this as quickly as possible 🙂

      Also, the datatable name isn’t necessarily a concern, as some sites will alter the prefixes of all tables in their WordPress database as a security measure. If you’re curious, you can see how this is done in this WPBeginner article.

      I hope this helps! 🙂

  3. Hi,
    i like your plugin but one question before purchase.
    i want to store the submitted data into my own database table.
    How can i achieve this?

    1. Hi Azhar,

      It may be possible to do what you’re describing, however we aren’t able to provide support for the use of custom/alternative database tables.

      If you have any other questions, could you please let us know? Thanks! 🙂

  4. I’m ussing the Lite version of the plugin.
    I want to check the entries in my forms but I cannot find those tables in the database. Is there a reason because i don’t see them?

    1. Hi Fernando,

      I’m sorry for any confusion over that — WPForms Lite isn’t able to store entries to the database, and entry details are only stored in the notification email that’s sent out.

      If you decide to upgrade to one of our licenses down the road, the datatables mentioned here will be created and new entries will start being stored there. If you have any suggestions on how we can better clarify this from our current notice in Lite, please let us know.

      Thanks! 🙂

  5. Hi

    I love your plugin but have only used the Lite version so far for a client site.
    I would like to discuss purchasing the Basic option with them as I need to have a record in WordPress of each submission made via the Contact Form. We are having issues with form entries not coming through. I have added a SMTP option but need the records as well o make sure we capture everything.

    Can you please confirm that the above sample where entries are added to WPForms » Entries are part of this Basic package?

    Thank you.

    1. Hi Simone,

      Yes, that’s correct. While WPForms Lite entries are stored only in the notification email that’s sent, all of our paid licenses will store entries to your site’s database as described in this article.

      In case it helps, we’ve recently published a guide to entries that provides tons of details on entry storage and related features.

      I hope this helps! If you have any other questions, please let us know 🙂

  6. I love your plugin but have only used the Lite version so far.
    I have no record of each submission made via the Contact Form. I am having issues with form entries not coming through. I have added a SMTP option but need the records. Should I contact my emailer’s support system to try and retrieve them or are they gone forever

    1. Hi Maya,

      I’m sorry to hear you’re seeing issues with email delivery. Unfortunately unless these emails were sent to spam, the email provider will most likely have no record of them.

      If you need any help getting your SMTP option set up to ensure that all future entries deliver successfully, though, we’d be happy to help — please just let us know in our WPForms Lite support forum.

  7. I would like to see more of the fields in entries page without having to click “view” on each entry. Is there an option of how many fields or which fields to show there?

  8. Hi! Is there a way to export only certain entries to a csv-file instead of all of them at once? Selecting only some of them and then exporting doesn’t seem to work. This is actually crucial to being able to use your product. We have the basic version, I think.

    1. Hi Juuli,

      We don’t currently have a way to select just a few entries for a CSV export, but I agree this would be super useful and it’s on our list of features to consider in the future. I’ve added your vote to that feature request as well. Thanks for the suggestion 🙂

      On the chance that it’s helpful, it is possible to export individual entries to CSV.

      And if you have any other questions, please feel welcome to get in touch with our support team 🙂

  9. Hello, I have WPforms in paid version, I need to use the database to show the records of a form to its user, however, in the table ENTRIES only gives the record in a format. I need to give the user his records of a form.
    Please have information on the use of the database

  10. The code {all_fields} seems only to deliver the name in the notification email.
    If the contact form doesn’t save the data, and the email only contains the name of the
    subscriber, not the rest of the contact page, of what use is WP_Forms free version?

    1. Hi Vince,

      I’m sorry for the trouble, and that’s definitely odd. The {all_fields} Smart Tag should include any field (field label and input value) that the user fills out, just as you’re expecting. This behaves the same way for both Lite and paid versions.

      When you get a chance, please drop us a line in support so we can assist. We provide limited complimentary support in the WPForms Lite WordPress.org support forum.

      Thanks 🙂

  11. Hello,
    Kindly is there anyway to make the form rtl?
    I tried to add it as css feature,but nothing is changed.
    Looking forward your response please.
    Also another question,I’ll be able to retrieve the data in the database to use it for some coding normally?
    Best Regards

  12. hello ,

    I want to try to display the data collected from the form to a table in the site.
    A have a form with a dropdown and a paragraph. In the database there are two same entries but with different entry_id and cannot connect it to wp_datatable. Any ideas?

    1. Hi Antreas,

      I apologize as we’re not able to provide support for custom code. However in case it helps, we do have a developer doc that discusses how to display form entries in a table (you can find that here).

      I hope the tutorial helps! If you have any other questions, please know that you can receive faster and more in-depth support through our private support for paid license holders. Thanks! 🙂

  13. Thanks for the info!

    I have followed the guide in full and the one you see in this course [URL removed], but the steps of the manual installation are different.

    Any advice?

    Thanks!

    1. Hi Esther,

      I apologize, but I don’t understand your question. This blog post is about database storage for WPForms, but it sounds like you’d like to know about installation. When you get a chance, could you please get in touch with our team with some extra details on what you’re looking to do? We’ll be able to assist further from there.

      Thanks! 🙂

  14. Hello! I just found out that the email for notifications was misspelled and have not received notifications for the last month! I am using wp forms light. Is there any way to recover this information??

    1. Hi Emilia,

      In our Lite version, entry details are stored only to the notification email that’s sent – so unfortunately we don’t have a way to recover these previous entries for you. Though it may be a long shot, you could try reaching out to your site’s hosting provider to find out if they keep a log of emails sent out from your site.

      I apologize that we’re not able to help further with this! For future entries/forms, I’d recommend going through our pre-launch checklist. This will help to ensure things go smoothly moving forward.

      And in case it helps, we provide limited complimentary support for all of our Lite users over in our support forum. So if you have any questions about Lite, we’d be happy to assist from there 🙂

    1. Hi Emmanuel,

      Our plugin doesn’t allow for existing form field HTML to be modified, as that would create a lot of potential concerns for functionality. However, you can add HTML within our HTML field (to add images, etc), as well as add your own custom CSS or even some JavaScript.

      Any custom code like this, though, will not be saved with the entry.

      I hope this helps! If you have any additional questions, please get in touch! 🙂

  15. I need a little help,
    I just create 2 forms, and I would like to know before purchase Pro.
    that is 2 forms have a different data store or it is consolidated?
    Could you please explain more?

    Thanks so much

  16. Hello,

    I recently installed the WP Pro version of forms to my website. I followed all instructions and deactivated the Lite version, then activating the Pro version. Upon activation however all the forms that had previously been entered disappeared. This is troubling as the responses were being collected for an awards gala. The responses from the lite version were not going to our email (likely due to the SMTP issues) so we upgraded to PRO with the promise of our forms being available to us (as it states on your document page “How to Upgrade”

    “Don’t worry, all of your forms and settings will stay in place when you activate the paid plugin version.

    Once you’ve activated WPForms, you’ll be taken to a welcome screen with more details to help you get started.”

    Please advise as to how we can retrieve these entries.

    1. Hi Jennifer,

      I really apologize for any confusion with this, however our Lite version is not capable of storing entries to the site. Data for entries collected in Lite is only stored to notification emails that are sent out.

      If you have any suggestions on how we can better clarify this, please share those with our support team when you have a chance. Here’s a screenshot with our current wording from the Lite Entries page.

      And if you have any additional questions or we can assist in any other way, please get in touch with our support team.

  17. I’m receiving no notification emails on the Lite version. I’ve checked that the notification option is set to send to my email address, reentered some tests, and I still get nothing. I gather that any entries made over the last couple months are lost. Is there any way to check or recover them? Is there any way to fix the problem with sending notifications?

    1. Hi J.R. Gerow,

      I’m sorry to hear you’ve been having difficulties with email notifications. WPForms Lite does not store entries and often times these emails can be filtered as spam by email service providers. If that’s the case, you may want to reach out to your site’s hosting provider to find out if they keep a log of emails sent out from your site.

      To resolve email delivery issues like this, we recommend using SMTP to send emails in WordPress. If you need any assistance with this please just let us know in our WPForms Lite support forum.

  18. If I have a huge, multi page form filled out, and by using Pro, saved to the db of my site, what type of email notification will I receive? I’d like a simple “someone filled out a form” type of email, without putting all the form data in the email at all. I only want to log in to view the form data. Is this possible?

    1. Hi John,

      To receive a simple email notification like the one you described, you’ll just need to make sure that the {all_fields} smart tag (and any additional tags for any fields from the form, for that matter) is removed from the form’s notification settings.

      I hope this helps! 🙂

  19. Hi,

    I understand that form entries can be saved to the WP database which is great.

    Is there a way to display form entries on a page with WPForms or should I look for another plugin to do that part?
    For example people submit their favorite quote and these can be seen on the front end and may even be searchable?

    Thank you!
    Julien

    1. Hi Brazroos,

      Unfortunately once entries have been deleted we have no way of recovering them so I’m really sorry for the inconvenience! In case it helps, you may want to check to see if you have any plugins that create backup versions of your site or if your site’s hosting provider can assist you with this.

      Thanks!

  20. Hi, how does this work?
    1. Does this WP form convert all the email to CSV/excel in the basic package?
    2. Currently you all only send emails of the forms, can i still retrieve these information if i buy the basic package now?

    1. Hi Yvonne,

      You can export your form entries as a CSV file with the Basic license level in addition to sending the form entry as an email notification to yourself or even to the person who filled it out.

      Yes, the only emails that can be sent are notifications for the form entries. You can either add a custom message in the notification or include the information that the user submitted. With a paid license, entries are saved to your website so you can always view them by logging into your site and going to WPForms > Entries.

      I hope this helps!

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.