If you’ve been doing on-page SEO for years, you know exactly how crucial canonical URL is. It’s a link tag with rel=“canonical” attribute you can add on posts or pages. The more contents you publish, the more likely you generate similar contents. And when you have similar contents, you’re running the risk of being penalized by Google for duplicates. Adding the correct canonical URLs helps search engines identify original content and eventually index your pages better.
Top WordPress plugins like Yoast, All-in-One SEO, RankMath, SEOPress, and The SEO Framework provide a simplified way to inject custom canonical URLs for each post and page. It’s as simple as editing each page and adding your custom canonical URL on its custom field box.
However, there’s an elegant way to edit your canonical URLs so you can mass update them in bulk. No need to manually updating each post or page one by one. By simply exporting everything to CSV, you can edit them using your preferred spreadsheet editor and import them back to WordPress.
Mass Update Canonical URLs in Yoast, AIOSEO, RankMath, SEOPress, and The SEO Framework
Smart SEO CSV Import/Export provides a tool that helps you export your site’s SEO data into CSV so you can edit and import them in one go. Managing your site’s SEO titles, descriptions, and canonical is as easy as exporting and editing them in Google Sheet.
Here’s how you can bulk edit canonical URLs in Yoast, AIOSEO, RankMath, SEOPress, and TSF
- Install and activate Smart SEO CSV Import/Export
- Once installed, go to Settings > SEO Import/Export
- Navigate to Export tab
This is where the action begins. Start by selecting the post type or taxonomy to export.
- Edit the exported CSV
As soon as the export finishes, download and edit your CSV using your preferred spreadsheet editor (we highly recommend Google Sheet). This CSV contains canonical_url column you can update. Once done, re-download the CSV (containing the updated canonical URLs)
- Import the CSV
Navigate to Import tab upload the CSV file. And in the drag-and-drop editor, make sure canonical URL box is mapped correctly. Once done, press Start Import button
Your done! Your canonical URLs should then be updated in seconds.