Back to blog
5 min read Export Guides

Find Outdated WordPress Posts to Refresh: Export by Last Modified Date

Old guides lose readers quietly: prices change, equipment changes, a better method appears. The first step of a content refresh is a list of the posts nobody has touched for a long time. With Import Export by RockStarLab you export exactly that list, with each post’s link, last edit date and length, to an Excel file you can sort and share with your writers. The example finds the brewing guides on a coffee roastery’s blog that haven’t been updated for a year.

Free: everything in this guide works in the free plugin.

Short Answer

  1. Go to Import Export by RockStarLab → Export and choose Posts.
  2. Add a filter: Modified Date, Less Than, and the cut-off date. Narrow it down with a Taxonomy Filter (category) and Status equals publish.
  3. Choose the columns Title, Permalink, Modified Date, Word Count and Category Names.
  4. Export to XLSX and sort the file by Modified Date.

Filter by last modified date

WordPress saves the date of the last edit separately from the publish date. A guide published in 2022 and corrected last month isn’t stale. One published last year and never opened again might be. That’s why the filter uses Modified Date, not Date.

Our blog has eight posts in the Brew Guides category. We wanted those last edited before 1 November 2025:

Export step 2 filters: Modified Date less than 1 November 2025, Taxonomy Filter category has term Brew Guides, Status equals publish; 5 items available
Three filters leave the five guides nobody edited for a year.
  • Modified Date → Less Than → 1 November 2025: posts not edited since then.
  • Taxonomy Filter: taxonomy category, Has Term(s), Brew Guides. Leave it out to check the whole blog.
  • Status → Equals → publish: drafts and private posts stay out of the list.

The counter at the top updated to 5. The other three guides had been edited within the year.

Choose the columns

For a refresh list you need to know what the post is, where it is, how old it is and how much work it is:

Export file structure with the columns Title, Permalink, Modified Date, Word Count and Category Names
Five columns are enough for a refresh plan.

Permalink gives the public link, so a writer can open the post straight from the spreadsheet. Word Count helps you estimate the work: a 600-word post is an afternoon, a 2,000-word guide is a project. Modified Date is in the Other group of the field list.

The result

We exported to XLSX. The file had the five guides:

post_title permalink post_modified word_count category_names
Cold Brew at Home https://www.example-roastery.com/2023/07/15/cold-brew-at-home/ 2023-07-15 09:00:00 820 Brew Guides
French Press Basics https://www.example-roastery.com/2022/05/04/french-press-basics/ 2022-06-01 15:30:00 640 Brew Guides
Choosing a Coffee Grinder https://www.example-roastery.com/2022/01/20/choosing-a-coffee-grinder/ 2024-02-02 12:00:00 2100 Brew Guides
How to Brew a V60 https://www.example-roastery.com/2021/03/10/how-to-brew-a-v60/ 2021-03-10 09:00:00 980 Brew Guides
Espresso Dial-In Guide https://www.example-roastery.com/2020/11/11/espresso-dial-in/ 2021-01-05 10:00:00 1450 Brew Guides

The wizard lists posts newest first by publish date. Sort the post_modified column in Excel to put the oldest edits on top. Add a column for the writer’s name and a status, and the file becomes your refresh plan.

Repeat it every quarter

Save the export as a schedule and the list is ready every three months without setting the filters again; see scheduling recurring exports. The cut-off date in the filter is fixed, so update it when you want a new one-year window.

From the command line, the same export can be sorted by the last edit, oldest first (the options are explained in the WP-CLI guide):

wp rsl-ie export --type=post --status=publish \
  --fields=post_title,permalink,post_modified,word_count \
  --options='{"taxonomy":[{"taxonomy":"category","terms":["brew-guides"],"condition":"in"}],"date_query":{"column":"post_modified","before":"2025-11-01"},"orderby":"modified","order":"ASC"}' \
  --format=csv --output=refresh.csv --user=admin

In our run this wrote the five guides from Espresso Dial-In Guide (last edited January 2021) to Choosing a Coffee Grinder (February 2024).

After the refresh

When writers update the posts in WordPress, the modified date changes and the posts drop off the next list. If you’d rather edit in the spreadsheet and import the changes back, use the post ID as the matching field (see bulk updates without duplicates) and back up the site first.

With an AI agent

An AI agent connected through the WordPress MCP Adapter (see connecting Claude Code to WordPress) can build the list from a sentence:

Which brew guides haven't been updated since November 2025? Put them in an Excel file, oldest first.

In our run, the agent called rsl-ie/export-count with the category and a date_query on post_modified (count: 5), started the export with rsl-ie/export-start in XLSX sorted by modified date, and once the job finished, rsl-ie/file-get returned brew-guides-to-refresh.xlsx with its download link.

FAQ

What’s the difference between Date and Modified Date?

Date is when the post was published. Modified Date is the last time it was saved. A refresh list uses Modified Date.

Can I include pages or custom post types?

Yes. Choose Pages or the custom post type on the first step; the same Modified Date filter is there.

Can I see how long each post is?

Yes, add the Word Count column.

Can I sort the list by the last edit?

Sort the column in Excel, or use orderby “modified” from WP-CLI or an AI agent.

Does the export change my posts?

No. An export only reads the posts.

Get the free plugin on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

Have a question or a tip to share? Leave it below.

Leave a comment

Your email address will not be published. Required fields are marked *

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE