Back to blog
4 min read Export Guides

Export WordPress Posts with Featured Image URL and Categories to Excel

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

  1. Go to Import Export by RockStarLab → Export and choose Posts.
  2. Optionally filter by category with a Taxonomy Filter and by Status equals publish.
  3. Add the columns Title, Permalink, Featured Image URL, Featured Image Alt Text, Category Names and Tag Names.
  4. Choose XLSX and start the export.

Choose the posts

We only wanted the published posts from the News and Coffee Guides categories:

Export step 2 with a Taxonomy Filter for the categories News and Coffee Guides and Status equals publish; 4 items available
Two filters pick the published posts from two 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:

Export file structure with the columns ID, Title, Permalink, Featured Image URL, Featured Image Alt Text, Category Names and Tag Names
The image fields come from the Featured Image group.
  • 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

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.

Get the free plugin on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

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

Leave a comment

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

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE