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

App Shah

Crunchify » WordPress Optimization and Tutorials » How to Export WordPress Post Title, Post URL and Featured Image in CSV Format

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.

All Export Option - Plugin

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.

WP_Query result and customize result

Step-4

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

Choose Title, PermaLink and Featured Image from Right Hand side dropdown

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.

Preview Post Title, Permalink, Featured Image export data

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

Confirm and Run Export - Crunchify Tips

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

Export WordPress Post data now

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

4 thoughts on “How to Export WordPress Post Title, Post URL and Featured Image in CSV Format”

Leave a Comment