---
title: "Export WordPress Posts by Date Range: a Month, a Quarter or a Year"
url: "https://wpimportexport.com/export-wordpress-posts-by-date-range/"
description: "Export WordPress posts published between two dates: two Date filters for the range, a Status filter for published posts only, and the end date included."
type: post
published: 2026-11-15T11:00:00+00:00
modified: 2026-11-14T10:44:54+00:00
categories: ["Export Guides", "Tutorials"]
tags: ["CSV Export", "Import Export by RockStarLab"]
docs_topics: ["Export guides"]
---

# Export WordPress Posts by Date Range: a Month, a Quarter or a Year

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](https://wordpress.org/plugins/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

1. In **Export**, choose Posts and add a filter **Date** **Greater or Equal** the first day of the range.
2. Add a second filter **Date** **Less or Equal** the last day. Posts published at any time on that day are included.
3. Add **Status** **Equals** `publish` so 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:

![Export filters: Date Greater or Equal 01/07/2025, Date Less or Equal 30/09/2025, Status Equals publish; total items available 3](https://wpimportexport.com/wp-content/uploads/2026/11/01-date-filters.webp)

_Two Date filters make the range; the Status filter keeps drafts out._

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:

![Spreadsheet with ID, post_title, post_date, post_status and permalink for three posts dated 1 July, 14 August and 30 September 2025](https://wpimportexport.com/wp-content/uploads/2026/11/02-q3-spreadsheet.webp)

_The quarter's posts, including the one published at 00:00 on the first day and at 18:30 on the last._

\

![Export Completed Successfully screen with Items Exported, File Size and Duration and a Download Export File button](https://wpimportexport.com/wp-content/uploads/2026/11/03-export-complete-2.webp)

_The export finishes in seconds; download the file from this screen._

Useful additions, depending on the report:

- **Author Name** to see who wrote what; for counts per author and month, see the [content production report](https://wpimportexport.com/export-wordpress-posts-per-author-per-month/).
- **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](https://wpimportexport.com/find-outdated-wordpress-posts-export-last-modified/).
- **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](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 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](https://wpimportexport.com/incremental-wordpress-export-changed-since-last-time/).

### 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](https://wpimportexport.com/export-wordpress-posts-per-author-per-month/)
- [Find Outdated WordPress Posts to Refresh: Export by Last Modified Date](https://wpimportexport.com/find-outdated-wordpress-posts-export-last-modified/)
- [Incremental WordPress Exports: Export Only What Changed Since Last Time](https://wpimportexport.com/incremental-wordpress-export-changed-since-last-time/)
- [Export Posts from One 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/).
