Back to blog
4 min read Export Guides

Export a Custom Post Type to Excel with Its ACF Fields

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

  1. In Export, choose Custom Post Types.
  2. On the filter step, set Post Type (select specific) to your post type, for example Testimonials.
  3. 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:

Custom post type export, filter Post Type (select specific) set to Testimonials (testimonial); total items available 5
Pick the post type on the filter step.

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:

Export File Structure with Title, Company (acf_company), Rating (acf_rating), Show on home page (acf_show_on_home), Content and Date
ACF fields appear under ACF Fields with their labels.

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

Spreadsheet of five testimonials with post_title, acf_company, acf_rating, acf_show_on_home, post_content and post_date
One row per testimonial, one column per field.
  • The rating is a plain number, ready to sort or average.
  • The true/false field Show on home page is 1 or 0.
  • 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.

Get the free plugin on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

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

Leave a comment

Your email address will not be published. Required fields are marked *

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE