Back to blog
6 min read 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 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 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 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
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
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
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 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) 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 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.

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