Testimonials, portfolio items, team members, locations: many sites keep them in a custom post type, often with Advanced Custom Fields for the details. WordPress’s own exporter writes them to an XML file for another WordPress site, not to a spreadsheet, and ACF values end up buried in it. With Import Export by RockStarLab PRO, you choose the post type, pick the ACF fields as columns and get an Excel file with one row per item. The example exports a coffee roastery’s customer testimonials.
PRO: custom post type export is part of PRO. Free: posts and pages, including their custom fields and ACF fields.
Short Answer
- In Export, choose Custom Post Types.
- On the filter step, set Post Type (select specific) to your post type, for example Testimonials.
- Add Title, Content, Date and your fields from ACF Fields, and export to XLSX.
Choose the post type
Our Testimonials post type, created with ACF, has five entries. Each has a title, the quote as content, and three ACF fields: Company, Rating (1 to 5) and Show on home page (true/false). On the filter step, the first filter selects the post type:

The list shows every registered post type, including technical ones like Field Groups or Navigation Menus; pick yours by name.
Pick the fields
The field list has the standard post fields, Custom Fields and a separate ACF Fields group. ACF fields appear with their labels, so you don’t have to know the field names:

The columns are named acf_ plus the field name, for example acf_company. Rename them with the pencil icon if the file is for someone outside the team. The same values are also listed under Custom Fields as meta_company and so on; either works for simple text and number fields.
The result

- The rating is a plain number, ready to sort or average.
- The true/false field Show on home page is
1or0. - The newest testimonial is first; sort in the spreadsheet as you like.
Filter by a field value
To export only some items, add a Custom Field (Meta) filter with the field name. For example, rating Greater or Equal 4 keeps the four testimonials rated 4 or 5, a good shortlist for the home page.
Before you import changes back
An export only reads your content. If you edit the file and import it back, for example to update ratings in bulk, back up the site first and include the ID column so the existing items are updated. If ACF values don’t arrive, see custom fields missing after an import.
With an AI agent
An AI agent connected through the WordPress MCP Adapter (see connecting Claude Code to WordPress) can answer questions about the post type directly:
Which testimonials have a rating of 4 or more, and which of them are shown on the home page?
In our run, the agent called rsl-ie-pro/export-preview with the post type testimonial and the custom field filter rating equals_or_greater 4. It returned four testimonials with their company, rating and home page flag; two of them, from Hotel Aurora and Café Lumen, had acf_show_on_home set to 1.
FAQ
Does this work with post types registered by a theme or plugin?
Yes. Every registered post type is listed, whether it comes from ACF, a theme, a plugin or code.
Can I export several post types at once?
Run one export per post type, so each file has the columns that fit it.
Do I need ACF to export custom fields?
No. Fields stored as post meta by any plugin appear under Custom Fields.
Related Guides
- How to Export WordPress Post Meta (Custom Fields) to CSV or Excel
- Custom Fields and ACF Data Missing After a WordPress Import
- Find Thin Content in WordPress: Export Word Counts for a Content Audit
- Export WordPress Posts by Date Range: a Month, a Quarter or a Year
Get the free plugin on WordPress.org.

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