---
title: "Bulk Change Post Status in WordPress with a Spreadsheet"
url: "https://wpimportexport.com/bulk-change-post-status-wordpress-spreadsheet/"
description: "Export posts with ID and status, set publish, draft or private for each row in a spreadsheet and import the file back to change many statuses at once."
type: post
published: 2026-11-19T11:00:00+00:00
modified: 2026-11-14T10:37:31+00:00
categories: ["Export Guides", "Import Guides", "Tutorials"]
tags: ["CSV Export", "CSV import", "Import Export by RockStarLab", "WordPress automation"]
docs_topics: ["Bulk updates and automation"]
---

# Bulk Change Post Status in WordPress with a Spreadsheet

Hiding last year’s event posts, keeping this year’s and sending a few back to draft means three different statuses in one category. Bulk Edit sets one status for the posts on one screen, so a spreadsheet is faster here. With [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) you export the posts with their ID and status, change the status column and import the file back. The example is a coffee roastery’s Events category.

**Free:** export and import of posts and pages, including the status. **PRO:** the same for custom post types and WooCommerce products.

## Short Answer

- Export the posts with the columns `ID`, `post_title` and `post_status`, filtered to the ones you want to change.
- In the spreadsheet, set `post_status` to `publish`, `draft`, `pending` or `private` for each row.
- Import the file into Blog Posts with **Check for Existing Items by Field** set to ID, **If Match Found: Update** and **If No Match Found: Skip**.

## 1. Export the posts you want to change

Go to **Export**, choose **Blog Posts** and add a **Taxonomy Filter**: taxonomy `category`, condition **Has Term(s) – IN**, term `Events`. The counter showed 9 posts:

![Export Blog Posts with a Taxonomy Filter: category has term Events, 9 items](https://wpimportexport.com/wp-content/uploads/2026/11/01-export-filter.webp)

_Export only the posts in the Events category._

On the field step, we kept only ID, Title, Status and Date and exported a CSV. The date column helps you decide; it isn’t needed for the import. The headers in the file are the field keys (`ID`, `post_title`, `post_status`), which makes the import map them by itself. For other ways to pick posts, see [exporting one category, tag or author](https://wpimportexport.com/export-posts-by-category-tag-author-csv/).

## 2. Change the status in the spreadsheet

Five events had already taken place, so we set them to `private`: they stay in the dashboard for the team, but visitors can’t open them. We left the scheduled workshop as `future` and three drafts as `draft`, and deleted the date column:

![Edited CSV with ID, post_title and post_status: five past events set to private, the workshop future, three drafts](https://wpimportexport.com/wp-content/uploads/2026/11/02-edited-csv.webp)

_Change the status column; the five past events become private._

Use the status names WordPress uses: `publish`, `draft`, `pending`, `private` or `future`.

## 3. Import the file back

Go to **Import**, choose **Blog Posts**, upload the CSV and click **Auto Map**. All three columns were mapped to ID, Title and Status:

![Import mapping: ID, post_title and post_status mapped automatically, 3 of 3 fields](https://wpimportexport.com/wp-content/uploads/2026/11/03-mapping.webp)

_Auto Map matches the field-key headers._

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**, so a wrong ID can’t create a new post:

![Import options: Check for Existing Items by Field ID, If Match Found Update, If No Match Found Skip](https://wpimportexport.com/wp-content/uploads/2026/11/04-import-options.webp)

_Match by ID, update matches, skip unknown IDs._

The import updated 9 posts in 1 second, with 0 created and 0 failed:

![Import Completed Successfully: 9 updated, 0 created, 0 failed](https://wpimportexport.com/wp-content/uploads/2026/11/05-result.webp)

_Nine posts updated in one import._

The five past events were private, the workshop was still scheduled for 12 December, and the drafts were still drafts. The published dates, content and category of the private posts stayed as they were, because the file only had ID, title and status. A visitor opening one of the private posts got a 404 page.

## Before you import

An import with Update changes live posts. Check the status column once more, and [back up the site](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) before you change many posts. Keep the exported file as a record of the statuses before the change.

## 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 check the result:

```
List the posts in the Events category with their status.
```

In our run, the agent called `rsl-ie/export-preview` for posts with the fields ID, title and status and a category filter for `events`. It returned nine posts: the Barista Workshop as `future`, the five past events as `private` and three drafts.

## FAQ

### Which status values can I use in the file?

`publish`, `draft`, `pending`, `private` and `future`, the names WordPress uses.

### Will the import change anything else in the posts?

Only the mapped columns. In our test the file had ID, title and status, and the dates, content and categories of the published posts stayed as they were.

### What if an ID in the file doesn’t exist?

With If No Match Found set to Skip, that row is skipped and no post is created.

## Related Guides

- [Export Drafts and Pending Posts for Editorial Review (and Import the Decisions Back)](https://wpimportexport.com/export-draft-pending-posts-editorial-review/)
- [Export Posts from One Category, Tag or Author to CSV](https://wpimportexport.com/export-posts-by-category-tag-author-csv/)
- [Bulk Update ACF Field Values with a Spreadsheet](https://wpimportexport.com/bulk-update-acf-field-values-spreadsheet/)
- [Export Your Content Calendar: Scheduled WordPress Posts to Excel](https://wpimportexport.com/export-scheduled-posts-content-calendar/)

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