Export specific data from WordPress in CSV

Here is a scenario, you have Events Calendar plugin and 7k+ of events that you need to export. How do you do it?

WordPress has a built-in tool for export but that does not leave much room for control or to customize your export file. That can be a pain and that is why it is better to use a plugin.

As always there are plenty of plugins out there, still WP All Export plugin seems like one of the best, or at least the one that I used and never failed to deliver.

Here is how to export data from WordPress with WP All Export:

In this example I will be exporting events.

Install the plugin, navigate to All Export and select New Export. You will be able to select Specific Post Type or to add a manual Query to run. We are selecting Events in this case:

Here is how to export events with WP All Export: export xml/cvs, choose a post type.

With premium, you will be able to filter results and only get Events that you need. Like specific ID, title…

On the next step, you can select what data you need, and just include that in your template. You can include custom fields and all sorts of data.

Here is how to export events with WP All Export: events will be exported. Red box outlining available data on the right of the screen.

Once you have that, be sure to tap on the Preview button as that will show how the data will look like and what will be included in the export. That button can save you time. 🙂

Select Export type, we are going with CSV (you can choose different types) and proceed to the final page.

Here you can check some of the advanced options, set this to run on cron, and other tweaks to avoid script timing out.

We will divide our export into smaller batches and proceed with export.

Here is how to export events with WP All Export: Configure Advanced Settings. A red box outlines 'Split Large Exports Into Multiple Files'.

That is it, once the export is completed just download the file and you are all set.

This plugin also has an import option, so this might be a nice way to import data to some other WordPress website as well.

If you have any questions please feel free to contact us. You can also ask us at support@valet.io