New prices for the whole range, a field that has to switch from “yes” to “no” on dozens of posts, a typo in a value repeated everywhere: changing ACF fields one post at a time means opening each post, scrolling to the field group and saving. With Import Export by RockStarLab you export the ACF fields to a spreadsheet, change the values there, and import the file back by post ID. The example uses four coffee posts on a roastery’s site with an ACF field group “Coffee details”.
Free: ACF fields on posts and pages. PRO: the same for custom post types and WooCommerce products.
Short Answer
- Export the posts with ID and the ACF Fields you want to change, as CSV.
- Edit the values in Excel, Google Sheets or LibreOffice. Keep the ID column and the headers as they are.
- Import the file with Check for Existing Items by Field set to ID, If Match Found set to Update and If No Match Found set to Skip.
Export the current values
Our field group has four fields: Origin (text), Roast level (select with Light, Medium, Dark), Price per kg (number) and In stock (true/false). In Export, choose Blog Posts. To export only the posts you want to change, add a filter; we used Title with the condition In and the four titles separated by commas. On the columns step, clear the defaults and add ID, Title and the fields from the ACF Fields group:

Export as CSV. The file:
ID,post_title,acf_origin,acf_roast_level,acf_price_per_kg,acf_in_stock
2045,"Guatemala Antigua",Guatemala,dark,26,1
2044,"Colombia Huila",Colombia,medium,28,1
2043,"Ethiopia Yirgacheffe",Ethiopia,light,32,1
2042,"Brazil Cerrado",Brazil,medium,24,1
The headers start with acf_, which is how the import recognises them as ACF fields. A select field exports its stored value (medium), not the label you see in the editor (Medium), and a true/false field exports 1 or 0.
Edit the values
We raised three prices, changed Colombia Huila from medium to light roast, and marked Guatemala Antigua as out of stock:
ID,post_title,acf_origin,acf_roast_level,acf_price_per_kg,acf_in_stock
2045,"Guatemala Antigua",Guatemala,dark,26,0
2044,"Colombia Huila",Colombia,light,30,1
2043,"Ethiopia Yirgacheffe",Ethiopia,light,34,1
2042,"Brazil Cerrado",Brazil,medium,25,1
Write select values the same way they were exported (light, not Light), and true/false as 1 or 0. Don’t change the ID column: it is how each row finds its post.
Import by ID
In Import, choose Blog Posts, upload the file and click Auto Map. All six columns are mapped, the acf_ columns to their ACF fields:

On the options step, match by ID, update matches and skip rows that don’t match any post:

The import reported 4 updated and 0 created. Reading the fields back with ACF afterwards: Colombia Huila has Roast level light and a price of 30, and Guatemala Antigua has In stock off; the field references ACF needs were kept. Titles and Origin were in the file unchanged, so they stayed the same. To touch only the fields you changed, remove the other columns from the file or their mappings with the × button.
Before you import
An import by ID overwrites the mapped fields on every matching post. Try it with a file of two or three rows first, and back up the site before updating hundreds of posts.
With an AI agent
An AI agent connected through the WordPress MCP Adapter (see connecting Claude Code to WordPress) can check the result after the import:
Show the roast level, price per kg and stock of our four coffee posts.
In our run, the agent called rsl-ie/export-preview for Blog Posts with the fields acf_roast_level, acf_price_per_kg and acf_in_stock and a Title filter. It returned the new values: Colombia Huila light and 30, Ethiopia Yirgacheffe 34, Brazil Cerrado 25, Guatemala Antigua with in stock 0.
FAQ
Do I need the field group on the site?
Yes. ACF fields appear in the export and the mapping only when their field group exists and applies to that post type. See ACF data missing after an import.
Can I update repeater or image fields the same way?
Simple fields are covered here: text, number, select and true/false. For repeaters and images, see importing ACF repeater, flexible content and image fields.
Can I use Excel files instead of CSV?
Yes, the import also reads XLSX and ODS files. Keep the same headers and the ID column.
What happens to posts that aren’t in the file?
Nothing. Only the posts whose IDs are in the file are updated.
Related Guides
- How to Bulk Update Existing WordPress Posts without Creating Duplicates
- Export a Custom Post Type to Excel with Its ACF Fields
- Custom Fields and ACF Data Missing After a WordPress Import: Causes and Fixes
Get the free plugin on WordPress.org.

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