Do you want to export the entries from your WordPress forms? Downloading an export file lets you view form entries in other programs, such as Excel or Google Sheets.
In this article, we’ll show you how to export form entries in WPForms.
- Exporting Multiple Form Entries
- Exporting a Single Entry
- Frequently Asked Questions
Note: If you have not collected any entries yet, you can preview your form and submit a test entry to try out the entry export feature.
Exporting Multiple Form Entries
To export multiple entries at once, you’ll first need to go to WPForms » Tools and click on the Export tab.
Once the Export tab is open, you’ll see the Export Entries section right at the top. Use the dropdown to choose which form’s entries to export.
By default, your entries export file will include all the fields in your form. Below the dropdown, you can uncheck any boxes for fields you want to exclude from your export file.
Including Additional Information in Your Export File
Next, you may select the checkbox(es) for any additional information you want to include in your export file.
These options include:
- Entry ID: The unique number assigned to each entry.
- Entry Date: When the user submitted the entry.
- Entry Notes: Details you’ve manually added to individual entries. For more details, see our documentation on adding notes to form entries.
- Viewed: A status indicating whether you’ve previously opened the individual entry in your WordPress admin area. Unread entries are indicated on the Entries page with a green circle.
- Starred: A status indicating whether you manually starred an individual entry.
- User Agent: Details on the browser used to submit the entry.
- User IP: The user’s IP address.
- Unique Generated User ID: A unique, random value assigned to each user who submits a form (regardless of whether or not they are logged in).
- Payment Status: Whether a payment submitted through your form is pending or completed. This data is only available if you’ve installed and activated the Stripe, Square, Authorize.Net, or PayPal addon and turned on payments for this form.
- Payment Gateway Information: Includes details such as which payment gateway was used, as well as the payment total, currency, and transaction number. This data is only available if you’ve installed and activated the Stripe, Square, Authorize.Net, or PayPal addon and turned on payments for this form.
- Include data of previously deleted fields: Values for fields that you deleted at some point in the form’s history.
- Geolocation Details: General location information for the user who submitted the entry. This data is only available if you’ve installed and activated the Geolocation addon.
Exporting Entries as a Microsoft Excel File
In the Export Options section, you can choose whether to format your entries as a Microsoft Excel .xlsx file by checking the box provided.
If you leave this box unchecked, your entries will be formatted as a CSV file.
Customizing Your Entries Export File
You may also choose to restrict which entries you want to export. The Custom Date Range option lets you set start and end dates to determine which entries to include in your file. WPForms will only export entries with submission dates falling within the specified range.
The Search fields enable you to select entries to export based on the contents of a specific field, the Entry ID, the contents of the Entry Notes, the user IP address, or the User Agent.
For example, you could use the Search fields to export only contact form entries with a message containing the word “help.”
Downloading Your Export File
Once you’ve decided which details you’d like to include in your export, go ahead and click the Download Export File button. The download should begin immediately.
By default, most browsers will save any downloaded files to your computer’s Downloads folder.
Exporting a Single Entry
Sometimes, you may only want to export a single entry. To do so, go to WPForms » Entries and select the name of the relevant form.
Then click the View link to open the page of the specific entry you wish to export.
In the right sidebar of the individual entry’s page, you’ll see a list of Actions you can apply to this entry. From this list, select Export (CSV) to download this entry in CSV form, or the Export (XLSX) option to download this entry in an Excel format.
Once you click one of these export options, the download should begin immediately.
Frequently Asked Questions
These are some of the top questions we receive about exporting form entries.
Can I import WPForms entries from another site?
At this time, we do not offer a way to import WPForms entries.
Can I export my entries from WPForms Lite?
WPForms Lite currently does not enable users to store or export entries. However, you can set up form notification emails to send form submissions to your preferred email address.
With any paid WPForms license, you’ll be able to store and export future entries (i.e., entries created after you’ve installed your paid WPForms plugin).
Some of my entries’ characters come out garbled when I open the export file in Excel. How can I fix this?
In most cases, this is caused by special characters within the entry being improperly encoded in the CSV file. To fix this, be sure to use the Microsoft Excel (.xlsx) option in the export settings to ensure the correct file encoding.
Or, if you’d prefer to stick with a CSV file, be sure to use UTF-8 encoding when opening your file in Excel.
When downloading my export file, I received the following error: “There were problems while preparing your export file. Please recheck export settings and try again. Unknown request.” How do I fix it?
If you see this error when attempting to export your form’s entries, please first make sure that you are using the latest version of WPForms. Then try exporting your form’s entries again.
If the problem persists, there may be a file permissions issue that is preventing WPForms from exporting your entries. Typically, this means that your user account does not have access to certain files or directories. This may be due to restricted or incorrect permissions.
For self-hosted WordPress sites, you can easily fix the issue by following this guide for fixing WordPress file and folder permissions.
If you do not have direct access to the server, please reach out to your hosting provider for help fixing this problem.
That’s it! Now you know how to use the Entries Export tool in WPForms.
Next, would you like to find out more about other tools available for form management? Be sure to check out our guide to form entries, where we’ve answered all the most common questions about form management options.