---
title: "Bulk Moderate WordPress Comments from a Spreadsheet"
url: "https://wpimportexport.com/bulk-moderate-wordpress-comments-spreadsheet/"
description: "Export pending WordPress comments, mark each as approved, spam or trash in a spreadsheet and import the decisions back to moderate them all at once."
type: post
published: 2026-11-20T13:00:00+00:00
modified: 2026-11-14T10:46:10+00:00
categories: ["Export Guides", "Import Guides", "Tutorials"]
tags: ["CSV Export", "CSV import", "WordPress automation"]
docs_topics: ["Bulk updates and automation", "Export guides"]
---

# Bulk Moderate WordPress Comments from a Spreadsheet

When a blog gets many comments, the moderation queue grows quickly, and approving or marking comments as spam one at a time on the Comments screen is slow. With [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) you can export the pending comments to a spreadsheet, read them and write a decision for each, and import the decisions back in one go. In the example, seven comments on a coffee roastery’s blog are moderated.

**Free:** comment export and import, version 2.1.48 or later.

## Short Answer

- Export **Comments** with the filter **Status** **Equals** `0` (pending) and the columns Comment ID, Post Title, Author Name, Comment Content and Status.
- In the `comment_approved` column, write `approved`, `spam` or `trash` for each comment, then keep only `comment_ID` and `comment_approved`.
- Import the file into **Comments** with **Check for Existing Items by Field** set to `comment_ID`, **Update** for matches and **Skip** for new items.

## 1. Export the pending comments

Go to **Export**, choose **Comments** and add the filter **Status**, **Equals**, `0`. Pending comments have the status `0` and approved ones `1`. The counter showed 7 comments waiting for moderation:

![Export Comments with the filter Status Equals 0, 7 items](https://wpimportexport.com/wp-content/uploads/2026/11/01-export-filter-1.webp)

_Status 0 selects the pending comments._

On the field step we chose Comment ID, Post Title, Author Name, Comment Content and Status, and exported a CSV. The post title and the text are there so you can decide; only the ID and the status go back into WordPress.

## 2. Decide in the spreadsheet

Read each comment and replace the `0` in the `comment_approved` column with the decision:

| comment_ID | Post | Author | Comment | comment_approved |
| --- | --- | --- | --- | --- |
| 83 | Our New Roastery Opens in March | Sam | test | trash |
| 82 | Our New Roastery Opens in March | Priya Shah | Congratulations on the new roastery! Will there be cupping events? | approved |
| 81 | How We Source Green Coffee | SEO Expert | I can get your site to page one, contact me | spam |
| 80 | How We Source Green Coffee | Leo Martin | Do you work directly with the farms in Huila? | approved |
| 79 | Five Single-Origin Coffees to Try This Winter | Anna Kim | Great list, the Kenya was my favourite this year. | approved |
| 78 | Five Single-Origin Coffees to Try This Winter | Best Deals | Cheap watches here, click now!!! | spam |
| 77 | Five Single-Origin Coffees to Try This Winter | Tom Becker | Medium-fine works for me, about 18 on a Baratza Encore. | approved |

The status accepts `1` or `approved`, `0` or `pending`, `spam` and `trash`. Before the import, delete the Post, Author and Comment columns so the file has only `comment_ID` and `comment_approved`. Then nothing else in the comments can change.

## 3. Import the decisions

Go to **Import**, choose **Comments**, upload the file and click **Auto Map**. The two columns were mapped to `comment_ID` and `comment_approved`:

![Comments import mapping with two columns: comment_ID and comment_approved](https://wpimportexport.com/wp-content/uploads/2026/11/02-mapping-5.webp)

_The file has only the comment ID and the decision._

On the options step, set **Check for Existing Items by Field** to `comment_ID`, **If Match Found** to **Update** and **If No Match Found** to **Skip**:

![Import options: check existing items by comment_ID, update matches, skip items without a match](https://wpimportexport.com/wp-content/uploads/2026/11/03-options-3.webp)

_Update the comments by ID._

The import updated all seven comments in one second:

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

_All seven decisions were applied._

## 4. Check the result

The Comments screen showed 0 pending comments, 2 in Spam and 1 in Trash. The approved comments kept their author, email and IP, and Tom Becker’s comment is still a reply to Maria Lopez:

![Comments screen: Pending 0, Spam 2, Trash 1, approved comments with author, email and IP, Tom Becker in reply to Maria Lopez](https://wpimportexport.com/wp-content/uploads/2026/11/05-comments-screen.webp)

_The queue is empty and the reply keeps its thread._

On the post, the approved comments appear with the reply nested under the question:

![Post comments: Maria Lopez's question with Tom Becker's reply nested under it, and Anna Kim's comment](https://wpimportexport.com/wp-content/uploads/2026/11/06-front-thread.webp)

_Approved comments on the post._

## Before you import

Check the IDs and the decisions, because approved comments appear on the site right away. Trash is safer than deleting: comments in Trash can be restored from the Comments screen. For a large import, [back up the site](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) first. Use version 2.1.48 or later for the two-column file.

## 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 queue after the import:

```
How many comments are still pending, and which ones are in spam?
```

In our run, the agent called `rsl-ie/export-count` for `comment` with the status `hold` and got 0. Then it called `rsl-ie/export-preview` with the status `spam`, which returned the two spam comments: “SEO Expert” on “How We Source Green Coffee” and “Best Deals” on “Five Single-Origin Coffees to Try This Winter”.

## FAQ

### What does the Status column mean?

`1` is approved, `0` is pending, and `spam` and `trash` are the Spam and Trash lists. The import also accepts the words approved and pending.

### Will the import change the comment text or author?

No. With only the ID and the status in the file, only the status changes. In our test the author, email, IP and reply thread stayed the same.

### Can I moderate comments on one post only?

Yes. Add a second export filter for the post, or delete the rows of other posts in the spreadsheet.

## Related Guides

- [How to Export WordPress Comments to CSV or Excel](https://wpimportexport.com/how-to-export-wordpress-comments-csv-excel/)
- [How to Import WordPress Comments from CSV (with Replies and Dates)](https://wpimportexport.com/import-wordpress-comments-from-csv/)
- [Bulk Change Post Status in WordPress with a Spreadsheet](https://wpimportexport.com/bulk-change-post-status-wordpress-spreadsheet/)
- [Bulk Comment Moderation from a Spreadsheet (What’s New in 2.1.48)](https://wpimportexport.com/comment-moderation-sale-dates-import-export-by-rockstarlab-2-1-48/)

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