---
title: "Bulk Update ACF Field Values with a Spreadsheet"
url: "https://wpimportexport.com/bulk-update-acf-field-values-spreadsheet/"
description: "Change ACF field values on many WordPress posts at once: export them to a spreadsheet, edit, and import back by ID so only those fields change."
type: post
published: 2026-11-17T11:00:00+00:00
modified: 2026-11-14T10:45:31+00:00
categories: ["Import Guides", "Tutorials"]
tags: ["CSV import", "Import Export by RockStarLab"]
docs_topics: ["Export guides", "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](https://wordpress.org/plugins/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](https://wpimportexport.com/wp-content/uploads/2026/11/01-columns.webp)

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

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

_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](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) before updating hundreds of posts.

## 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 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](https://wpimportexport.com/wordpress-import-custom-fields-acf-missing/).

### 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](https://wpimportexport.com/how-to-import-posts-pages-custom-post-types-with-acf-pro-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](https://wpimportexport.com/how-to-bulk-update-existing-wordpress-posts-without-creating-duplicates/)
- [Export a Custom Post Type to Excel with Its ACF Fields](https://wpimportexport.com/export-custom-post-type-excel-acf-fields/)
- [Custom Fields and ACF Data Missing After a WordPress Import: Causes and Fixes](https://wpimportexport.com/wordpress-import-custom-fields-acf-missing/)

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