---
title: "Export Drafts and Pending Posts for Editorial Review (and Import the Decisions Back)"
url: "https://wpimportexport.com/export-draft-pending-posts-editorial-review/"
description: "Export WordPress drafts and pending posts to Excel for your editor, then import the decisions back: publish, send back or fix titles in one pass."
type: post
published: 2026-11-15T07:00:00+00:00
modified: 2026-11-18T13:11:25+00:00
categories: ["Export Guides", "Import Guides", "Tutorials"]
tags: ["CSV Export", "Import Export by RockStarLab", "WordPress Excel export"]
docs_topics: ["Export guides", "Import guides"]
---

# Export Drafts and Pending Posts for Editorial Review (and Import the Decisions Back)

Drafts pile up: half-finished ideas, posts waiting for review, pieces nobody has looked at in weeks. An editor can work through them in a spreadsheet much faster than by opening each post in WordPress: one row per post, a decision in the status column, a note for the author. With [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/), the same spreadsheet then goes back into WordPress and applies the decisions. The example is one review round for a coffee roastery’s blog.

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

## Short Answer

1. In **Export**, choose Posts, add the filter **Status** In `draft,pending`, and export ID, Title, Status, Author Name and Word Count to XLSX.
2. The editor changes the status (`publish`, `pending`, `draft`), fixes titles and adds notes in an extra column.
3. Import the file with **Check for Existing Items by Field** = ID and **If Match Found** = Update. Posts set to `publish` go live; the notes column is ignored.

## Export the review queue

WordPress has two statuses for unfinished posts: `draft` and `pending` (shown as “Pending Review”). The condition **In** takes both at once:

![Export filter: Status In draft,pending; total items available 5](https://wpimportexport.com/wp-content/uploads/2026/11/01-filter-status.webp)

_One filter collects every draft and every post waiting for review._

Our blog had three drafts and two posts pending review, by two authors. We exported these columns to XLSX:

- **ID**, so the decisions go back to the right posts.
- **Title** and **Status**, the two things the editor changes.
- **Author Name**, so the editor knows whom to talk to.
- **Word Count**, a quick sign of how finished a draft is: our “Untitled idea: decaf” had 80 words, the interview 1,400.

## The editor’s decisions

The editor worked through the file, changed the status column, fixed one title and added an **Editor notes** column:

![Spreadsheet with ID, post_title, post_status, author_name, word_count and Editor notes: two posts set to publish, one to pending, two left as draft](https://wpimportexport.com/wp-content/uploads/2026/11/02-editor-decisions.webp)

_The editor's decisions: a new status, one fixed title and a note for each post._

- **publish**: the post goes live when the file is imported.
- **pending**: back in the review queue, for example after a final read.
- **draft**: stays with the author, and the note says what’s missing.

Use the WordPress names: `publish`, `pending`, `draft`, and `private` if you need it.

## Import the decisions

In **Import**, choose Posts, upload the edited file and click **Auto Map**:

![Import mapping: ID, post_title, post_status and author_name mapped; word_count and Editor notes not mapped; 4 of 6 fields mapped](https://wpimportexport.com/wp-content/uploads/2026/11/03-import-mapping.webp)

_Columns that aren't WordPress fields, like the editor's notes, stay unmapped and are ignored._

ID, Title, Status and Author Name are mapped. Word Count and Editor notes aren’t WordPress fields, so they stay unmapped and nothing is written from them. On the options step, set Check for Existing Items by Field to **ID**, If Match Found to **Update** and If No Match Found to **Skip**.

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

_All five posts updated in one import._

What changed on our site:

- “Interview with Our New Head Roaster” and “Why We Switched to Compostable Coffee Bags” were published, with the publish date set to the moment of the import. The second one went live with the corrected title, and both got their URL slugs from their titles.
- “Five Ways to Use Leftover Coffee” moved from draft to Pending Review.
- The two other drafts stayed drafts.
- The authors didn’t change: Author Name matched the same users.

To publish at a planned time instead of right away, set the status to `future` and add a **Date** column (`post_date`) with the date and time; see [exporting your content calendar](https://wpimportexport.com/export-scheduled-posts-content-calendar/) for the scheduled side.

## Sharing the notes with authors

The notes stay in the spreadsheet; they aren’t saved in WordPress. Send the file to the authors, or filter it by Author Name and send each author their rows. Keep the file with the date as a record of the review round.

## Before you import

An import with `publish` in the status column makes posts public right away. Check the status column once more, try one row first, and [back up the site](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) before larger rounds.

## 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 show what’s left in the queue after a round:

```
List the posts that are still drafts or pending review, with their authors.
```

In our run, the agent called `rsl-ie/export-preview` with the status filter In `draft,pending`. It returned three posts: the two drafts and “Five Ways to Use Leftover Coffee”, now pending review. The two published posts were no longer in the list.

## FAQ

### What’s the difference between draft and pending?

A draft is still being written. Pending (“Pending Review”) means the author has submitted it for an editor to review.

### Will importing a status change the publish date?

When a draft becomes `publish`, WordPress sets the publish date to the time of the import, unless the file has a Date column.

### Are the editor’s notes saved anywhere in WordPress?

No. Columns that aren’t mapped to a field are ignored. Map a column to a custom field if you want to keep notes on the post.

### Can authors see only their own drafts?

Filter the spreadsheet by Author Name, or add an Author filter to the export.

### Can I include pages?

Yes. Run the same export and import with Pages.

## Related Guides

- [Export Your Content Calendar: Scheduled WordPress Posts to Excel](https://wpimportexport.com/export-scheduled-posts-content-calendar/)
- [Bulk Update WordPress Posts from CSV Without Duplicates](https://wpimportexport.com/how-to-bulk-update-existing-wordpress-posts-without-creating-duplicates/)
- [Compare Two WordPress Exports to See What Changed](https://wpimportexport.com/compare-two-wordpress-exports-excel/)
- [Export Posts by Category, Tag or Author to CSV](https://wpimportexport.com/export-posts-by-category-tag-author-csv/)

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