Published Posts Exporter is a simple and powerful WordPress plugin that allows you to export all your published blog posts to CSV format. Perfect for marketing teams, data analysis, and bulk operations.

Key Features:

Export directly from your WordPress database
Process WordPress XML export files (WXR format)
Generate CSV file with URL, title, tags, and categories
Generate TXT file with URLs only (bonus feature)
Accessible from multiple locations: Tools menu, Settings page, and Dashboard widget
Secure file downloads with proper validation
Clean, user-friendly interface

Use Cases:

Marketing teams need post URLs and metadata for campaigns
Content audits and inventory management
Data migration and backup preparation
SEO analysis and link building
Content strategy planning

The plugin exports only published posts, excluding drafts, scheduled, and private posts. All exported data is properly formatted and ready for use in spreadsheets, databases, or other tools.

Installation

Upload the published-posts-exporter folder to the /wp-content/plugins/ directory
Activate the plugin through the ‘Plugins’ menu in WordPress
Navigate to Tools Posts Exporter to start exporting

Frequently Asked Questions

Can I export posts from an XML file?

Yes! The plugin supports both direct database export and XML file processing. Simply upload your WordPress XML export file (.xml or .wxr format) in the XML tab, and the plugin will extract all published posts.

What file formats are generated?

The plugin generates two files:
* CSV file: Contains URL, title, tags (semicolon-separated), and categories (semicolon-separated) – perfect for spreadsheets
* TXT file: Contains URLs only, one per line – useful for bulk operations

Where are the exported files saved?

Files are temporarily saved in your WordPress uploads directory and can be downloaded directly through your browser. Files are automatically cleaned up after download.

Do I need special permissions?

Yes, you need administrator privileges (manage_options capability) to use this plugin. This ensures only authorized users can export your content.

Can I export specific posts or filter by date?

Currently, the plugin exports all published posts. Future versions may include filtering options for date ranges, categories, or tags.

What happens to draft or scheduled posts?

Only published posts are exported. Drafts, scheduled posts, and private posts are excluded from the export.

Review feed

No reviews available

Screenshots

Main export page with database and XML export options - choose between exporting directly from your WordPress database or uploading an XML file
Dashboard widget for quick access - export your posts directly from the WordPress dashboard
Export results with download links - after export, download your CSV and TXT files with one click

Changelog

1.1.0

Fixed WordPress coding standards compliance
Improved security with proper input validation and output escaping
Fixed naming conventions (proper prefixes for constants, functions, classes)
Enhanced file upload validation for XML/WXR files
Added translators comments for better internationalization
Replaced unlink() with wp_delete_file() for better WordPress compatibility
Reduced README tags to meet WordPress.org requirements

1.0.0

Initial release
Database export functionality
XML file processing (.xml and .wxr formats)
TXT and CSV file generation
Admin menu, settings page, and dashboard widget
Secure file downloads with nonce verification

Back to plugins