How to Bulk Edit WordPress Posts, Pages, and Custom Post Types

You can bulk edit WordPress posts, pages, and custom post types by generating a spreadsheet view of your content and editing multiple entries at once instead of opening each item individually. The WordPress admin’s built-in bulk actions only let you change a handful of fields (status, category, author) for basic post types, but a spreadsheet-based editor like WP Sheet Editor – Post Types lets you edit almost every field, including custom fields, taxonomies, and file uploads, across posts, pages, and any custom post type registered by another plugin.

Why manual editing breaks down as your content grows

When you only have a few dozen posts or pages, opening each one and editing it individually is manageable. Once you’re managing hundreds of entries, the default WordPress editor turns every update into a repetitive task. You click into a post, make a change, save, go back to the list, open the next one, and repeat. Multiply that by a few hundred items and you’re looking at hours of work for something that should take minutes.

Manual editing also introduces inconsistency. When you update dozens of listings or products by hand, it’s easy to forget to update one field on a few items, use slightly different formatting, or skip an entry entirely. That’s why bulk editing tools exist: they let you view and change many records at once from a single screen, the same way you’d clean up a spreadsheet of data rather than editing each row in a separate window.

The WP Sheet Editor – Post Types plugin builds this spreadsheet view directly into your WordPress dashboard. Instead of relying on the limited bulk actions built into the post list screen, you get a full spreadsheet where each row is a post, page, or custom post type entry, and each column is a field you can edit directly.

Getting started: install and activate WP Sheet Editor

You can get the premium version of WP Sheet Editor – Post Types by clicking on the button below.

After completing the payment process, you will get a zip file that you need to install as a plugin on your website.

1. Go to Plugins > Add New Plugin.
2. Click on Upload plugin.
3. Click on Choose file.
4. Locate the file on your computer.
5. Click on Install now.
6. Click on Activate plugin.
7. Enter your license and click on Activate License.

Edit any WordPress post type in a spreadsheet

After activating the license, you can generate a spreadsheet for any post type. This includes standard post types like posts and pages, and any custom post type added using third-party plugins.

You can generate a spreadsheet for recipes, a spreadsheet for products, a spreadsheet for downloads, a spreadsheet for directory listings, and so on. Any custom post type registered on your site can be pulled into the spreadsheet and edited there.

To generate a spreadsheet, go to WP Sheet Editor > Setup spreadsheet. Once there, select the post type you want to edit and click on Save.

You can enable or disable specific columns before generating the spreadsheet. Drag and drop the columns to the left or right side to turn them on or off, then click on Save once you’re satisfied with the layout.

With these steps, you can generate spreadsheets for any WordPress post type, including:

• Posts
• Pages
• Lessons
• Quizzes
• Recipes
• Downloads
• Teams
• Groups
• Forums
• Topics
• Replies
• Forms
• And any other WordPress post type!

Customize the spreadsheet columns

If you want to simplify or reorganize your spreadsheet, you can hide, sort, or rename columns. Open the Columns manager tool to do this.

Once inside the columns manager, you can hide, sort, show, rename, and even change the type of a column, for example switching a text field to a dropdown.

After customizing the columns, you can save the layout for future sessions:

• Check the Save these settings for future sessions checkbox.
• Add a name for this group of columns: Add a name here.
• Click on Apply settings.

Quick editing WordPress content in a spreadsheet

One way to save time managing WordPress content, whether posts, pages, or custom post types, is editing directly in the spreadsheet instead of opening each entry separately.

Quick editing in the spreadsheet means you don’t have to open items one by one to change a field. You can edit a single field across hundreds of entries at once, or edit multiple fields the way you would in Excel or Google Sheets.

Text editor fields

If a field uses a text editor, clicking on the cell opens a popup showing that editor. Depending on what you’ve enabled, this could be the Gutenberg editor or the classic editor.

In this example, the text editor field has opened the popup and is showing the Gutenberg editor for that entry.

Drop-down fields

Drop-down fields show you the available options when you double-click on the cell, so you can select a value without typing it manually.

Checkbox fields

Checkbox fields let you check or uncheck the box directly in the cell, useful for toggling settings like “featured” or “in stock” across many entries at once.

File upload fields

File upload fields let you upload files directly. Click the upload button, or double-click the cell to paste a URL as plain text instead.

Clicking the Upload file button opens a popup where you can upload a new file or select an existing one from the media library.

Taxonomy term fields (category, tag, custom taxonomy, etc.)

For taxonomy fields such as categories, tags, or attributes like colors, sizes, brands, and materials, you can view existing terms or add new ones by typing directly into the cell. Click a term to add it, or remove it by clicking the “X” next to it.

Simple text fields

Plain text fields work exactly as you’d expect: click and edit the text. Across all field types, you can also autofill values downward the same way you would in Excel or Google Sheets.

Create hundreds of duplicates quickly

WP Sheet Editor includes a duplication tool that creates hundreds of copies of posts, pages, and custom post types at once. This lets you build a master item, generate as many copies as you need, and then edit each one’s details in the spreadsheet.

To create duplicates, click Duplicate.

Once you’re in the Duplicate tool, select these values:

• Duplicate this item: Select the item or items you want to duplicate.
• How many copies do you want: Add the number of copies you want to create for each item.
• Click on Execute.

Below, you can see copies of one WordPress post created through this process. This is a practical way to generate multiple posts, pages, or custom post type entries from a single master item.

Advanced search for posts, pages, and custom post types

With WP Sheet Editor – Post Types you can filter posts, pages, or any custom post type using advanced search filters instead of scrolling through a long list.

The Search tool lets you search using any field as criteria, including title, content, description, category, tag, custom taxonomy, author, featured image, and any other available field.

As an example, here’s how to search for WordPress posts matching these parameters:

• Keyword in title = tropical
• Author = John Doe
• Category = Gardening
• Status = Published

To do this, select these values in the Search tool:

• Contains keyword: Add the desired keyword here.
• Author: Add the desired post author here.
• Enter categories, Tags, or Formats: Enter the desired category here.
• To search for posts by status, tick the Enable advanced filters checkbox and select the following values:
  • Field: Status
  • Operator: =
  • Value: Published
• Click on Run search.

Once you run the search, the spreadsheet displays all posts matching the criteria, with the active filters listed above the spreadsheet so you can see exactly what’s being shown.

Bulk edit WordPress posts, pages and custom post types

Bulk updating WordPress content is useful across a wide range of site types. Here are some situations where editing content in a spreadsheet makes more sense than editing item by item:

• Products: If you manage an online store, you can bulk update prices, change categories, or adjust stock levels for multiple products at once.
• Real estate listings: If you manage a real estate website, you can bulk edit property details such as prices, statuses (like sold or available), and descriptions across multiple listings simultaneously.
• Event listings: If you organize events, you can bulk update event dates, times, locations, and descriptions. Whether you’re rescheduling events or updating venue details, bulk editing keeps your event information consistent for attendees.
• Restaurant menus: If you run a restaurant, you can bulk update your menu, adjusting dish prices, adding new dishes, or updating descriptions so your menu reflects your current offerings.
• Job listings: If you run a job board or staffing agency website, you can bulk change job statuses, revise descriptions, or change categories for multiple listings at once.
• Custom forms and submissions: If your website collects form submissions, you can bulk manage them, updating statuses, categorizing entries, or editing responses across multiple forms.
• Service listings: If you offer services online, bulk editing helps keep your catalog organized, whether you’re updating descriptions, changing categories, or revising pricing.

In this example, the Bulk Edit tool is used to add a new category to all the posts filtered in the previous section. These posts already have a category, and the goal is to assign them an additional one.

Once you’re in the Bulk Edit tool, select these values:

• Select the rows that you want to update: You can select any of these options:
  • Edit all the rows from a specific search
  • Search for specific rows and edit the search results
  • Edit all the rows you manually selected in the spreadsheet
• What field do you want to edit: You can select any field here. In this case, the Categories field.
• Select type of edit: The types of edits available depend on the field you’ve selected. Since a new category is being added to posts that already have one, Append is selected.
• Terms: Add the category here.
• Click on Execute Now.

The result: the new category has been added to all the filtered posts, and it’s reflected immediately in the column.

The Bulk Edit tool lets you update hundreds or thousands of items in WordPress without opening them one by one, which saves significant time on repetitive updates.

Bulk edit offline (export to CSV)

If you’d rather work offline, you can export your posts, pages, or custom post types to a CSV file, make your changes there, and import them back into WordPress afterward.

Start by opening the Export tool.

Once you’re in the Export tool, select these values:

• What columns do you want to export: You can export specific columns, all active columns (visible in the spreadsheet based on your current configuration), or every column, active or inactive.
• Which rows do you want to export: You can export all posts, results from a specific search, or only rows you’ve manually selected in the spreadsheet.
• What app will you use to edit this file: You can select any of these options:
  • Microsoft Excel (Office 365)
  • Older versions of Microsoft Excel
  • Google Sheets
  • Other
• Name of this export: Add a name for this export so you can reuse it later by hovering over the Export tool.
• Click on Start new export.

Below is an example of WordPress posts exported to a CSV file. From here, the data can be updated in the spreadsheet application and then imported back into WordPress.

Import posts, pages, and custom post types

After editing your content in a CSV file, you can use the Import tool to bring in new content or apply changes to existing content.

Select the CSV file you’ll import by choosing these values:

• Source: You can select any of these options:
  • CSV file from my computer (used in this example)
  • CSV file from URL
  • Copy and paste from another spreadsheet or table
  • CSV file in the server
• Since this example imports a CSV file from the computer, click on Choose File and select the file.
• Click on Next.

You can choose to Import all the columns or Select individual columns to import.

Next, decide how the data should be imported:

• Do you want to update or create items: You can select any of these options:
  • Create new items and update existing items
  • Import all rows as new
  • Only create new items, ignore existing items
  • Only update existing items, ignore new items
• If you select an option that updates existing items, you’ll need to match rows using a field, the ID field is recommended for accuracy.
• Click on Next.

Finally, you’ll see a preview of the import. If everything looks correct, click on The preview is fine, start import.

How this compares to WordPress’s built-in bulk edit

The bulk actions built into the WordPress posts and pages list screen only cover a small set of fields: status, author, category, tags, comment settings, and a few others depending on the post type. They also apply the same value to every selected item at once, so you can’t set different values per row in the same action.

A spreadsheet-based editor removes that limitation. Because every row is editable individually, you can set a different price, title, or custom field value for each entry while still working through hundreds of them in one session. Custom fields, taxonomies added by other plugins, and file upload fields, none of which show up in the native bulk edit panel, are all editable in the spreadsheet.

A complete bulk editor for WordPress post types

WP Sheet Editor – Post Types gives you a spreadsheet interface similar to Excel or Google Sheets for managing posts, pages, and custom post types added by third-party plugins.

Whether you’re changing titles, categories, or content details, everything happens in one place. You can also search, duplicate, and export or import data. It’s built for anyone managing a large volume of WordPress content who needs to make changes without opening each item individually.

Frequently asked questions on bulk editing WordPress content

Can I edit custom post types and custom fields added by third-party plugins?

Yes. You can edit custom post types and custom fields created with plugins such as Custom Post Type UI, Toolset Types, Pods (Custom Content Types and Fields), Advanced Custom Fields, Meta Box, Custom Post Types and Custom Fields Creator (WCK), and plugins used for selling downloads, lessons, recipes, or product reviews, among many others.

Can I edit content from multilingual plugins?

Yes. Content created with multilingual plugins such as WPML and Polylang can be edited in the spreadsheet the same way as any other post type.

When importing content, will all the data be overwritten?

No. Only the fields you’ve actually changed in the import file get overwritten. Any data that wasn’t modified stays exactly as it was before the import.

Can I undo a bulk edit if I make a mistake?

Before running a bulk edit or import, it’s worth exporting a backup of the affected rows to CSV first. That gives you a copy of the original values you can re-import if a change needs to be reversed. There is no single “undo” button that reverts a bulk action automatically, so having that export on hand before making large changes is the safest approach.

Is there a limit to how many posts or pages I can edit at once?

The spreadsheet is built to handle large volumes of content, including sites with thousands of entries. Performance depends on your hosting environment, so on very large sites it’s common to filter down to a specific set of rows with the Search tool before running a bulk edit, rather than applying a change to the entire post type at once.

Does bulk editing work with WooCommerce products as well as regular post types?

Product data in WooCommerce is stored as a custom post type with its own custom fields, so it can be edited the same way as any other custom post type in the spreadsheet, including prices, stock levels, and categories.