How many posts did each author publish last quarter, and how long were they? WordPress does not show that, but the numbers are already in the posts. Export the published posts with their date, author and word count using Import Export by RockStarLab, and the file becomes a per-author, per-month report in Excel or Google Sheets. All of it works in the free version.
Free: exporting posts and pages with filters, Author Name, Word Count and Permalink columns, CSV and Excel files. PRO: custom post types, and transformations that change values during export.
Short Answer
- Go to Import Export → Export and choose Blog Posts.
- Add filters: Status equals
publish, Date greater or equal to the first day, Date less or equal to the last day. - Choose the columns Title, Date, Author Name, Word Count and Permalink.
- Export to CSV and open it in a spreadsheet. A pivot table with authors in rows and months in columns gives the report.
An export only reads your content, so you don’t need a backup for it.
The example
A store blog with four authors published 68 posts between January and June 2026. The editor wants to see who wrote how much each month, and how long the posts were.
Step 1: Filter the posts
Go to Import Export → Export, choose Blog Posts and click Next Step. Click Add Filter three times:
- Status, Equals,
publish. Drafts and scheduled posts stay out of the report. - Date, Greater or Equal, 1 January 2026.
- Date, Less or Equal, 30 June 2026. The whole last day is included.
Click the refresh button on the counter. It showed 68 posts.

For a report about one author, add Author Name equals the name. For one section of the blog, add a Taxonomy Filter with the category.
Step 2: Choose the columns
Click Next Step and drag these fields into the Export File Structure:
- Title and Permalink, to find each post later.
- Date, for the month.
- Author Name, the display name of the author. Author Email is in the same Author group if two authors share a name.
- Word Count, the number of words in the post text. HTML tags and shortcodes are not counted.

The file uses field names such as author_name as column headers. To use friendlier names, click the pencil icon on a column and type, for example, Author.
Click Next Step, choose CSV (or Excel), name the file and click Start Export. When the export is complete, click Download Export File. The first rows of the file:
post_title,post_date,author_name,word_count,permalink
"Logo placement: a checklist","2026-06-19 10:07:00","Tom Becker",534,https://www.example-store.com/2026/06/19/logo-placement-a-checklist-3/
"Embroidery thread colors: a checklist","2026-05-25 10:06:00","Tom Becker",399,https://www.example-store.com/2026/05/25/embroidery-thread-colors-a-checklist-3/
Step 3: Build the report in a spreadsheet
Open the CSV in Excel or import it into Google Sheets (File → Import → Upload). Then:
- Add a column Month next to the date. In row 2, enter
=LEFT(B2,7)if the dates stayed as text, or=TEXT(B2,"yyyy-mm")if the spreadsheet turned them into dates. Fill the formula down. Each row now has a month like2026-06. - Select the data and insert a pivot table (Insert → PivotTable in Excel, Insert → Pivot table in Google Sheets).
- Put author_name in Rows, Month in Columns, and post_title in Values as COUNTA (Excel: Count).
- For a second table with the words, use the same rows and columns with word_count as SUM. With AVERAGE you get the average post length.
The post count for our example:
| Author | Jan | Feb | Mar | Apr | May | Jun | Total |
|---|---|---|---|---|---|---|---|
| Lena Hart | 4 | 5 | 3 | 6 | 4 | 5 | 27 |
| Marco Diaz | 2 | 2 | 3 | 1 | 2 | 3 | 13 |
| Priya Nair | 0 | 1 | 3 | 4 | 5 | 6 | 19 |
| Tom Becker | 3 | 3 | 0 | 0 | 2 | 1 | 9 |
| All authors | 9 | 11 | 9 | 11 | 13 | 15 | 68 |
And the words:
| Author | Posts | Words | Average words per post |
|---|---|---|---|
| Lena Hart | 27 | 23,912 | 886 |
| Marco Diaz | 13 | 7,206 | 554 |
| Priya Nair | 19 | 23,926 | 1,259 |
| Tom Becker | 9 | 4,271 | 475 |
The report shows things a post list doesn’t: Lena Hart published the most posts, Priya Nair wrote as many words in fewer and longer posts and published more every month, and Tom Becker published nothing in March and April.
Repeat it every month
To get a new report each month without setting it up again, open the Schedules page and choose this finished export as the source (see scheduling repeated exports). A scheduled export keeps the same filters. For a year-to-date report, leave out the Less or Equal date filter: each run then contains everything published since 1 January, and the pivot table shows every month so far.
The exported file is also a list of every published post with its address, which is useful for a content inventory.
With an AI agent
An AI agent connected through the WordPress MCP Adapter (see connecting Claude Code to WordPress) can produce the same report. It uses rsl-ie/export-count to count posts for each author and month, and rsl-ie/export-start to create the file with the word counts. A prompt:
Count the published posts per author per month from January to June 2026
and show the result as a table. Then export the same posts with title,
date, author name and word count as a JSON file named
author-report-2026-h1.
In our run, the agent counted 68 published posts in the period, then counted each author per month with the filters author_name, post_status and two post_date conditions (for example, 6 posts by Lena Hart in April and 6 by Priya Nair in June, the same as the pivot table). The export job finished with 68 records, and the file was ready to download from Jobs Log.
FAQ
Can I export posts by one author only?
Yes. Add the filter Author Name equals the name, or Author Email equals the email. The export contains only that author’s posts.
How is the word count calculated?
From the post content, without HTML tags and shortcodes. The title and excerpt are not counted. It can differ slightly from the count in the block editor.
Does the Date filter include the last day?
Yes. Less or Equal with 30 June includes posts published at any time on 30 June.
Can I include pages or WooCommerce products?
Pages: yes, choose Pages instead of Blog Posts. Products and other custom post types need PRO.
Can I report on updated posts instead of new ones?
Yes. Filter by Modified Date instead of Date and add the Modified Date column.
Related Guides
- WordPress Content Inventory: Export All Pages with Dates, Authors and Status
- WordPress CSV Posts Export: Export Blog Posts to CSV, Excel, JSON, XML, and ODS
- WordPress Export Data Filters Examples: How to Use Them Effectively
- How to Schedule Repeated Exports in WordPress
- Incremental WordPress Exports: Export Only What Changed Since Last Time
- Export Posts from One Category, Tag or Author to CSV
- Schedule WordPress Posts from a CSV Content Calendar
Get the free plugin on WordPress.org.

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