Back to blog
5 min read Export Guides

How to Export WordPress Post Meta (Custom Fields) to CSV or Excel

Custom fields hold the data that makes a post more than text: an event’s date and venue, a recipe’s cooking time, a listing’s price. WordPress shows them one post at a time in the editor, and its built-in export tool gives you an XML file instead of a table. Import Export by RockStarLab exports post meta to CSV or Excel with one column per custom field, and can filter posts by a custom field’s value. The example is a coffee roastery’s events, with their dates, venues, prices and seats.

Free: everything in this guide works in the free plugin. ACF fields have their own group and are covered in the ACF guide.

Short Answer

  1. Go to Import Export by RockStarLab → Export and choose Posts (or Pages, or a custom post type).
  2. To export only some posts, add a Custom Field (Meta) filter with the field name, a condition and a value.
  3. Open the Custom Fields group in the field list and add the fields you need. Each becomes a column.
  4. Choose CSV or XLSX and start the export.

The posts

Each event on our blog is a post in the Roastery Events category with four custom fields: event_date, event_venue, ticket_price and seats. The training team wanted a list of the events in the Training Lab.

Filter by a custom field

Export step 2 filters: category Roastery Events, Status equals publish, and Custom Field (Meta) event_venue equals Training Lab; 2 items available
A Custom Field (Meta) filter picks the events in the Training Lab.
  • Taxonomy Filter: category Roastery Events.
  • Status equals publish.
  • Custom Field (Meta): name event_venue, condition Equals, value Training Lab.

The counter dropped from 4 events to 2. The field name is the meta key as WordPress stores it, without spaces. Besides Equals, the conditions include Contains, Greater Than, Less Than, In and Is Empty, so you can also find posts where a field was never filled in.

Add the custom fields as columns

The plugin reads the meta keys your posts use and lists them in the Custom Fields group. Each key you add becomes its own column:

Export file structure with the columns ID, Title, event_date, event_venue, ticket_price and seats
Each custom field becomes its own column.

The file headers are the field keys with a meta_ prefix. That prefix lets you import the file back later and have each column go into the right custom field. From WP-CLI or an AI agent, the post_meta field puts all of a post’s custom fields into one cell as JSON, which is useful for a backup but harder to read in a spreadsheet.

The result

ID,post_title,meta_event_date,meta_event_venue,meta_ticket_price,meta_seats
2035,"Cold Brew Masterclass",2026-05-16,"Training Lab",25,10
2034,"Latte Art Workshop",2026-04-04,"Training Lab",35,8

Open the CSV in Excel or Google Sheets, or choose XLSX on the format step to skip the import dialog. If Excel shows strange characters or puts everything in one column, see fixing CSV files in Excel.

Friendlier column names

A report for people who don’t know WordPress reads better with headers like “Date” and “Venue”. You can set your own column names. From the command line (see the WP-CLI guide):

wp rsl-ie export --type=post --status=publish \
  --fields=post_title,meta_event_date,meta_event_venue,meta_ticket_price \
  --options='{"meta_query":[{"key":"event_venue","value":"Training Lab"}],"column_headers":{"post_title":"Event","meta_event_date":"Date","meta_event_venue":"Venue","meta_ticket_price":"Price"}}' \
  --format=csv --output=training-lab-events.csv --user=admin

In our run the file started with Event,Date,Venue,Price. A file with renamed headers is meant for reading. To import it back, keep the meta_ names or map the columns by hand.

Before you import changes back

A common next step is to fix values in the spreadsheet and import them back. Back up the site first and match rows by ID so the import updates the posts instead of creating new ones (see updating posts without duplicates).

With an AI agent

An AI agent connected through the WordPress MCP Adapter (see connecting Claude Code to WordPress) can filter by a number in a custom field:

Which events have fewer than 20 seats? Give me a CSV with the event, date, venue and seats.

In our run, the agent called rsl-ie/export-count with a meta_query on seats less than 20 as a number (count: 2), then rsl-ie/export-start with the four fields and readable column names. rsl-ie/file-get returned small-events.csv with the Latte Art Workshop and the Cold Brew Masterclass.

FAQ

Why don’t I see my custom field in the list?

The Custom Fields group lists keys that posts of that type actually use. Fill the field on at least one post. Keys that start with an underscore are left out of the list, because WordPress and plugins use them internally.

Can I export custom fields of pages or custom post types?

Yes. Choose that content type on the first step; its custom fields appear in the same group.

How do I export ACF fields?

ACF fields have their own ACF Fields group with readable values; see the ACF guide linked above.

Can I filter by a number, like price above 20?

Yes. Use Greater Than or Less Than in the Custom Field (Meta) filter.

Does the export change my posts?

No. An export only reads them.

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