Back to blog
4 min read Import Guides

Bulk Update ACF Field Values with a Spreadsheet

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

  1. Export the posts with ID and the ACF Fields you want to change, as CSV.
  2. Edit the values in Excel, Google Sheets or LibreOffice. Keep the ID column and the headers as they are.
  3. 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 columns: ID, Title, and the ACF fields Origin, Roast level, Price per kg and In stock
ID, Title and the four ACF 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:

Import mapping with Auto Map: ID, post_title, acf_origin, acf_roast_level, acf_price_per_kg and acf_in_stock mapped; 6 of 6 fields mapped
Auto Map matches the acf_ columns to the ACF fields.

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

Import options: Check for Existing Items by Field ID, If Match Found Update, If No Match Found Skip
Update existing posts by ID, never create new ones.

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.

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