---
title: "Export WordPress Posts with Featured Image URL and Categories to Excel"
url: "https://wpimportexport.com/export-wordpress-posts-featured-image-url-excel/"
description: "Export WordPress posts to Excel with featured image URL, alt text, categories and tags in one row per post, for social media, audits and alt text checks."
type: post
published: 2026-11-11T17:00:00+00:00
modified: 2026-11-14T10:43:49+00:00
categories: ["Export Guides", "Tutorials"]
tags: ["CSV Export", "Import Export by RockStarLab", "WordPress Excel export"]
docs_topics: ["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](https://wordpress.org/plugins/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](https://wpimportexport.com/wp-content/uploads/2026/11/01-filters-1.webp)

_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](https://wpimportexport.com/wp-content/uploads/2026/11/02-columns-1.webp)

_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](https://wpimportexport.com/how-to-schedule-repeated-exports-in-wordpress/). From the command line, the same export is one command (see the [WP-CLI guide](https://wpimportexport.com/wp-cli-import-export-wordpress/)):

```
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](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) first and match the rows by ID (see [updating posts without duplicates](https://wpimportexport.com/how-to-bulk-update-existing-wordpress-posts-without-creating-duplicates/)).

## With an AI agent

An AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) 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](https://wpimportexport.com/export-posts-by-category-tag-author-csv/)
- [Find Outdated WordPress Posts to Refresh: Export by Last Modified Date](https://wpimportexport.com/find-outdated-wordpress-posts-export-last-modified/)
- [Find Large Images in the WordPress Media Library](https://wpimportexport.com/find-large-images-wordpress-media-library-file-sizes/)
- [Sync Featured Images and Media Between WordPress Sites](https://wpimportexport.com/sync-featured-images-media-between-wordpress-sites/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
