---
title: "Compare Two WordPress Exports to See What Changed: An Excel Workflow"
url: "https://wpimportexport.com/compare-two-wordpress-exports-excel/"
description: "Export your posts twice and compare the files in Excel: find new, changed and deleted posts with two COUNTIF and INDEX/MATCH formulas."
type: post
published: 2026-11-14T15:00:00+00:00
modified: 2026-11-14T10:44:45+00:00
categories: ["Export Guides", "Tutorials"]
tags: ["CSV Export", "Import Export by RockStarLab", "WordPress Excel export"]
docs_topics: ["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](https://wordpress.org/plugins/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](https://wpimportexport.com/wp-content/uploads/2026/11/01-export-columns-3-scaled.webp)

_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](https://wpimportexport.com/wp-content/uploads/2026/11/04-compare-sheet.webp)

_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](https://wpimportexport.com/incremental-wordpress-export-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](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) before larger fixes.

## With an AI agent

An AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) 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.

## Related Guides

- [Export Only What Changed Since the Last Export](https://wpimportexport.com/incremental-wordpress-export-changed-since-last-time/)
- [Find Outdated WordPress Posts by Last Modified Date](https://wpimportexport.com/find-outdated-wordpress-posts-export-last-modified/)
- [How to Export WordPress to Excel: Built-In Export vs a Plugin](https://wpimportexport.com/export-wordpress-to-excel/)
- [Export Posts by Category, Tag or Author to CSV](https://wpimportexport.com/export-posts-by-category-tag-author-csv/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
