---
title: "Export Your Content Calendar: Scheduled WordPress Posts to Excel"
url: "https://wpimportexport.com/export-scheduled-posts-content-calendar/"
description: "Export your scheduled WordPress posts with dates, authors, categories and word counts to Excel or CSV, and share the content calendar with your team."
type: post
published: 2026-11-14T09:00:00+00:00
modified: 2026-11-18T13:11:19+00:00
categories: ["Export Guides", "Tutorials"]
tags: ["CSV Export", "Import Export by RockStarLab", "WordPress Excel export"]
docs_topics: ["Export guides"]
---

# Export Your Content Calendar: Scheduled WordPress Posts to Excel

WordPress shows scheduled posts in the Posts list, but you can’t send that list to an editor, add notes next to it or print it for a planning meeting. A spreadsheet of what is going out, when and by whom is the simplest content calendar there is. In the example, a coffee roastery’s scheduled posts for December and January go to Excel with [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/).

**Free:** everything in this guide works in the free plugin for posts and pages. **PRO:** the same for custom post types and WooCommerce products.

## Short Answer

1. In **Export**, choose Posts and add a filter **Status** Equals `future`.
2. Add two **Date** filters for the period: Greater or Equal the first day, Less or Equal the last day.
3. Add the columns Title, Date, Author Name, Category Names, Word Count and Featured Image URL, choose XLSX and export.

## Filter the scheduled posts

WordPress calls scheduled posts `future`, so that’s the value the Status filter needs. A date range keeps the calendar to the weeks you’re planning and leaves out anything scheduled far ahead:

![Export filters: Status equals future, Date greater or equal 10/11/2026, Date less or equal 31/01/2027; total items available 8](https://wpimportexport.com/wp-content/uploads/2026/11/01-filters-3.webp)

_Status = future plus a date range gives the scheduled posts for the coming weeks._

On our site, the status filter alone matched 9 posts: one of them was a test post scheduled for 2030. With the range from 10 November 2026 to 31 January 2027, 8 posts remained.

To include drafts with a planned date, use the condition **In** with the value `future,draft` instead of Equals `future`. When we tested it, a draft dated 20 December was counted together with the scheduled posts.

## Choose the columns

![Export file structure with Title, Date, Author Name, Category Names, Word Count and Featured Image URL](https://wpimportexport.com/wp-content/uploads/2026/11/02-columns-3-scaled.webp)

_Six columns are enough for a content calendar._

| Column | Why it’s in the calendar |
| --- | --- |
| Title | What is going out. |
| Date | When it goes out: the scheduled publish date and time. |
| Author Name | Who is responsible for it. |
| Category Names | The categories as readable names (“Brew Guides”), so you can check the mix of topics. |
| Word Count | Spots posts that are still too short to go out. |
| Featured Image URL | Empty means the post has no featured image yet. |

Choose **XLSX** on the format step, give the file a name such as `content-calendar` and start the export.

![Export Complete with a Download Export File button](https://wpimportexport.com/wp-content/uploads/2026/11/03-done.webp)

_The calendar is ready to download as an Excel file._

## The calendar

Our file, sorted by date in Excel (the export lists the newest date first):

| Title | Date | Author | Category | Words | Image |
| --- | --- | --- | --- | --- | --- |
| Holiday Gift Guide: Coffee Edition | 2026-12-01 09:00 | Tomás Rivera | Roastery News | 600 | yes |
| How to Brew for a Crowd | 2026-12-03 09:00 | Lena Novak | Brew Guides | 900 | — |
| December Single Origin: Rwanda | 2026-12-05 08:00 | Tomás Rivera | Roastery News | 350 | — |
| Mulled Cold Brew Recipe | 2026-12-08 09:00 | Lena Novak | Brew Guides | 450 | yes |
| Shipping Deadlines for Christmas | 2026-12-10 07:30 | Tomás Rivera | Roastery News | 150 | — |
| Grinder Cleaning Before the Holidays | 2026-12-15 09:00 | Lena Novak | Brew Guides | 700 | — |
| Year in Review: Our 2026 Coffees | 2026-12-29 10:00 | Tomás Rivera | Roastery News | 1,200 | yes |
| January Subscription Lineup | 2027-01-05 09:00 | Lena Novak | Roastery News | 300 | — |

The file answers the usual planning questions at a glance: a gap between 15 and 29 December, five of the eight posts without a featured image, and a 150-word shipping notice that may need more text. The dates are written as `2026-12-01 09:00:00`, so sorting the Date column A to Z puts them in calendar order.

## Share it with the team

- Upload the XLSX to Google Sheets or OneDrive, add a Notes column, and let the editors comment there.
- Export again whenever the schedule changes; the file always reflects what WordPress will publish.
- To change dates or titles from the spreadsheet, add the ID column to the export and import the file back with Check for Existing Items by Field = ID. See [updating posts without duplicates](https://wpimportexport.com/how-to-bulk-update-existing-wordpress-posts-without-creating-duplicates/).

## Before you import changes back

Exporting doesn’t change anything on the site. If you edit the calendar and import it back, [back up the site](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) first and import a couple of rows to check the result.

## 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 list the calendar in date order without a file:

```
List the posts scheduled between 10 November 2026 and 31 January 2027, oldest first, with the date and author.
```

In our run, the agent called `rsl-ie/export-preview` with the status and date filters and the order set to date ascending. It returned the same eight posts, starting with the Holiday Gift Guide on 1 December and ending with the January Subscription Lineup on 5 January.

## FAQ

### Why do I filter by “future” and not “Scheduled”?

“Scheduled” is the label in the WordPress admin; `future` is the status name stored in the database, and that’s what the filter compares.

### Can I include drafts?

Yes. Use the condition In with `future,draft`. Drafts are listed with the date set in the post.

### Why is the newest post first?

The export lists posts by date, newest first. Sort the Date column in Excel to read the calendar in order.

### Can I export pages or products the same way?

Yes. Choose Pages instead of Posts; products and custom post types need PRO.

### Can I send it as CSV instead?

Yes. Choose CSV on the format step. XLSX keeps accented names such as “Tomás” intact when the file is opened in Excel.

## Related Guides

- [Export Posts by Category, Tag or Author to CSV](https://wpimportexport.com/export-posts-by-category-tag-author-csv/)
- [Export WordPress Posts per Author per Month](https://wpimportexport.com/export-wordpress-posts-per-author-per-month/)
- [Find Outdated WordPress Posts by Last Modified Date](https://wpimportexport.com/find-outdated-wordpress-posts-export-last-modified/)
- [How to Export WordPress to Excel: Built-In Export vs a Plugin](https://wpimportexport.com/export-wordpress-to-excel/)
- [Schedule WordPress Posts from a CSV Content Calendar](https://wpimportexport.com/schedule-wordpress-posts-csv-publish-dates/)

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