WordPress – How to Delete Duplicate Posts or Pages in Seconds

In this tutorial, we show you how to remove duplicate posts or pages on WordPress.

As you may know, duplicate posts or pages can be a real problem for several reasons:

• First, they take space that we could use for something more important.
• Second, they make our server slow because it has to load more things than we actually need.
• Third, we sometimes have problems discerning which of these duplicate posts or pages are the ones with good content.

It’s always a great option to delete duplicate WordPress posts or pages. But it can be really time-consuming if you have to delete them manually.

That’s why we’ll show you how to remove duplicate posts or pages using the Posts, Pages, and Custom Post Types Spreadsheet plugin. It helps you manage your posts, pages, and custom post types completely from an intuitive spreadsheet inside WordPress.

After installing and activating the plugin, you need to open the spreadsheet you’ll use. By that, we mean that you need to open whether the pages spreadsheet or the posts spreadsheet.

• Posts: Go to Sheet Editor > Edit Posts
• Pages: Go to Sheet Editor > Edit Pages

Once you open the spreadsheet you need to use, you’ll see all your posts or pages displayed on it. We’re using the posts spreadsheet, so every post is a row and every field of that post is a column.

---

Before executing the “Remove Duplicates” feature:

To avoid showing 404 errors to your users after removing duplicates, you need to create 301 redirections to the remaining posts or pages. But we can create them automatically for you. Just do this:

1. Install the Redirection plugin to create the redirection links.
2. Install the WP Sheet Editor – Redirection extension.

Once both the plugin and the extension are installed on your website, you can run the “Remove Duplicates” feature freely because our plugin will automatically create the 301 redirections to the remaining posts or pages.

A backup is recommended to avoid any problems.

---

Once you open the spreadsheet you’ll use, you can follow these simple steps to remove the duplicate posts or pages.

1- Open the “Bulk Edit” tool

The Bulk Edit tool allows you to apply massive changes to your posts or pages with a few clicks. In this case, it’ll help you delete all the duplicate posts or pages.

2- Optional: Filter your posts or pages

If you want to delete all the duplicates, skip this step.

To filter the posts you will edit, you need to select the I want to search rows to update option in the Select the rows that you want to update dropdown in the Bulk Edit tool.

Here are some search filters you can use to find the posts you’ll select:

• Contains keyword: Enter any word here, and the plugin will find all posts containing it in their titles.
• Author: Select any post author to edit the posts by him only.
• Enter Categories, Tags or Formats: Enter any of these three search parameters.

Once enter any of these search terms, click the Run search button.

3- Delete duplicate WordPress posts or pages

In this section, we show you how to remove duplicate posts or pages, but before you need to consider something really important:

Select these values to remove duplicate WordPress posts or pages:

• Select the rows that you want to update: This value will depend on how you selected the posts to edit. You can edit all posts, edit the search results, or edit the posts selected manually in the spreadsheet.
• What field do you want to edit: Title
• Select type of edit: Remove duplicates
• Which duplicates do you want to delete: You can select if you want to delete the newest items and keep the oldest item or vice-versa.
• Click Execute now.

That’s how you can easily remove duplicate posts or pages!

You can forget about having to check and remove the duplicate posts or pages manually. You can easily bulk delete duplicate content from your WordPress website using the WP Sheet Editor plugin. Which is best, it doesn’t with posts or pages only, but you can use it with post types generated by other plugins.