A quarterly report, a year-in-review post, an archive for a client, or a handover of everything published last summer: all of them start with the same question, “which posts did we publish between these two dates?” WordPress’s built-in exporter can limit posts by month, but it produces a WXR file for another WordPress site, not a spreadsheet. With Import Export by RockStarLab, two Date filters give you any range, down to the day, in CSV, Excel or another format. The example covers the third quarter of 2025 on a coffee roastery’s blog.
Free: everything in this guide works for posts and pages. PRO: the same for custom post types and WooCommerce products.
Short Answer
- In Export, choose Posts and add a filter Date Greater or Equal the first day of the range.
- Add a second filter Date Less or Equal the last day. Posts published at any time on that day are included.
- Add Status Equals
publishso drafts dated in the range stay out, pick your fields and export.
Set the range with two Date filters
The Date filter compares the post’s publish date. One filter sets the start of the range, a second one the end, and both have to match:

The date field uses your browser’s date format; our screenshot shows day/month/year.
We tested the edges of the range with posts published close to them:
| Post | Published | In the export? |
|---|---|---|
| June Roast Calendar | 30 June 2025, 23:45 | No, the day before the range |
| July Single-Origin: Huila | 1 July 2025, 00:00 | Yes |
| Summer Cold Brew Guide | 14 August 2025, 10:00 | Yes |
| Autumn Blend Notes (draft) | 20 August 2025, 09:00 | Only without the Status filter |
| September Cupping Recap | 30 September 2025, 18:30 | Yes |
| October Harvest Update | 1 October 2025, 08:00 | No, the day after the range |
The two Date filters alone matched 4 posts: the three published ones and the draft. Drafts keep a date too, so add Status Equals publish for a report on what actually went live. With it, the count dropped to 3.
The end date: Less or Equal, not Less Than
Less or Equal 30 September includes the whole of 30 September: our post from 18:30 that day was in the export. Less Than 30 September stops at the start of that day, and the count fell to 2 published posts (3 with the draft). If you prefer to write the day after the range, use Less Than 1 October; it gives the same result as Less or Equal 30 September.
The same rule applies at the start: Greater or Equal 1 July includes posts from midnight on 1 July, while Greater Than 1 July starts on 2 July.
Dates are compared in your site’s time zone (Settings → General), the same time WordPress shows next to each post.
Choose the fields and export
For our quarterly report we exported ID, Title, Date, Status and Permalink to XLSX:


Useful additions, depending on the report:
- Author Name to see who wrote what; for counts per author and month, see the content production report.
- Category Names and Tag Names to group the quarter by topic.
- Word Count for a quick volume figure.
- Content if the file is an archive or a handover, not just a list.
Other date ranges
- One month: Greater or Equal the 1st, Less or Equal the last day of the month.
- One year: Greater or Equal 1 January, Less or Equal 31 December.
- One day: the same date in both filters.
- Everything before or after a date: use just one of the two filters.
- Posts edited in a range: use Modified Date instead of Date; see finding outdated posts by last modified date.
- One category in a range: add a Taxonomy Filter; all filters combine with AND.
Before you change anything
An export only reads your content. If you plan to edit the exported posts and import them back, for example to update categories for the whole quarter, back up the site 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) can answer the question directly:
Which posts did we publish between 1 July and 30 September 2025?
In our run, the agent called rsl-ie/export-preview with three filters: post_date equals_or_greater 2025-07-01, post_date equals_or_less 2025-09-30 and post_status equals publish. It returned the same three posts as the wizard, from “September Cupping Recap” at 18:30 on 30 September to “July Single-Origin: Huila” at 00:00 on 1 July. Ask it to export the result to XLSX if you need the file.
FAQ
Is the end date included?
With Less or Equal, yes, the whole day. With Less Than, no.
Why are drafts in my date range export?
Drafts and scheduled posts have a date as well. Add a Status filter with publish, or In publish,future to include scheduled posts.
Can I export pages by date the same way?
Yes. Choose Pages instead of Posts; the filters are the same.
Can I export the same range every month automatically?
The dates in a filter are fixed. For a regular export of new content, use a scheduled export with Changes only; see incremental exports.
Which time zone are the dates in?
Your site’s time zone from Settings → General, the same as the dates in the post list.
Related Guides
- Content Production Report: Export WordPress Posts per Author and per Month
- Find Outdated WordPress Posts to Refresh: Export by Last Modified Date
- Incremental WordPress Exports: Export Only What Changed Since Last Time
- Export Posts from One Category, Tag or Author to CSV
Get the free plugin on WordPress.org.

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