Back to blog
4 min read Export Guides

Move SEO Titles and Meta Descriptions from Yoast to Rank Math with a CSV

When you switch from Yoast SEO to Rank Math, the SEO titles, meta descriptions and focus keyphrases you wrote are stored in Yoast’s own custom fields, and Rank Math reads its own. Rank Math has an import tool for this, but if you want to see and check the data first, change only some posts, or move it from a backup or another site, a spreadsheet gives you full control. In the example, the SEO data of four posts moves from Yoast to Rank Math with Import Export by RockStarLab: export, rename the columns, import.

Free: export and import of posts and pages with Yoast SEO and Rank Math fields. PRO: the same for custom post types and WooCommerce products.

Short Answer

  • Export the posts with ID and the Yoast fields SEO Title, Meta Description and Focus Keyword.
  • In the spreadsheet, rename the headers to rank_math_title, rank_math_description and rank_math_focus_keyword, and change Yoast variables like %%sitename%% to Rank Math’s %sitename%.
  • With Rank Math active, import the file into Blog Posts, matching by ID and updating matches.

1. Export the Yoast data

With Yoast SEO active, go to Export and choose Blog Posts. To export only posts that have Yoast data, add the filter Custom Field (Meta) with the name _yoast_wpseo_metadesc and Is Not Empty; on our site that matched 4 posts. On the field step, add ID and Title, then open the Yoast SEO group and add SEO Title, Meta Description and Focus Keyword:

Export field step with ID, Title and the Yoast SEO fields SEO Title, Meta Description and Focus Keyword
Export the Yoast fields with the post ID.

The export has the Yoast field keys as headers: _yoast_wpseo_title, _yoast_wpseo_metadesc and _yoast_wpseo_focuskw. See exporting Yoast titles and descriptions if you want to review them first.

2. Prepare the file for Rank Math

Rename the three columns to the Rank Math field keys and replace the variables. Yoast writes variables with two percent signs on each side (%%title%%, %%sep%%, %%sitename%%); Rank Math uses one (%title%, %sep%, %sitename%). A find-and-replace of %% with % in the title column does it. Delete the post title column; only ID and the three SEO columns are needed:

Exported Yoast columns and the same rows prepared for Rank Math with renamed headers and %variable% syntax
Rename the headers and change %%variable%% to %variable%.

3. Import into Rank Math

Activate Rank Math and finish or skip its setup wizard; on our test site Rank Math didn’t output any SEO tags until the wizard was done. Then go to Import, choose Blog Posts, upload the file and click Auto Map. All four columns were mapped, the three SEO columns to the Rank Math fields:

Import mapping: ID, rank_math_title, rank_math_description and rank_math_focus_keyword mapped automatically
Auto Map matches the Rank Math field keys.

On the options step, set Check for Existing Items by Field to ID, If Match Found to Update and If No Match Found to Skip. The import updated the 4 posts:

Import Completed Successfully: 4 updated, 0 created, 0 failed
Four posts now have their SEO data in Rank Math.

On the front end, Rank Math now produced the titles and descriptions. For example, “How We Source Green Coffee” had the title How We Source Green Coffee - Example Store and the meta description from Yoast, and the post with %title% %sep% %sitename% showed its own title followed by the site name. The Yoast fields were left in the database, so you can go back if needed.

Before you import

Try the import on a few posts first and check the page source. Back up the site before you update all posts. Check titles that use less common Yoast variables after the import.

With an AI agent

An AI agent connected through the WordPress MCP Adapter (see connecting Claude Code to WordPress) can check that the Rank Math fields are filled:

Show the Rank Math SEO title and focus keyword of the four posts we migrated.

In our run, the agent called rsl-ie/export-preview for posts with the IDs of the four posts and the fields rank_math_title and rank_math_focus_keyword. It returned the four posts with their Rank Math titles, such as %title% %sep% %sitename%, and focus keywords such as “green coffee sourcing”.

FAQ

Which Yoast fields map to which Rank Math fields?

SEO title _yoast_wpseo_title → rank_math_title, meta description _yoast_wpseo_metadesc → rank_math_description, focus keyphrase _yoast_wpseo_focuskw → rank_math_focus_keyword.

Do I need to change the variables?

Yes. Yoast uses %%sitename%%, Rank Math %sitename%. Replace %% with % before importing.

Is the Yoast data deleted?

No. The import only writes the Rank Math fields; the Yoast fields stayed in the database in our test.

Can I move only some posts?

Yes. Export or keep only the rows you want; posts that aren’t in the file are not changed.

Get the free plugin on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

Have a question or a tip to share? Leave it below.

Leave a comment

Your email address will not be published. Required fields are marked *

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE