---
title: "Find Thin Content in WordPress: Export Word Counts for a Content Audit"
url: "https://wpimportexport.com/find-thin-content-wordpress-word-count-export/"
description: "Export the word count of every WordPress post to Excel, sort it and find thin posts to expand, merge or remove in your next content audit."
type: post
published: 2026-11-15T17:00:00+00:00
modified: 2026-11-14T10:45:00+00:00
categories: ["Export Guides", "Tutorials"]
tags: ["Import Export by RockStarLab"]
docs_topics: ["Export guides"]
---

# Find Thin Content in WordPress: Export Word Counts for a Content Audit

Every blog collects short posts over the years: a holiday notice, a job ad, a quick product announcement, a photo post with two lines of text. On their own they’re fine. Hundreds of them make a site look thin to readers and search engines, and they compete with your real guides. A content audit starts with one list: every post and how long it is. With [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/), the **Word Count** column gives you that list in a spreadsheet. The example audits a coffee roastery’s blog.

**Free:** everything in this guide works for posts and pages. **PRO:** the same for custom post types.

## Short Answer

1. In **Export**, choose Posts and add the filter **Status** **Equals** `publish`.
2. Export ID, Title, Word Count, Date, Modified Date and Permalink to XLSX.
3. Sort by word_count, mark the posts under your threshold (for example 300 words) and decide for each one: expand, merge, redirect or leave it.

## Export the word counts

Audit only what visitors can see, so filter to published posts. We also limited the export to one category; leave that filter out to audit the whole blog:

![Export filters: Status Equals publish and Taxonomy Filter category Has Term(s) - IN roastery-blog-wc; total items available 8](https://wpimportexport.com/wp-content/uploads/2026/11/01-filters-4.webp)

_Published posts from one category; leave out the category filter to audit the whole blog._

The columns we exported:

- **ID**, so you can update the posts later by import.
- **Title** and **Permalink**, to open and check each post.
- **Word Count**, the number of words in the post text.
- **Date** and **Modified Date**, to see how old a post is and when it was last touched.

Word Count counts the words of the visible text: HTML tags, block markup and shortcodes are left out.

## Sort and mark the thin posts

Open the file in Excel, Google Sheets or LibreOffice, sort by **word_count** from smallest to largest, and add a column with a formula such as `=IF(C2<300,"Thin","")`:

![Spreadsheet sorted by word_count: Photos from the Cupping Night 0, Opening Hours Over the Holidays 45, We Are Hiring a Barista 95, New Decaf on the Shelf 180, What Is a Natural Process Coffee? 260 marked Thin; How to Store Coffee Beans 410, Pour-Over Brewing for Beginners 820, The Complete Guide to Espresso Ratios 1450](https://wpimportexport.com/wp-content/uploads/2026/11/02-sorted-word-count.webp)

_Sorted by word count, with posts under 300 words marked. Five of eight need a decision._

Five of our eight posts were under 300 words. The list also showed a trap: “Photos from the Cupping Night” has **0** words. It’s a gallery post: the photos come from a shortcode, which isn’t counted. A 0 usually means a post made of images, an embed or a shortcode, not an empty post, so open it before you decide.

300 words is a common starting point, not a rule. A short post that answers its question completely, like opening hours, can stay short.

## Decide what to do with each post

- **Expand** posts on topics people still search for. “What Is a Natural Process Coffee?” at 260 words is a good candidate for a full guide.
- **Merge** several short posts on one topic into one stronger post, and redirect the old URLs to it.
- **Update** announcements that are still useful, such as “New Decaf on the Shelf”, with current details.
- **Remove or noindex** posts that have expired: an old job ad or a past holiday notice. Redirect them if other sites link to them.
- **Add text** to photo posts: a short introduction and captions help readers and search engines.

Write the decision in a new column. The sheet becomes your plan for the next weeks, and the IDs let you apply bulk changes, such as new statuses, by import later.

## Before you change posts in bulk

An export only reads your content. If you apply decisions by import, for example to set expired posts to `draft`, [back up the site](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) first and import by ID so the existing posts are updated.

## 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 give you the list without a file:

```
List the published posts in Roastery Blog with their word counts, and tell me which ones have fewer than 300 words.
```

In our run, the agent called `rsl-ie/export-preview` with the Status and category filters and the fields ID, Title and Word Count. It returned all eight posts with the same counts as the spreadsheet, from 1,450 words down to 0, so the agent could list the five under 300 right away.

## FAQ

### Can I filter the export by word count?

Word Count is an export column, not a filter. Export all posts and sort or filter the spreadsheet.

### Why does a post with a lot of content show a low word count?

Content that a shortcode adds, such as a gallery or a form, isn’t counted. Check those posts by opening them.

### Can I audit pages too?

Yes. Run the same export with Pages. Pages like Contact or Cart are short on purpose, so judge them separately.

### How often should I run a content audit?

Once or twice a year is enough for most blogs. Keep each file with its date to compare the results.

## Related Guides

- [Find Outdated WordPress Posts to Refresh: Export by Last Modified Date](https://wpimportexport.com/find-outdated-wordpress-posts-export-last-modified/)
- [Content Production Report: Export WordPress Posts per Author and per Month](https://wpimportexport.com/export-wordpress-posts-per-author-per-month/)
- [Find Every WordPress Post That Uses a Shortcode (Before You Remove a Plugin)](https://wpimportexport.com/find-wordpress-posts-using-shortcode/)
- [Export WordPress Posts by Date Range: a Month, a Quarter or a Year](https://wpimportexport.com/export-wordpress-posts-by-date-range/)

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