We'll create fresh WordPress site with Bulk Meta Editor installed. You have 20 minutes to test the plugin after that site we'll be deleted.
Bulk updates the metadata such as the title, description, canonical url, and the indexing of a page. Created for most Web Developers and SEO Specialists who do website audits. Currently supports Yoast as of the moment.
This plugin was created a way to solve my problem to bulk update the metadata since I was doing SEO audit and implementation.
PRO Version is also available. It allows you to do more and supports WooCommerce out of the box and taxonomies such as categories and tags.
Read the guide here on how to fill out the required CSV file.