WordPress – How to Search for Comments by IP Address

In this tutorial, we will show you how to search WordPress comments by IP address. This is very useful when you get spam from specific IP addresses and they keep creating comments on your WordPress posts or WooCommerce products.

Normally, WordPress doesn’t allow you to find comments using such advanced search parameters. But the WP Sheet Editor – Comments and Reviews plugin allows you to view and edit comments using an intuitive spreadsheet on WordPress.

With this plugin, you can apply advanced searches to find comments and product reviews quickly. You can also apply bulk changes to hundreds of comments with a few clicks. In addition, you can export all comments and reviews to a CSV file and migrate the content to another site.

After installing and activating the plugin, you can easily set up the spreadsheet by following this quick guide.

Now just follow these simple steps to find all comments coming from a specific IP address.

1- Open the comments spreadsheet

After setting up the spreadsheet, you will be able to access the spreadsheet automatically.

However, you can access it by going to WP Sheet Editor > Edit comments.

You will see all the reviews and comments displayed on an intuitive spreadsheet.

2- Open the “Search” tool to filter your comments

The “Search” tool allows you to use any field and any value as a search parameter to filter your comments and product reviews.

In this case, it will allow you to find all comments coming from a specific IP address.

3- Search for WordPress comments by IP address

Now that you have opened the search tool, you need to select the following values to find all comments by IP address:

• Comment type: Comment
• Tick the Enable advanced filters checkbox and select the following values:
• Field: Author IP
• Operator: =
• Value: Enter the desired IP here.
• Hit the Run search button.

Once you hit the Run search button, you’ll see all the comments from a specific IP address displayed on the spreadsheet. You can see the active filters right above the spreadsheet.

4- Optional – Mark all the filtered comments as spam

After filtering the comments coming from a specific IP address, you have several options.

One of them is to mark all comments as spam. Go to Step 3 of this tutorial.

5- Optional – Export your filtered comments to a CSV file

Another option is to export your filtered comments to a CSV file to create an external database.

Just open the Export tool with one click on the plugin’s top toolbar.

Now you need to select the following values to export all the filtered comments to a CSV file.

• What columns do you want to export: Choose the columns you want to export in this field.
• Which rows do you want to export: All the rows from my current search
• What app will you use to edit this file: You can select Excel, Google Sheets, etc.
• Name of this export: Add a name here for future exports.
• Hit the Start export button.

This is the CSV containing our exported comments in Google Sheets:

As you can see, the WP Sheet Editor – Comments and Reviews plugin allows you to easily filter your WordPress comments by IP address.