Back to blog
5 min read Export Guides

Compare Two WordPress Exports to See What Changed: An Excel Workflow

Several people edit the same site, a client says “we only changed a few pages”, or you want a monthly record of what happened to the content. WordPress keeps revisions per post, but it has no list of what changed across the whole site between two dates. Two exports of the same posts, a month apart, give you that list in a spreadsheet. In the example, a coffee roastery’s brew guides are exported twice with Import Export by RockStarLab, and two Excel formulas compare the files.

Free: everything in this guide works in the free plugin for posts and pages. PRO: the same for products, orders and custom post types.

Short Answer

  1. Export the posts to XLSX with ID, Title, Slug, Status, Modified Date and Word Count. Keep the file.
  2. Later, export again with the same columns and filters.
  3. Put both into one workbook as sheets Old and New, and add two formula columns: one marks new and changed rows in New, the other marks rows in Old that are gone.

Take the first snapshot

In Export, choose Posts, add the filters you need (we used the Brew Guides category) and these columns:

Export file structure with ID, Title, Slug, Status, Modified Date and Word Count
Six columns are enough to spot new, changed and removed posts. ID is the key.
  • ID is the key: it stays the same when the title or slug changes.
  • Modified Date changes whenever the post is saved, so it’s the quickest sign that something changed.
  • Title, Status and Word Count say what changed.

Choose XLSX and name the file with the date, for example brew-guides-2026-10-01. Our first export had six posts, all published and last modified on 1 October.

Take the second snapshot

A month later, export again with the same filter and columns. Between the two exports on our test site, someone renamed “AeroPress Basics”, moved “French Press Guide” back to draft, rewrote “Moka Pot Tips”, deleted “Cold Brew at Home” and added “Siphon Brewing 101”. The second file had six posts again, so the row count alone showed nothing.

Compare the two files

Copy both exports into one workbook: the first as a sheet named Old, the second as New. Both have ID in column A, Title in B, Slug in C, Status in D, Modified Date in E and Word Count in F.

In the New sheet, put this in G2 and fill it down. It says whether each post is new, changed or unchanged:

=IF(COUNTIF(Old!$A:$A,$A2)=0,"New",IF(E2=INDEX(Old!$E:$E,MATCH($A2,Old!$A:$A,0)),"Unchanged","Changed"))

In H2, this lists what changed:

=IF(G2<>"Changed","",TRIM(IF(B2<>INDEX(Old!$B:$B,MATCH($A2,Old!$A:$A,0)),"title ","")&IF(D2<>INDEX(Old!$D:$D,MATCH($A2,Old!$A:$A,0)),"status ","")&IF(F2<>INDEX(Old!$F:$F,MATCH($A2,Old!$A:$A,0)),"words ","")))

In the Old sheet, put this in G2 and fill it down. It marks posts that are no longer in the new export:

=IF(COUNTIF(New!$A:$A,$A2)=0,"Removed","")

Our New sheet after filling the formulas down:

Comparison sheet: Siphon Brewing 101 marked New; Moka Pot Tips, French Press Guide and AeroPress Basics marked Changed with words, status and title; two posts Unchanged
The second export with two formula columns: what is new, what changed and how.

And in the Old sheet, “Cold Brew at Home” was marked Removed. That’s the full picture: one new post, three changed posts (title, status and text), one removed post and two that didn’t change. The formulas work the same in Excel, Google Sheets and LibreOffice.

A post that is still in WordPress but no longer matches your filters also shows as Removed, for example a post moved to another category. Check those in WordPress before you assume they were deleted.

Make it a routine

  • Keep the exports in one folder with the date in the file name. Each month, the previous export becomes Old.
  • If you only need the posts that changed, not a full comparison, see exporting only what changed since last time.
  • Add more columns to compare more fields, such as the SEO title or a custom field, and add an IF for each in column H.

Before you act on the differences

Comparing exports only reads your site. If the comparison shows a post was changed by mistake, open its revisions in WordPress before restoring anything, and back up the site before larger fixes.

With an AI agent

An AI agent connected through the WordPress MCP Adapter (see connecting Claude Code to WordPress) can list what changed since the first snapshot without a second file:

Which posts in Brew Guides were modified after 1 October 2026, 10:00? Include drafts.

In our run, the agent called rsl-ie/export-preview with the category and a Modified Date filter. It returned the four posts that were new or changed: Siphon Brewing 101, Moka Pot Tips, French Press Guide (draft) and AeroPress Basics: The Inverted Method. A deleted post isn’t in WordPress anymore, so only the comparison with the old export shows it.

FAQ

Why compare by ID and not by title?

Titles and slugs change; the ID of a post doesn’t. Comparing by title would show a renamed post as one removed and one new.

Can I compare CSV files instead of XLSX?

Yes. Open both in Excel or Google Sheets and copy them into one workbook. XLSX keeps accented characters intact in Excel.

Does Word Count catch every edit?

No. An edit that keeps the same number of words doesn’t change it. Modified Date catches every save, which is why column G checks it.

Can I see what exactly changed in the text?

Export the Content column too and compare it, or open the post’s revisions in WordPress to see the exact changes.

Can I use XLOOKUP instead?

Yes, in current Excel and Google Sheets. INDEX/MATCH and COUNTIF work in every version and in LibreOffice.

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