Editing SEO Meta Titles & Descriptions at Scale w/Rank Math + Google Sheets - Rank Math SEO

Key Takeaways

hi i'm kate in this tutorial i'll teach you how to edit seo meta titles and descriptions at scale with rank math pro this feature is quite useful for checking if everything is correct before launching a site or doing a complete overhaul of an existing website's seo especially if you work in teams to speed up the process in case you don't find an import and export tab in status and tools open rank math's dashboard and check if you're using the plugin in advanced mode on the upper right corner then return to the status and tools section open the import and export tab and head down to csv file you can use the basic filter for posts taxonomies or users but there are advanced options to refine your selection with them you can export specific post types and taxonomies or select users based on their roles under the list of options you'll find include read-only columns which are the page or posts seo score and link counts these are statistics generated by ranked math so any alteration in them won't be overwritten you can select this option to copy the data and use in reports for instance but we won't use them in this tutorial download the csv file and open it in your software of choice we'll use google sheets in this tutorial because it has the benefits of being able to work in a team and have a single central document with multiple people who can edit all at once in this case upload the file to your google drive and click on open with google sheets in the spreadsheet let's filter the data through the robots column because the list items that have an empty field here are not indexable content they are for internal use only not visible to users to make the spreadsheet easier to work with we recommend freezing the first row and even styling it according to your preferences once all the changes have been made download the spreadsheet from google sheets as a csv file go back to the import and export tab of rank math status and tools you can drag and drop the file in the import tab of the csv file section or use the browse button right below you'll find the do not overwrite existing data checkbox you should leave it active in case you only intended to edit empty fields that way you won't accidentally overwrite data that was already correct if you edited fields that already had content on purpose disable the option the final step is pressing import if this tutorial helps you give it a like if you have any questions click on the link in the description to open a free support ticket you can find other tutorials in our knowledge base at rankmath.com kb