How to Export WordPress Post Title, Post URL and Featured Image in CSV Format

Have you ever wondered how to export WordPress Post, URL and Featured Image in CSV (Comma Separated Value) file?

Before we get started, WordPress by default provides simple Import / Export tool. Just go to Tools -> Export to export all of your posts, pages, comments.

In this tutorial we will go over simple steps to get started and export all WordPress posts into CSV format.

Let’s get started:

Step-1

There is a simple plugin Export WordPress data to XML/CSV which I’ve been using since long time to export posts.

Here is a link: https://wordpress.org/plugins/wp-all-export

Just install and activate WordPress plugin.

Step-2

Go to All Export -> New Export from left side panel.

Step-3

• First thing you will see is to choose WP_Query Result tab.
• Choose Post Type Query from dropdown.
• Here is an updated query: 'post_type' => 'post', 'post_status'=>'publish'.
• Click on Customize Export File button.

Step-4

• Next you have to choose what you want to export from list to options.
• In our case we just need 3 things
  • Post Title
  • Post Permalink
  • Post Featured Image

Click on Preview button to see the result. By default all 3 fields will be separated by Comma (,). Here is a preview in my case.

Step-5

Next you need to export these data to CSV file.

• Keep default iteration to 50 records
• You may need to create new file each time option

On Next screen you will be able to see green bar within ~5 seconds. Just click on CSV file to download your file 🙂

I hope you find this tutorial useful if you want to export WordPress data to CSV file.