Freddie Lore

WordPress Plugin Developer

How to Export Yoast SEO and All in One SEO Metadata to CSV for Bulk Editing

If you manage a WordPress website with dozens, hundreds, or even thousands of pages, manually editing SEO titles and meta descriptions one page at a time can quickly become tedious.

A more efficient approach is to export your SEO metadata to a CSV file, edit it in Excel or Google Sheets, and then import the changes back into WordPress.

This guide explains how to export SEO metadata from Yoast SEO and All in One SEO (AIOSEO) to CSV, what information you can work with, and how to use a spreadsheet to make large-scale SEO updates.

Quick answer: You can export WordPress SEO metadata to CSV, edit fields such as SEO titles and meta descriptions in a spreadsheet, and then bulk-import your changes instead of editing every post individually.

Why Export WordPress SEO Metadata to CSV?

SEO metadata is often stored individually against each WordPress post, page, or custom post type.

That works well when you’re editing a handful of pages. It becomes much less practical when you’re carrying out a larger SEO project.

For example, you might need to:

  • Rewrite SEO titles across 500 blog posts
  • Improve meta descriptions for important landing pages
  • Standardise title formats across a website
  • Identify pages using missing or outdated metadata
  • Optimise metadata after a website migration
  • Review SEO titles and descriptions as part of a content audit
  • Give a spreadsheet to a copywriter or SEO specialist for editing
  • Make bulk SEO changes without opening every WordPress post

Exporting the data to CSV turns your WordPress SEO metadata into a format that’s much easier to review and manage.

You can open the resulting file in Microsoft Excel, Google Sheets, LibreOffice Calc, or another spreadsheet application.

What SEO Data Can You Export?

The exact fields available depend on the SEO plugin and the data stored on your website.

Common fields include:

  • Post ID
  • Post title
  • URL
  • Post type
  • SEO title
  • Meta description
  • Focus keyphrase or keyphrase data
  • SEO-related metadata
  • Taxonomy information


The important distinction is that your WordPress content and your SEO metadata are separate pieces of information. Exporting the metadata gives you a practical way to audit and update those fields without having to work through the WordPress editor one page at a time.

How to Export Yoast SEO Metadata to CSV

Method 1: Use Yoast SEO’s Built-In Export

Recent versions of Yoast SEO include tools for exporting SEO information.

In the WordPress dashboard, go to:

Yoast SEO → Tools → Import and Export

Yoast provides an export function for keyphrase-related data, including options for URLs, titles, SEO titles, meta descriptions, keyphrase scores, and readability scores.

The exact options available can vary depending on your Yoast SEO version and whether you’re using Yoast SEO Premium.

Exporting Yoast data

  1. Log in to your WordPress dashboard.
  2. Go to Yoast SEO → Tools.
  3. Open Import and Export.
  4. Select the appropriate export option.
  5. Choose the fields you want to include.
  6. Generate the export.
  7. Open the resulting CSV file in Excel or Google Sheets.


Yoast also provides a bulk editor for working with SEO titles and meta descriptions directly inside WordPress, which may be more convenient if you only need to make relatively small numbers of changes.

Method 2: Export Yoast SEO Metadata Using a CSV Plugin

If your goal is to perform a broader WordPress SEO data export and bulk-editing workflow, you can use a dedicated CSV import/export plugin.

One option is Smart SEO Data CSV Import/Export.

The plugin is designed to work with SEO metadata stored by popular WordPress SEO plugins and lets you work with the data in a spreadsheet-friendly format.

So after you’re convinced your core pages’ auto-generated meta titles and descriptions are not making the cut to increase your organic click-through rates, now you’ve decided to ramp up your on-page SEO effort?

Well, certainly a good starting point is to ensure your key pages look great on SERP, with relevant meta titles and descriptions that compel site visitors about your products and services.

Sure it’s an easy thing. You just go to your page editor and type in your unique, keyword-optimised SEO meta titles and descriptions. But what if you’re dealing with tens to hundreds or even thousands of pages?

Save yourself from this hassle! Just use this WordPress plugin to export Yoast SEO and All-In-One SEO meta data and you’re good to go.

To Export Yoast SEO and All-In-One SEO Meta Data to CSV

  1. Grab your copy and install Smart SEO Data CSV Import/Export plugin and activate.
  2. Once activated, go to Settings > SEO Import/Export and click on the Export tab. The plugin automatically detects your current, active SEO plugin.export-yoast-seo-meta-data-by-post-type
  3. Choose what post types or taxonomies to export. You may optionally export posts between two dates or only exports those posts/pages with default, auto-generated SEO titles and descriptions.
  4. Hit Export to CSV button.
  5. Depending on the amount of posts you have, it should begin to export your posts and a CSV should be returned which you can download or open in Google Sheet for editing.

You’re done.

If you’re looking for a painless way to export seo meta data from Yoast SEO and All-In-One SEO Pack for bulk editing, Smart SEO Data CSV Import/Export is all you need. It’s efficient, fast and time-saver!

UP NEXT: Bulk Update Yoast SEO Meta Data or All-In-One SEO Pack Using CSV

Disclaimer: Smart SEO Data CSV Import/Export is not affiliated nor associated in any way with Yoast SEO and All-in-One SEO Pack.