Bulk Edit All In One SEO Data in a Spreadsheet (AIOSEO)

This is a complete guide to bulk editing All In One SEO (AIOSEO) titles, descriptions, and other SEO fields using WP Sheet Editor. You can manage your entire SEO strategy from an intuitive spreadsheet on the WordPress dashboard.

Related tutorial: Export / Import All In One SEO Data

SEO (Search Engine Optimization) is critical for driving traffic to your WordPress site. Optimizing your content ensures it gets crawled, indexed, and ranks high on search engines like Google or Bing. Without proper SEO optimization, your content may remain invisible to your audience.

But manually updating SEO fields for each post, page, or product can be a time-consuming process. The more content you manage, the more overwhelming it becomes. That’s why we’re excited to show you how to streamline your SEO tasks by managing AIOSEO data in a spreadsheet directly from your WordPress dashboard.

What you need to bulk manage AIOSEO Data

To efficiently edit All In One SEO fields in a spreadsheet, you’ll need the following plugins:

1- All In One SEO

AIOSEO is one of the most popular WordPress SEO plugins. It allows you to add meta tags, optimize content for search engines, and improve your site’s visibility.

2- WP Sheet Editor – Post Types

This powerful plugin lets you manage WordPress posts, pages, products, and custom post types in an intuitive spreadsheet. With just a few clicks, you can perform advanced searches, bulk edits, exports, and imports.

3- WP Sheet Editor – Al In One SEO extension (free)

This extension is free for WP Sheet Editor users. It adds full compatibility between WP Sheet Editor and All In One SEO, so you can easily edit all SEO fields in the spreadsheet.

---

Advantages of using WP Sheet Editor

Using WP Sheet Editor to manage All In One SEO data offers several key benefits:

1- Comprehensive bulk editing

WP Sheet Editor isn’t limited to AIOSEO fields. You can edit all fields for posts, pages, products, or custom post types, significantly boosting your productivity.

2- Centralized management

View and edit all SEO fields in one place. No need to navigate between posts or tabs to update SEO titles, descriptions, or keywords.

3- Full AIOSEO field support

WP Sheet Editor supports all AIOSEO fields, including:

• Title
• Meta Description
• Focus Keyprase
• Canonical URL
• SEO Score
• Pillar Content
• Additional Key phrases
• Keywords
• Primary Term
• Facebook Title
• Facebook Description
• Facebook Video
• Facebook Image Width
• Facebook Image Height
• Facebook Custom Image URL
• Facebook Image URL
• Facebook Object Type
• Twitter – Use Facebook Data
• Twitter Image URL
• Twitter Image URL 2
• Twitter Title
• Twitter Description
• Twitter Card Type
• Robots – Default
• Robots – No Index
• Robots – No Archive
• Robots – No Snippet
• Robots – No Follow
• Robots No Image Index
• Robots – Max Image Preview
• Limit Modified Date
• Frequency

How to Bulk Edit AIOSEO Data for Any Post Type

When you install and activate WP Sheet Editor – Post Types, it automatically creates spreadsheets for posts, pages, and WooCommerce products. If you need a spreadsheet for a custom post type, you can set one up easily by following this guide.

For this tutorial, we’ll use the posts spreadsheet as an example.

Bulk Edit AIOSEO Fields in the Spreadsheet

You can edit AIOSEO fields directly in the spreadsheet, just like you would in Excel or Google Sheets.

1- Edit SEO Titles, Descriptions, and Keywords

Navigate to the AIO: Title, AIO: Meta Description, or AIO: Focus Keyphrase columns and update the cells as needed. When finished, click Save to apply changes.

This method lets you optimize multiple posts at once without opening each one individually.

2- Update Social Media Images

To update Facebook or Twitter images, locate any of these columns in the spreadsheet:

• AIO: Facebook Custom Image URL
• AIO: Facebook Image URL
• AIO: Twitter Image URL
• AIO: Twitter Image URL 2

You can use the Upload button in each cell or double-click to paste an image URL.

3- Toggle Indexation Status

To enable or disable indexation for specific posts, go to the AIO: Robots – No Index column and tick/untick the checkbox:

• Checkbox marked (Yes) = No Index enabled (search engines won’t crawl or index).
• Checkbox unmarked (No) = Indexation enabled (search engines will crawl and index).

Once you’re done editing SEO data in the spreadsheet, make sure to click Save to apply changes.

Use AIOSEO fields as search filters

WP Sheet Editor allows you to filter posts, pages, or products based on AIOSEO field values. For example, you can:

1. Find all items with “No Index” enabled.
2. Identify posts missing SEO titles or descriptions.
3. Filter content containing specific keywords in SEO titles or descriptions.
4. Locate items without social media images for Facebook or Twitter.

To do this, use the Search tool, which lets you filter by any field.

Below, we outline how to perform specific searches using AIOSEO fields:

1- Find posts missing SEO descriptions

To locate posts without SEO titles or descriptions:

• Tick the Enable advanced filters checkbox
• Field: AIO Meta Description
• Operator: =
• Value: Leave empty
• Click Run Search.

Here are all the posts missing SEO descriptions.

2- Find Posts with Overlong SEO Titles

AIOSEO recommends SEO titles between 50 and 60 characters. To find posts with titles exceeding 60 characters:

• Tick the Enable advanced filters checkbox
• Field: AIO: Title
• Operator: CHARACTER LENGTH >
• Value: 60
• Click Run Search.

Here are the posts with SEO titles longer than 60 characters.

3- Find Posts with Long SEO Descriptions

AIOSEO suggests keeping meta descriptions under 160 characters. To find posts with descriptions exceeding this limit:

• Tick the Enable advanced filters checkbox
• Field: SEO Description
• Operator: CHARACTER LENGTH >
• Value: 160
• Click Run Search.

These are the posts with overly long SEO descriptions.

Bulk edit SEO fields for thousands of items

For large-scale updates, WP Sheet Editor’s Bulk Edit tool is a game-changer. For example, you can replace specific words in SEO titles or descriptions across multiple posts.

You can use the Bulk Edit tool to:

• Replace words in bulk in the title and meta description
• Bulk upload SEO social media images
• Disable no index in bulk
• Bulk remove canonical URLs
• Set a default image for Facebook or Twitter on posts without featured image
• Copy the post title to the SEO title
• Copy post excerpt to SEO meta description

To demonstrate, let’s replace the word “Old” with “New” in SEO descriptions:

1. Open the Search tool.
2. Select these values to find posts with “Old” in the SEO description:
   • Tick Enable advanced filters.
   • Field: AIO: Meta Description
   • Operator: CONTAINS
   • Value: Old
   • Click Run Search.

Open the Bulk Edit tool.

Select these values to replace the word:

• Select the rows to update: Edit all rows from my current search (including non-visible rows).
• What field to edit: AIO: Meta Description
• Select type of edit: Replace
• Replace this: old
• With this: new
• Click Execute Now.

This approach makes updating All In One SEO fields across thousands of posts quick and efficient.

Best Bulk Editor for AIOSEO

WP Sheet Editor is the ultimate tool for bulk editing AIOSEO fields, including titles, descriptions, keywords, and social meta data. It integrates seamlessly with the All In One SEO plugin, allowing you to optimize posts, pages, products, and custom post types effortlessly.

Boost your productivity and ensure your content is fully optimized for search engines with WP Sheet Editor.