Have you ever wanted an easy way to list out all of your posts or pages, along with their images where the report included the date and category too?
The WP All Export plugin makes it super simple to do.
Whether you’re doing a full content audit, or just need a list of your posts for organizing your social media strategy, I’ll show you how to configure the WP All Export plugin to customize a CSV file with all the info you want and export it to a spreadsheet for easy management.
Subscribe to the BlogAid YouTube Channel
to get more helpful tips like this
First, install the WP All Export plugin. It has a super easy drag and drop interface to select the data you want to export.
Once you have it installed and activated, you’ll find a tab for it in the admin sidebar. Click that.
You’ll be taken to the New Export admin page where you can select the type of export you want to do.
Specific Post Type is already selected
Click the drop down to choose the type of post.
As you can see, it has detected all of the post types I have on this site.
I’m going to choose my blog posts.
It responds that I have 43 posts.
Now I want to customize the data I want in the report.
Click the blue Customize Export File button.
WP All Export makes this super easy with a nice drag and drop interface.
For this report, I want the post ID and Title.
But I don’t need the actual content.
So I can just click and drag that out of the window.
But, I do want to see the media in the post, like my images.
So, on the right, I have a whole list of Available Data types.
I’m going to click Media.
And then Images to expand that.
And I want the URL of the image.
So I’m going to click and drag that into the window.
I might also want to see the date that the post was published.
And then scroll down to the Date and click and drag that over.
You can also arrange these data elements in the order you want to see them in columns in your spreadsheet.
And, I think it would be helpful to see the category too.
Click Taxonomy and select Categories.
Next, scroll down and click the drop down for Export Type.
If you select either of the Excel types, you’ll see a notice that you need to upgrade to the pro version of this plugin.
So, I’m going to select CSV, which will work just fine in Excel or Google sheets.
Then click the blue Continue button at the bottom.
You’ll be presented with more configuration options, should you need them.
And if you have a lot of posts, you may want to select the Split large exports into multiple files setting.
You can also give your report a name for reference. A date in there might be handy too.
When you’ve finished with your settings, click the blue confirm and run export button.
Now, I only had 43 posts, so it ran lickety split. But if you have hundreds or thousands, and a lot of image urls in each one, then it may take a while to run the report.
Once it’s complete, click the blue CSV button to download your report.
Depending on how you have your computer set up, you may see a dialogue box asking if you want to open the file or save it.
I’ll save it to my desktop.
And then open in Excel.
You can see the post ID in the first column.
Then the date it was published, starting with the year, month, and then day.
The post title.
And then any images that are in it.
When there is more than one image, they will follow one after the other, separated by the pipe symbol. So, if you have a lot of images, maybe you’ll want to sort on something shorter than the URL. However, the URL has the full path to the file folder, and those are organized by year and month. So it may help you locate it faster if you plan to delete the post and all of the images in it.
Now that you have them all in a spreadsheet, it should be a lot easier for you to sort them into posts to delete, rework, or use in focused resources pages. You can also use this to help you schedule posts for social media or other promotion as well.
I hope you’ve enjoyed this tutorial on the WP All Export plugin. Be sure to subscribe to the BlogAid YouTube Channel for more helpful tips just like this.