Aggregating WordPress forms data into a single reliable resource can be a headache. Sure you can export virtually everything as a CSV, but there are some major effective limitations.
- Standard CSV exports can be hard to read and problematic to open
- Users can too easily type CSV separators into input fields, skewing your entire export
- Often you don’t need every field from every form, but a CSV export grabs everything
- Raw submission data can take hours to aggregate manually
Excel Export is designed to be your very simple solution to these problems. If you need to compile exported data from your WordPress forms into a spreadsheet, Excel Export is the tool you need to save hours of unnecessary labor.
Take control of your exported data with Excel Export
Excel Export gives you full control over the data you pull from your WordPress forms submissions. Selectively choose the fields, the form, and the date range that you want. Pull that data into a .xlsx or .xls spreadsheet file with the push of a button. There’s no limitations set natively by the add-on, so you can export whatever you like, whenever you like it.
From the convenience of a single page in your WordPress dashboard, you can:
Export from any of your WordPress forms in any date range
Excel Export can grab data from any of your WordPress forms submissions. You have the added convenience of defining the date range of the data you want. Monthly, quarterly, or annual reports are ridiculously easy to generate, as are any time period you might need to export data from.
Selectively export data by specifying the fields you need while exempting others
You’re not always going to want every field on every export. Select only the data points you need simply by marking a checkbox next to the field(s) you want to export. Excel Export will grab data only from the fields you’ve indicated. You can also order the fields you do export into rows simply by dragging and dropping them into place from the dashboard view.
Export as .xlsx or .xls files
Whether it’s for compatibility, the use of macros, or whatever specific reason you may have, Excel Export is capable of generating a spreadsheet in either format. You can set worries about conversion after-the-fact aside.
Please note that the “ZipArchive” PHP module is required for this add-on to run. Please contact your host to ensure compatibility.
- improved compatibility with file uploads
- improved backend CSS
- added filters
- Changed PHP-Excels TMP dir
- load fields by id instead of key
- made fields sortable
- save field settings
- fixed error if Ninja Forms is disabled
- use admin labels if available
- Fixed capabilities filter
- Updated to work with NF THREE
- Fixed handling of single quotes
- Added support for Ninja Forms file-uploads extension
- Freeze header row
- Automatic column width
- Fixed a bug exporting more than 26 Columns to Excel (A-Z, AA, AB, AC, …)
- Added choice for XLS and XLSX file type to increase compatibility
1.3 (21 September 2015)
- Fixed compatibility with Multipart forms
1.2 (1 September 2015)
- Preserve leading zero for numbers entered as text
- Added ID column
1.1 (10 August 2015)
- Added batch processing to export thousands of submissions. Tested up to 25000 entries on a shared hosting with limited memory and limited execution time.
1.0.1 (8 July 2015)
- Fixed a bug with empty fields
1.0 (7 July 2015)
- Initial Release