Bulk Edit Advanced Custom Fields in a Spreadsheet

It’s simply amazing to have the opportunity of creating advanced custom fields to personalize our site, posts, or users profiles as we want. That eliminates all the limits we can have when managing our site/posts.

However, imagine you have created 10 new advanced custom fields and want to edit them quickly to update your users profiles or your posts. We don’t think you have enough time, or you’re willing to spend some hours making that change.

That’s why here we’ll show you how you can quickly and easily edit Advanced Custom Fields in a beautiful spreadsheet. This is really important if you want to save time when editing hundreds of products containing ACF.

We perfectly know how hard it can be to edit thousands of products with the normal WP editor. That’s why in this tutorial we’ll use the WP Sheet Editor Posts Spreadsheet and the WP Sheet Editor Users Spreadsheet plugin.

Edit advanced custom post fields in a spreadsheet

As you can see here, we’ve created two custom fields: one for post videos, which is basically a URL field and one for post pictures.

These two custom fields were created with the ACF plugin, and we need to edit them on two hundred products. Of course, that’s going to take us lots of hours if we open and edit them one by one.

Therefore, you need some help with that.

Install the WP Sheet Editor Posts Spreadsheet plugin

*Skip this if you already have it.

You can download the plugin here:

Download Posts, Pages, and Custom Post Types Spreadsheet Plugin

- or - Read more about it

Once you install this plugin, you’ll see how your posts and pages are displayed in a beautiful spreadsheet where you can edit freely.

This plugin contains a powerful Bulk Edit tool, which helps you apply changes on thousands of products at once.

Edit Advanced Custom Fields in the spreadsheet

Editing your Advanced Custom Fields in WP Sheet Editor Posts Spreadsheet is as simple as editing an Excel spreadsheet, The only thing you have to do is to locate the column and then edit it. In this axample, we’ve edited the Post pictures and the Post videos columns.

Bulk edit Advanced Custom Fields

Another way to edit your Advanced Custom Fields in the posts spreadsheet is with the help of the Bulk Edit tool. This tool applies changes to thousands of products at once. To open it, just click it on the toolbar.

When you open the Bulk Edit tool, you’ll see different fields to apply the changes. If you want to edit the Post videos column, you need to set these values:

Tick the I understand it will update the posts from my search checkbox.
Select Post videos as the column you want to edit.
Select Set value as the type of edit you want to apply.
Enter the new Video url in the Replace existing value with this value field.
Hit the Execute now button.

Edit advanced custom user fields in a spreadsheet

As you can see, we’ve created a Birthday field in ACF. Therefore, if we want to edit all our users’ birthdays with the normal WP editor, then we need to open and edit them one by one. However, we all know that’s going to take us lots of hours if we have many products. So here you do need some help as well.

Install the WP Sheet Editor Users Spreadsheet plugin

*Skip this if you already have it.

You can download the plugin here:

Download WordPress Users Spreadsheet Plugin

- or - Read more about it

The users spreadsheet displays all your users and their complete information. You can edit freely in the spreadsheet by just making changes in the cells you want.

Edit user custom fields in the spreadsheet

As you can see, the plugin displays the Birthday column. It shows the column values with no spaces or other signs, just the numbers. The format for the dates in YYYYMMDD. So if you want to edit them in the spreadsheet, just write the dates in that format and without spaces.

Bulk edit user custom fields

If you want to apply changes in hundreds of user custom fields at once, then you need to use the Bulk Edit tool. This tool helps you apply changes on hundreds of products at once. So just click it on the plugin’s toolbar.

When you open the Bulk Edit tool, you’ll see different fields to apply the changes. If you want to edit the Birthday column, you need to set these values:

Tick the I understand it will update the posts from my search checkbox.
Select Birthday as the column you want to edit.
Select Set value as the type of edit you want to apply.
Enter the new Birth date in the Replace existing value with this value field.
Hit the Execute now button.

Done!

As you can see, with the WP Sheet Editor Posts Spreadsheet and the WP Sheet Editor Users Spreadsheet plugins, it’s really simple to edit posts and users fields created with the Advanced Custom Fields plugin. You just need to install it, open it, and then start editing your custom fields.