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 custom fields for these post types
The spreadsheets of WP Sheet Editor allow you to edit a lot of custom fields for the following post types:
- Products
- Users
- Pages
- Taxonomies
- Downloads (EDD)
- Posts
- Events
- Etc.
Something worth mentioning
Whenever you add a new post type, you’ll see it as a column on the spreadsheet. Sometimes you’ll have several options to edit your custom fields.
- The Map fields will appear on the spreadsheet as a column with the coordinates on it.
- The Content column can be edited using the Gutenberg or the Classic Editor (Tinymce) editor because you can click on the popup button to open the Block editor, or you can double-click it to open the HTML editor:
For now, we want to show you how to…
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
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.
You can filter your posts to select the ones you want to edit. For this, just select the I want to search rows to update option in the Select the rows that you want to update dropdown.
Once there, you’ll find these search fields for you to filter your posts:
- Contains Keyword: Enter any specific keyword to search for all posts containing it.
- Status: Draft. Private. Publishet. Etc.
- Author: Enter any author’s name to search for all of his posts.
- Categories, Tags, Formats: Enter any of those three search parameters.
Once you decide how you’ll filter your posts, click on Run search, and it will filter your posts and take you back to the Bulk Edit fields.
Now you need to select these values to edit your custom fields. For example, you can edit your Post Videos using these values.
- Select the rows that you want to update: I want to select rows to update
- What field do you want to edit: Post Videos
- Select type of edit: Set value
- Replace existing value with this value: Enter post video URL.
- Click on Execute now.
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
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.
Once there, you can filter your users custom fields. Just select the I want to select rows to update option in the Select the rows that you want to update dropdown.
You’ll find these search fields:
- Login, Email, Name: Enter any of those search parameters.
- Role: Enter any user role to filter all users with this role.
Once you select how you’ll filter the users, click on Run search to filter your users.
If you want to edit the Birthday column for example, you need to set these values:
- Select the rows that you want to update: I want to select rows to update.
- What field do you want to edit: Birthday
- Select type of edit: Set value
- Replace existing value with this value: Enter the new Birth date
- 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.
Install the WP Sheet Editor Posts Spreadsheet plugin
You can download the plugin here:
Download Posts, Pages, and Custom Post Types Spreadsheet Plugin - or - Read more
Install the WP Sheet Editor Users Spreadsheet plugin
You can download the plugin here:
Download WordPress Users Spreadsheet Plugin - or - Read more