Part 1: Accessing and Setting Up the Spreadsheet

1. Look at your main left-hand WordPress dashboard menu.
2. Hover over WP Sheet Editor and click on Setup.
3. Locate the list of checkboxes asking which post types you want to edit.
4. Check the boxes next to Posts and Pages, then scroll down to click Save.
5. Go back to your main left-hand WordPress menu.
6. Click Edit Posts or Edit Pages to load the full-screen spreadsheet view.

Part 2: Best Practices for Editing Content

• Customize Your View: Click the Columns button in the top toolbar to open the side panel. Drag any columns you do not need into the "Hidden" list so you can focus only on what matters.
• Edit Rapidly: To change a title, category, or date, simply click directly into the cell and type. Press the down arrow on your keyboard to immediately drop to the next post.
• Save Your Work: The spreadsheet does not save automatically as you type. You must click the green Save button at the top of the toolbar when you are finished.
• Export for Reports: If you need to share data, click the Export button on the top toolbar to download your current view as a CSV file.

Part 3: Managing Redirects

To manage redirects directly within this grid, your site will need the WP Sheet Editor – Redirection extension installed alongside the main plugin.

• Automatic Cleanup: When you delete duplicates or merge posts, the extension automatically redirects the deleted post URLs to the new, unique post.
• Slug Changes: If you rename a file or change a post slug directly in the spreadsheet, the tool automatically creates a 301 redirect from the old URL to the new one.
• Manual Entry: The extension adds a dedicated "Redirects" column to your spreadsheet. You can type a target URL into this cell for any post to instantly create a custom redirect without leaving the page.

Changing categories in bulk is where WP Sheet Editor truly shines! If you have ever tried doing this through the standard WordPress menu, you know how tedious it can be.

Since the plugin works just like a spreadsheet, you actually have two incredibly fast ways to do this, depending on exactly how many posts you need to update.

Here are the quickest methods to get this done.

Method 1: The "Copy & Paste" Way (Best for 10-50 posts)

If you just want to quickly drag a new category down a list of posts, you can treat it exactly like Microsoft Excel.

1. Open your WP Sheet Editor for Posts.
2. Ensure your Categories column is visible. (If it is not, click the Columns button on the top toolbar to unhide it).
3. Click into the Category cell for your first post and type or select the new category.
4. Click on that newly updated cell and press Ctrl+C (or Cmd+C on Mac) to copy it.
5. Click and drag your mouse down the rest of the column to highlight the cells for all the other posts you want to change.
6. Press Ctrl+V (or Cmd+V) to paste the new category into all of them instantly.
7. Click the green Save button located at the very top of the spreadsheet toolbar.

Note: Unlike Google Sheets, it does not save automatically as you type. You must click Save to make the category changes live!

Method 2: The "Bulk Edit" Tool (Best for 50+ posts)

If you have hundreds of posts and don't want to drag your mouse down the screen, the built-in Bulk Edit tool is the absolute fastest route.

1. Look at the top toolbar of your WP Sheet Editor and click the Bulk Edit button (it usually looks like a stack of blocks or has a magic wand icon).
2. Choose which posts you want to edit. You can select "Edit all the rows from my current search" to change everything on the screen.
3. In the field dropdown that appears, select Categories.
4. Choose the type of edit you want to make (e.g., select Set value to replace the old category entirely, or Append value to add a second category alongside the existing one).
5. Type in the name of your new category in the value box.
6. Click Execute Now.

The plugin will process the changes in the background, and all of your posts will be updated to the new category in seconds.