You may easily export Forms, Entries, Views, and Styles from the Formidable → Import/Export page. The exported Forms, Entries, Views, and Styles can then be uploaded to any site that uses Formidable. You may also export entries as a CSV file, and then import this file into any application that accepts CSV files, like Excel.
How to export
- Go to the Formidable → Import/Export page.
- Typically, you should select 'XML' for the Export Format. However, if you only want to export entries, select 'CSV' instead. Exporting entries as a CSV file is especially helpful if you want to modify the exported data or import it into an application like Excel. If you select 'CSV' as the file type, it is recommended to select 'UTF-8' as the encoding type.
- Select the Data to Export. Note: In the free version, only forms can be exported, so this option will not appear.
- Select one or more forms to export data from in the Select Form(s) field.
- Click Export Selection. Your browser will download an XML or CSV file which can be imported to another site, imported into another application, or modified and imported back to the original site in order to update data.
Export selected entries
If you would like to export a few selected entries, entries that match a search, or all entries for a particular month, follow the instructions below.
- Go to the form that you would like to export entries from and click the 'Entries' in the top nav.
- Select a few entries or do a search for a particular value. If you want to search for entries created in January 2014, select 'Entry Creation Date' in the search dropdown and type 2014-01 in the search bar.
- If you did a search and only want to exported matching entries, just click the 'Download CSV' button. If you selected entries to export, then select 'Export to CSV' in the 'Bulk Actions' dropdown and click 'Apply'.
Export Styles
If you would like to export a Style and import it to another site, follow the steps below.
- Go to your Formidable → Import/Export page.
- Select 'XML' for the Export Format.
- Select 'Styles' for the Data to Export.
- Find a form that has the Style you want to export selected in the form's Settings → Style Template. Select this form in the Select Form(s) field.
- Click Export Selection. Your browser will download an XML file which contains the exported Style.
Export repeaters
To export repeaters in a comma separated format, follow the instructions below.
- Go to Formidable → Import/Export.
- Under Export, select CSV for the Export Format.
- Select the Form in the Select a Form(s) box.
- If you would like each row in a repeater exported in a separate row in the CSV, select the Child Form instead. The name of the Child form will be the name of the repeater in the form.
- Once selected, click the Export Selection button.
If you are updating your entries with a repeater, check the import repeaters for instructions.
Troubleshooting
Abnormal characters in Excel
When you open a CSV in Excel, Excel will use default charset settings and ignore the encoding type in the CSV file. Sometimes this results in abnormal characters appearing in your Excel spreadsheet. If you import the file into Excel instead of opening it normally, then you can select the encoding type/charset. We recommend using the Excel > Import option and selecting the encoding type that corresponds with the CSV encoding type, which is typically UTF-8.
No file downloads/white screen
Formidable is attempting to export your data, but is hitting limitations (usually size) with your server setup. You can do a date-specific export (ex: 'Entry creation date' and '2016-01' to get only entries for January 2016), or increase the memory limit setting on your server. You can increase the memory_limit in your php.ini to 64M or 96M. If you're not sure where to find this file or how to change it, please contact your host for help. Alternatively, you can also try adding this line to your wp-config.php:
define('WP_MEMORY_LIMIT', '96M');