A list of your posts with their featured images is useful in more places than you’d expect: a social media calendar needs the link and the picture, a designer wants to see which images repeat, and an accessibility check needs the alt text. WordPress has no screen that shows all of this together. Import Export by RockStarLab exports it to one Excel row per post, with the image URL, alt text, categories and tags. The example export feeds a coffee roastery’s social media scheduler.
Free: everything in this guide works in the free plugin.
Short Answer
- Go to Import Export by RockStarLab → Export and choose Posts.
- Optionally filter by category with a Taxonomy Filter and by Status equals
publish. - Add the columns Title, Permalink, Featured Image URL, Featured Image Alt Text, Category Names and Tag Names.
- Choose XLSX and start the export.
Choose the posts
We only wanted the published posts from the News and Coffee Guides categories:

In the Taxonomy Filter, the taxonomy is category and the terms can be names or slugs, separated by commas. The counter shows 4 posts. Skip the filters to export every post.
Choose the columns
The image fields are in the Featured Image group of the field list, and the category and tag names are in Standard:

- Featured Image URL: the full-size image file.
- Featured Image Alt Text: the alt text set on the image in the Media Library.
- Category Names and Tag Names: all of the post’s terms in one cell, separated by commas.
- The same group also has Featured Image ID, Title and Caption.
The result
The Excel file had one row per post:
| ID | post_title | featured_image_url | featured_image_alt | category_names | tag_names |
|---|---|---|---|---|---|
| 1863 | How We Source Green Coffee | …/uploads/2026/11/farm-visit.jpg | Sorting green coffee beans at the farm | Coffee Guides | single origin, sourcing |
| 1861 | Five Single-Origin Coffees to Try This Winter | …/uploads/2026/11/ethiopia-yirgacheffe.jpg | Coffee Guides | seasonal, single origin | |
| 1857 | Meet the Team Behind the Beans | …/uploads/2026/11/team-photo.jpg | The roastery team in front of the roaster | News | team |
| 1854 | Our New Roastery Opens in March | …/uploads/2026/11/roastery-front.jpg | Front of the roastery with the new sign | News | events, roastery |
The table shortens the image URLs; the file has the full addresses, and the Permalink column (not shown here) has each post’s public link. Two things stand out right away:
- The Ethiopia image has no alt text. Open it in Media → Library and add one; screen readers and image search both use it.
- A post without a featured image has an empty Featured Image URL cell. Filter that column for blanks in Excel to find them.
Paste the Permalink, Title and Featured Image URL columns into your scheduler, or give the file to whoever plans your posts.
Keep the list fresh
Save the export as a schedule to get a new file every week; see scheduling recurring exports. From the command line, the same export is one command (see the WP-CLI guide):
wp rsl-ie export --type=post --status=publish \
--fields=ID,post_title,permalink,featured_image_url,featured_image_alt,category_names,tag_names \
--options='{"taxonomy":[{"taxonomy":"category","terms":["news","coffee-guides"],"condition":"in"}]}' \
--format=xlsx --output=blog-posts-with-images.xlsx --user=admin
Before you change anything
An export only reads your posts. If you fix alt texts or categories in the spreadsheet and import them back, back up the site first and match the rows by ID (see updating posts without duplicates).
With an AI agent
An AI agent connected through the WordPress MCP Adapter (see connecting Claude Code to WordPress) can prepare the file from a sentence:
Export our published News and Coffee Guides posts with links, featured image URLs, alt text and categories to Excel for the social media scheduler.
In our run, the agent called rsl-ie/export-start with those five fields, the category filter and XLSX. When the job finished, rsl-ie/file-get returned posts-for-social.xlsx with 4 posts and its download link.
FAQ
Which image size is the Featured Image URL?
The full-size file you uploaded.
What if a post has no featured image?
The Featured Image URL and alt text cells are empty for that post.
Can I export pages or products the same way?
Pages, yes, with the same fields. Products have their own export type in PRO, with the main image and gallery.
Can I get the categories in separate columns?
Category Names puts them in one cell. Use Text to Columns in Excel to split them.
Does the export change my posts?
No. An export only reads them.
Related Guides
- Export WordPress Posts by Category, Tag or Author to CSV
- Find Outdated WordPress Posts to Refresh: Export by Last Modified Date
- Find Large Images in the WordPress Media Library
- Sync Featured Images and Media Between WordPress Sites
Get the free plugin on WordPress.org.

Comments 0
Have a question or a tip to share? Leave it below.