---
title: "Export a Custom Post Type to Excel with Its ACF Fields"
url: "https://wpimportexport.com/export-custom-post-type-excel-acf-fields/"
description: "Export testimonials, portfolio items or team members from a WordPress custom post type to Excel, with their ACF fields as columns and filters on field values."
type: post
published: 2026-11-16T15:00:00+00:00
modified: 2026-11-14T10:45:22+00:00
categories: ["Export Guides", "Tutorials"]
tags: ["CSV Export", "Import Export by RockStarLab"]
docs_topics: ["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](https://wordpress.org/plugins/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](https://wpimportexport.com/wp-content/uploads/2026/11/01-post-type-filter.webp)

_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](https://wpimportexport.com/wp-content/uploads/2026/11/02-acf-columns.webp)

_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](https://wpimportexport.com/wp-content/uploads/2026/11/03-testimonials-sheet.webp)

_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](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) 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](https://wpimportexport.com/wordpress-import-custom-fields-acf-missing/).

## 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 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](https://wpimportexport.com/export-wordpress-post-meta-custom-fields-csv/)
- [Custom Fields and ACF Data Missing After a WordPress Import](https://wpimportexport.com/wordpress-import-custom-fields-acf-missing/)
- [Find Thin Content in WordPress: Export Word Counts for a Content Audit](https://wpimportexport.com/find-thin-content-wordpress-word-count-export/)
- [Export WordPress Posts by Date Range: a Month, a Quarter or a Year](https://wpimportexport.com/export-wordpress-posts-by-date-range/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
