Plugins Plugin hub Backup SEO Caching Security Forms WooCommerce Images Best backup plugins
Hosting Hosting directory Shared hosting Managed WordPress Cloud hosting VPS hosting By reader location Hosting finder
Themes & builders Compare Rank Math vs Yoast
Tools All tools Hosting finder Plugin stack builder Cost calculator Salt generator Theme detector Who is hosting this? Speed test Headline analyzer robots.txt generator Redirect generator Uptime calculator Blog name generator
Blog Best backup plugins Deals
Guides All guides Speed up WordPress Choose hosting Back up WordPress
How we test

SEO & AI search · Guide

How to Export Yoast SEO Data (Step by Step)

How to Export Yoast SEO Data (Step by Step)

Short answer

Export Yoast settings from Yoast SEO, Tools, Import and Export, then the Export settings tab. Per-post SEO titles, meta descriptions and keyphrases are post meta, so export them with the WordPress exporter under Tools, a CSV export plugin, or the database.

Key takeaways

  • Yoast settings and per-post SEO data are exported separately.
  • The settings export gives you text you paste into another site.
  • The WordPress XML export carries SEO titles and descriptions with each post.
  • Use a CSV export plugin when you want a spreadsheet for audits.
  • Rival SEO plugins can import Yoast data directly without a manual export.

How do you export Yoast SEO data?

You export Yoast SEO data in two parts: the plugin settings from Yoast SEO's Import and Export tool, and the per-post SEO data through a WordPress or database export.

That split surprises a lot of people. Yoast keeps its global settings in one place and its post-level data, such as SEO titles and meta descriptions, in another.

So export Yoast SEO data can mean three different jobs:

  • Copying your Yoast settings to another site
  • Saving titles, meta descriptions and focus keyphrases for a backup or audit
  • Moving everything to a new site or a new SEO plugin

This guide covers all three. Pick the section that matches what you need, or follow them in order for a full export.

Where does Yoast SEO store its data?

Yoast stores site-wide settings in the WordPress options table and per-post SEO fields in the post meta table, with a separate indexables table that it can rebuild.

Knowing this tells you which export tool to use. Here is the short version:

DataWhere it livesBest way to export
Plugin settings (search appearance, social, site info)wp_options rows such as wpseo and wpseo_titlesYoast SEO Import and Export tool
SEO title, meta description, focus keyphrase per postwp_postmeta keys starting with _yoast_wpseo_WordPress export, CSV plugin or database
Term SEO data (categories, tags)wp_options row wpseo_taxonomy_metaDatabase export
Indexables and linkswp_yoast_indexable and related tablesNot needed, Yoast rebuilds them
Redirects (Premium)Options table and optional server filesRedirects export in Yoast SEO Premium

The post meta keys are the ones most people care about. The common ones are _yoast_wpseo_title, _yoast_wpseo_metadesc and _yoast_wpseo_focuskw.

You don't need to memorise them. They matter only when you export straight from the database or map columns in a CSV tool.

How do you export Yoast SEO settings?

Go to Yoast SEO, then Tools, then Import and Export, open the Export settings tab and click the export button to get a block of settings text you can copy.

Step by step:

  1. Log in to your WordPress dashboard as an administrator.
  2. In the left menu, open Yoast SEO and click Tools.
  3. Click Import and Export.
  4. Open the Export settings tab.
  5. Click the button to export your Yoast SEO settings.
  6. Copy the text that appears and save it in a plain text file.

Yoast's own Import and export help page shows the current screens. Menu labels shift a little between versions, so check it if your screen looks different.

To use the settings on another site, open the same Import and Export screen there, choose the Import settings tab, paste the text and import it.

Two things to keep in mind. The settings export does not include your SEO titles or meta descriptions for individual posts. It also doesn't carry over Premium licence keys, so you reconnect those on the new site.

If you are setting up Yoast fresh, our Yoast SEO setup guide walks through each settings screen.

How do you export SEO titles and meta descriptions?

The easiest route is the built-in WordPress exporter under Tools, then Export, because the XML file it creates includes post meta, and Yoast's fields are post meta.

Follow these steps:

  1. In WordPress, go to Tools and click Export.
  2. Choose All content, or pick Posts or Pages only.
  3. Click Download Export File.
  4. Save the XML file somewhere safe.

The WordPress Tools Export screen documentation explains each option. When you import this file on another WordPress site with the WordPress Importer, the Yoast fields come along with each post.

This is the best choice for moving content between two WordPress sites. It's less handy for reading or editing data, because XML isn't easy to scan.

Export to a spreadsheet instead

If you want a CSV you can open in Excel or Google Sheets, use an export plugin. Tools such as WP All Export let you pick post fields and custom fields, including the _yoast_wpseo_ keys, and save them as columns.

A CSV is useful for:

  • SEO audits of titles that are too long or missing
  • Finding duplicate meta descriptions
  • Handing a content list to a writer or client
  • Keeping a dated snapshot before a big change

Check the plugin's documentation for the exact steps. Most of them work the same way: choose a post type, add fields, then run the export.

Can you export focus keyphrases from Yoast?

Yes, focus keyphrases are stored as post meta, so any of the methods above capture them, and Yoast SEO Premium has its own export option for keyphrases.

The focus keyphrase sits in the _yoast_wpseo_focuskw field. A WordPress XML export or a CSV export that includes that field will save it.

Yoast also explains how to export focus keyphrases with Yoast SEO Premium. The Premium feature gives you a ready-made CSV with keyphrases and scores, which saves you from mapping fields yourself.

A keyphrase list helps you spot two posts targeting the same phrase. That is a common cause of pages competing with each other in search.

How do you export Yoast data from the database?

Open phpMyAdmin or a similar tool, export the rows in wp_postmeta where meta_key starts with _yoast_wpseo_, and add the Yoast rows from wp_options for settings and term data.

This route suits developers and site owners who are comfortable with SQL. Always take a full backup before you touch the database, even for a read-only export.

A simple query to see the data looks like this:

SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE meta_key LIKE '\_yoast\_wpseo\_%';

Change wp_ to your own table prefix if it is different. You can find the prefix in wp-config.php. Our guide on where to find wp-config.php shows where that file sits.

In phpMyAdmin, run the query, then use the Export link under the results to save it as CSV or SQL. For settings, export the wp_options rows whose option_name starts with wpseo.

The phpMyAdmin documentation covers its export formats if you need a format other than CSV or SQL.

You can also export through WP-CLI. The wp db export command saves the whole database, which is the safest full copy before a migration.

How do you move Yoast data to a new site?

Export the settings text from Yoast, export your content with the WordPress exporter, then import both on the new site and let Yoast rebuild its indexables.

Here is the order that causes the fewest problems:

  1. Install WordPress and Yoast SEO on the new site.
  2. Import your content XML with the WordPress Importer.
  3. Paste your Yoast settings text into the Import settings tab.
  4. Check a few posts to make sure SEO titles and descriptions came across.
  5. Run the SEO data optimisation that Yoast offers in its tools, so it builds its indexables.
  6. Test your sitemap and a few page titles in the browser.

If you're moving the whole site rather than just the content, a full migration plugin or host migration is simpler. It copies the database as a whole, so every Yoast field travels with it. See our guide on how to move a WordPress site without losing SEO for the checks to run after the move.

After any move, open your sitemap index. If it returns a 404, our Yoast sitemap 404 fix covers the usual causes.

How do you move Yoast data to another SEO plugin?

Most rival SEO plugins include an importer that reads Yoast's post meta directly, so you usually don't need to export anything by hand.

For example, Rank Math, All in One SEO and SEOPress each offer a Yoast import option in their setup or tools screens. They read the same _yoast_wpseo_ fields and copy them into their own format.

Before you switch:

  • Take a full backup of the site
  • Export your Yoast settings text as a record
  • Save a CSV of titles and descriptions for comparison
  • Leave Yoast active until the import finishes

Then deactivate Yoast once you have checked a sample of pages. Running two SEO plugins side by side for long can create duplicate meta tags. Our article on using Rank Math and Yoast together explains why.

If you're going the other way, our guide on importing Yoast settings into Rank Math covers that tool step by step.

What does a Yoast export not include?

A Yoast export does not include your licence, the indexables tables, redirects stored in server files, or data from separate Yoast add-ons unless you export those parts on their own.

Here is a quick checklist of things people often miss:

  • Premium redirects. Export them from the Redirects screen in Yoast SEO Premium, or note them down.
  • Term SEO data. Category and tag titles live in the options table, not post meta.
  • Schema settings per post. These are post meta too, so a full meta export covers them.
  • Social images. The image URL is saved, but the file itself lives in your media library.
  • Search Console links. Reconnect those on the new site.

If you rely on redirects, our guide on using Yoast SEO redirects shows where they are managed.

What problems can you hit when exporting Yoast data?

The most common problems are missing meta after import, wrong table prefixes in SQL, and settings text that fails to import because it was cut short when copied.

Here is how to fix each one:

  • Titles missing after import. Check that Yoast was active on the new site and that you used the WordPress Importer, not a plain post copy.
  • Empty SQL results. Your table prefix is probably not wp_. Check wp-config.php and update the query.
  • Settings import fails. Copy the full block again. Paste it into a plain text editor first, not a word processor.
  • Old titles show on the front end. Clear your page cache and any CDN cache, then reload.
  • Sitemap looks wrong. Re-save permalinks and let Yoast finish its data optimisation.

If Yoast itself is acting up after the move, our Yoast SEO not working guide has more checks.

How often should you export Yoast SEO data?

Export your Yoast settings after any big settings change, and keep a dated CSV of titles and descriptions before redesigns, migrations or plugin switches.

You don't need a weekly routine for this. Regular full-site backups already include every Yoast field. A separate export is a light extra safety net and a handy audit file.

A sensible habit:

  1. Save the settings text whenever you change Search Appearance or social settings.
  2. Export a CSV of SEO fields once a quarter for audits.
  3. Take a full backup before every migration or plugin swap.

That covers you if a setting gets changed by mistake or an import goes wrong.

Frequently asked questions

Does the Yoast settings export include my meta descriptions?

No. The settings export only covers site-wide options such as search appearance and social settings. Meta descriptions, SEO titles and focus keyphrases are saved with each post, so you need a content export, a CSV export or a database export to save them.

Can I export Yoast SEO data to Excel?

Yes. Use a CSV export plugin that lets you pick custom fields, and add the Yoast fields for title, meta description and focus keyphrase. Open the CSV in Excel or Google Sheets to sort, filter and audit your SEO data.

Will I lose Yoast data if I deactivate the plugin?

Deactivating Yoast does not delete its data. The post meta and settings stay in the database. Deleting the plugin can remove data depending on its uninstall behaviour, so take a backup or export first if you plan to remove it.

Do I need Yoast Premium to export data?

No. The settings export is in the free plugin, and post meta can be exported with WordPress tools or a CSV plugin. Premium adds conveniences such as a ready-made keyphrase export and redirect management.

Does a full site backup include Yoast data?

Yes. A backup that includes the full database saves every Yoast setting, post field and table. Restoring it brings all Yoast data back, which makes a backup the safest copy before any risky change.

Sources

  1. Yoast SEO Tools: Import and export Yoast
  2. Why and how to export your focus keyphrases with Yoast SEO Premium Yoast
  3. Tools Export Screen WordPress.org Documentation
  4. wp db export WordPress Developer Resources

Is your product missing, or something out of date?

Tell us what to add or correct. We read every note and reply when we need a source. A message does not buy a ranking.

About the editors

Written and checked byWPLegible Editorial Team Independent WordPress reviews and guides

Researched from the primary sources listed above and checked against our editorial rules before publishing.