Title here
Summary here
Content Exporter (CSV)
Export your posts, pages, and custom post type content to CSV files. Perfect for backups, content audits, client deliverables, migrations, or analysis in spreadsheet software.
Use Cases
- Create content backups as spreadsheet files for archival
- Run content audits analyzing authors, categories, publish dates, and word counts
- Deliver content to clients who want their data in a portable format
- Prepare content for migration to another platform
- Analyze publishing patterns and content gaps in Excel or Google Sheets
How It Works
- Go to the Content Exporter module settings
- Select the post type to export (Posts, Pages, or custom types)
- Choose which post status to include (Published, Drafts, All)
- Toggle which fields to include in the export
- Click “Export to CSV”
- Your browser downloads the CSV file
Where to Find It
Location: Configure and run exports in the Content Exporter module settings in Switchboard.
Export Options
Post Type Selection
Export from any registered post type:
| Post Type | Description |
|---|---|
| Posts | Blog posts and articles |
| Pages | Static pages |
| Custom Post Types | Products, Portfolios, Testimonials, etc. |
Status Filter
| Status | What’s Included |
|---|---|
| All Statuses | Everything (published, drafts, pending, private) |
| Published | Only live, public content |
| Draft | Only unpublished drafts |
| Pending | Content awaiting review |
| Private | Private posts only |
Field Selection
Choose which data to include:
| Field | Default | Description |
|---|---|---|
| ID | Always | WordPress post ID |
| Title | Always | Post/page title |
| Slug | Always | URL-friendly name |
| Status | Always | publish, draft, pending, etc. |
| Author | Always | Author display name |
| Date | Always | Original publish date |
| Modified | Always | Last modification date |
| URL | Always | Full permalink |
| Excerpt | Optional | Post excerpt/summary |
| Content | Optional | Full post body (plain text) |
| Custom Fields | Optional | All public meta fields |
CSV Output Format
The exported file is standard CSV format, compatible with:
- Microsoft Excel
- Google Sheets
- LibreOffice Calc
- Numbers (Mac)
- Any CSV-compatible software
Example Output
ID,Title,Slug,Status,Author,Date,Modified,URL
42,"Welcome to Our Blog",welcome-post,publish,"Jane Smith",2024-01-15,2024-01-20,https://site.com/welcome-post/
43,"Product Launch",new-product,publish,"John Doe",2024-02-01,2024-02-01,https://site.com/new-product/Filename Format
Files are named: {post-type}-export-{date-time}.csv
Example: post-export-2024-03-15-142530.csv
Content Analysis Tips
In Google Sheets
After importing:
- Count by Author: Use
=COUNTIF(E:E, "Author Name")to see posts per author - Filter by Date: Use filters to see content from specific periods
- Word Count: If you included content, use
=LEN(J2)-LEN(SUBSTITUTE(J2," ",""))+1
In Excel
- Use Pivot Tables to analyze content by author, date, or status
- Create charts showing publishing frequency over time
- Filter to find drafts that need attention
FAQ
How large can exports be?
The exporter handles thousands of posts. Very large exports (10,000+) may take longer and produce large files. Consider filtering by status or date range for huge sites.Is HTML preserved in the content?
No, HTML is stripped to plain text for cleaner spreadsheet compatibility. If you need HTML, use WordPress’s built-in XML export instead.Can I import the CSV back into WordPress?
This module is export-only. For importing, you’d need a CSV import plugin or use WordPress’s native import tools.What about featured images?
Featured image URLs are not included by default. Custom fields may include the image ID if stored as meta data.Are custom fields included?
Yes, when you enable “Include custom fields”, all public meta fields are exported. Private meta (starting with underscore) is excluded.For regular backups, export Published content only. For content audits, export All Statuses to catch forgotten drafts and pending content.
Large content fields may cause issues in some spreadsheet software. If you have very long posts, consider exporting without content first, then exporting specific posts separately if needed.
PRO
Upgrade to Pro
Get access to all 147 modules with a single license