Skip to Content

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 to 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 events with WP All Export:

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:

export xml/cvs, choose a post type, with arrow indicating events

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.

events will be exported with red box outlining available data

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.

configure advances settings with red box outlining 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.

Leave a reply:

Your email address will not be published. Required fields are marked *

Back to top