---
title: "Schedule WordPress Posts from a CSV Content Calendar"
url: "https://wpimportexport.com/schedule-wordpress-posts-csv-publish-dates/"
description: "Import a content calendar as scheduled WordPress posts: post_status future, post_date in site time, categories, past dates and how WP-Cron publishes them."
type: post
published: 2026-11-10T11:00:00+00:00
modified: 2026-11-14T10:43:20+00:00
categories: ["Import Guides", "Tutorials"]
tags: ["CSV import", "Import Export by RockStarLab"]
docs_topics: ["Import guides"]
---

# Schedule WordPress Posts from a CSV Content Calendar

Content calendars usually live in a spreadsheet: one row per post, with the day and time it should go live. Copying each row into WordPress and setting the publish date by hand takes a while and invites mistakes with time zones. [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) imports the calendar as scheduled posts that WordPress publishes on time. In the example, a coffee roastery’s blog gets a month of posts from one CSV file.

**Free:** everything in this guide, including categories and the AI agent abilities.

## Short Answer

1. In your spreadsheet, add a `post_status` column with the value `future` and a `post_date` column with the publish date and time, for example `2026-12-01 09:00`.
2. Save it as CSV and go to **Import Export → Import**, choose **Blog Posts** and upload the file.
3. Click **Auto Map** and check that `post_status` and `post_date` are mapped.
4. Start the import. The posts appear under **Posts → Scheduled** and WordPress publishes each one at its date.

## The file

Our December calendar has four posts for the coming weeks and one that was planned for last week:

```
post_title,post_status,post_date,post_content,categories
Holiday Gift Guide for Coffee Lovers,future,2026-12-01 09:00,"Six gifts under 50 euros, from grinders to subscriptions.",Guides
How to Brew for a Crowd,future,2026-12-08 09:00,"Batch brew, ratios and timing for ten cups or more.",Brewing
Our Winter Blend Is Back,future,2026-12-15 09:00,"Chocolate, orange peel and a little spice.",News
New Year Opening Hours,future,2026-12-29 18:30,"When the roastery cafe is open over the holidays.",News
Last Week's Cupping Notes,future,2026-11-02 10:00,"What we tasted last week.",News
```

- **post_status:** `future` is the WordPress name for a scheduled post. Use exactly this word.
- **post_date:** the date and time in your site’s time zone (**Settings → General → Timezone**). `2026-12-01 09:00` and `2026-12-01 09:00:00` both work. If you work in another time zone, use a `post_date_gmt` column with UTC times instead.
- **categories:** mapped to Categories, it puts each post in its category and creates categories that don’t exist yet. See [importing categories and tags from CSV](https://wpimportexport.com/import-posts-with-categories-and-tags-from-csv/) for several categories per post.

In Excel or Google Sheets, format the date column as text or as `yyyy-mm-dd hh:mm` before saving, so the spreadsheet doesn’t turn it into its own date format. The guide on [dates and leading zeros in Excel CSV files](https://wpimportexport.com/excel-leading-zeros-dates-scientific-notation-csv/) explains why Excel changes them.

## Step 1: Upload the calendar

Open **Import Export → Import**, choose **Blog Posts** and upload the CSV file. Step 3 shows the five rows so you can check the dates were read as written.

## Step 2: Map the columns

Click **Auto Map** in step 4. `post_title`, `post_status`, `post_date` and `post_content` map to the fields of the same name, and `categories` maps to Categories.

![Mapped fields in step 4: post_title, post_status, post_date and post_content mapped to the same WordPress fields and categories mapped to taxonomy_category](https://wpimportexport.com/wp-content/uploads/2026/11/01-mapping.webp)

_Auto Map maps post_status and post_date, and categories to Categories._

In step 5, choose **post_title** under **Check for Existing Items by Field**. If you change a date in the spreadsheet later and import the file again, the posts are rescheduled instead of duplicated.

## Step 3: Import and check the schedule

Click **Start Import**. All five posts were created in a second.

![Import Completed Successfully with 5 successful, 5 created, 0 updated, 0 skipped and 0 failed](https://wpimportexport.com/wp-content/uploads/2026/11/02-result.webp)

_Five calendar rows imported._

**Posts → Scheduled** lists the four posts with their dates and categories:

![WordPress Posts list filtered by Scheduled with four posts from December 1 to December 29, each with its category and scheduled date](https://wpimportexport.com/wp-content/uploads/2026/11/03-scheduled-posts.webp)

_The four upcoming posts wait under Posts → Scheduled._

The fifth post, planned for a date that had already passed, was published right away with that date, the same as when you schedule a post in the editor with a past date. So a calendar that is partly in the past is safe to import: old rows go live with their original dates, new rows wait.

## How the posts get published

WordPress publishes scheduled posts with WP-Cron, which runs when someone visits the site. On a site with regular visitors the post goes live within a minute or so of its time. We tested it with a post scheduled three minutes ahead: at the planned time it changed from Scheduled to Published by itself.

On a site with very few visitors, or where WP-Cron is turned off, a post can go live late. Ask your host to set up a server cron job that calls `wp-cron.php` every few minutes; scheduled imports and exports in the [Jobs Log](https://wpimportexport.com/how-to-use-jobs-log-and-schedule-wp-import-and-export-jobs/) rely on the same WP-Cron.

## Things to watch

- Use `future` for posts that should wait. A row with `publish` and a date in the future goes live immediately.
- Any other value, or an empty cell, keeps the default status of the import, which is draft.
- Scheduled posts don’t appear on the site, in feeds or in the sitemap until they are published.
- Pages work the same way: choose **Pages** in step 1.

## 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 schedule posts from a list you give it:

```
Schedule a News post "Tasting Notes: Panama Geisha" for 14:39 today
with the text "Jasmine, bergamot, stone fruit."
```

In our run, the agent wrote a one-row CSV with `future` and the date, uploaded it with `rsl-ie/upload-create`, `rsl-ie/upload-chunk` and `rsl-ie/upload-complete`, and started the import with `rsl-ie/import-start`, mapping `categories` to `taxonomy_category` and matching by `post_title`. The post was saved as Scheduled for 14:39 and was published at 14:39 by WP-Cron, without anyone touching it.

## Before you import

Scheduled posts go live without anyone checking them again. [Create a backup](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) before importing into a live site, and look through the Scheduled list after the import.

## FAQ

### Which status do I use for scheduled posts?

future. It is the WordPress name for scheduled posts. With publish and a future date, the post goes live immediately.

### Which time zone is the post_date in?

Your site’s time zone from Settings → General. Use a post_date_gmt column if your times are in UTC.

### What happens to rows with a date in the past?

They are published right away and keep the date from the file.

### Can I change the dates later?

Yes. Change them in the spreadsheet and import it again with post_title (or the slug) as the field to match. The posts are updated and rescheduled.

### Why didn’t a scheduled post go live on time?

WP-Cron only runs when the site gets a visit. On quiet sites, set up a server cron job that calls wp-cron.php regularly.

## Related Guides

- [Import Posts with Categories and Tags from CSV](https://wpimportexport.com/import-posts-with-categories-and-tags-from-csv/)
- [Import Posts from Excel with Featured Images by URL](https://wpimportexport.com/import-posts-from-excel-with-featured-images-by-url/)
- [Excel Lost Leading Zeros or Shows Dates? Fix an Exported CSV](https://wpimportexport.com/excel-leading-zeros-dates-scientific-notation-csv/)
- [Save and Reuse Field Mapping Templates for Recurring WordPress Imports](https://wpimportexport.com/save-reuse-field-mapping-templates-wordpress-import/)
- [WordPress Import Created Duplicate Posts? Causes and Fix](https://wpimportexport.com/wordpress-import-duplicate-posts/)

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