WordPress Posts – How to Bulk Edit Last Modified Date

Sometimes, websites have lots of contents. For example, your website may have 500 blog entries you’ve written in the last 5 years. That’s great; you’ve done a great job. However, if your readers find an article written 3 or 5 years ago, they may think it’s outdated and doesn’t have anything to offer them.

That’s why it’s important to edit the last modified date in your posts so that people see that your website is always active and up to date. In fact, some say that last modified date is even more important because it helps your readers see how you take care about your contents.

The problem comes when you have to edit 500 or even 2,000 blog entries. It’s simply hard and takes dozens of hours. You can spend several days editing your posts.

That’s why we want to show you how simple it is to edit your WP posts last modified date using the WP Sheet Editor Posts Spreadsheet plugin. It helps you manage your WP posts in a spreadsheet. It simplifies your life.

Install the plugin now

You can skip this step if you have the plugin installed and activated.

Once installed and activates, the plugin will display all your WP posts in a spreadsheet for you to edit quickly.


Each of the sections below contains a video and a text guide.

Video Guide

Text Guide

It’s really simple. Just go to the Modified Date and start editing hundreds of posts modified date individually.

Video Guide

Text Guide

If you don’t want to do it individually, you can easily edit hundreds of posts’ last modified dates. Just open the Bulk Edit tool and follow these simple steps.

a) Select the posts you’ll edit

After opening the Bulk Edit tool, select the I want to select rows to update option in the Select the rows that you want to update dropdown. This will open the fields you need to filter your posts.

You’ll find these options:

  • Contains keyword: Enter any keyword to filter all the posts containing it.
  • Status: Published or Draft
  • Author: Any author’s name
  • Categories, Tags, Formats: Use this same field to filter products by category, tag or format.

Also, you can filter your posts by last modified date. For example, if you want to edit all the posts modified in 2017, then you need to look for a date in that year and all the posts modified on that date will be filtered.

For this, use the Enable advanced filters checkbox and enter these values:

  • Field key: Modified Date
  • Operator: =
  • Value: enter any date you wish

After you’ve decided which search method to use, click on Run search and all your posts will be filtered.

b) Edit dates in the filtered posts

In the Bulk Edit fields, use these values to modify all your posts last modified dates:

  • What field do you want to edit: Modified Date
  • Select type of edit: Set value
  • Replace existing value with this value: enter the date you want
  • Click on Execute now

Video Guide

Text Guide

With WP Sheet Editor you can import new last modified dates from Excel or Google Sheets. It’s important because you don’t have to edit them all or copy/paste. Another advantage is that you can edit them offline and then upload them to Sheet Editor.

Follow these simple steps:

a) Click on Import on the top toolbar

b) Select the file you’ll import and hit Next. You can upload it from your computer or from a URL.

c) Click on Import all the columns

d) Select Update existing items, ignore new items in the Do you want to update or create items Then, select Title in CSV Field and also in WordPress Field. After that, click on Next

e) Finally, click on The preview is fine, start import


As you can see, editing your posts’ last modified dates is really easy with WP Sheet Editor. You have three great options and all of them are easy and take only some clicks.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu