SEOPress – Import SEO Title, Description, Keyword

In a previous post, we showed you how to bulk edit SEO titles, descriptions and keywords from SEOPress using a spreadsheet inside WordPress. In this post, we want to show you how to import SEOPress descriptions, titles and keywords using a CSV file.

We’ll start by exporting the products with the SEOPress titles, descriptions, and keywords to a CSV file.

Once you export all the posts, you can edit the CSV file using an editor such as Excel or Google Sheets.

Finally, you can import all the changes into WordPress with a few clicks and in just a few minutes.

Forget about being unable to edit your SEO titles and descriptions in a weekend without an Internet connection because you can edit them offline in Excel.

Plus, you don’t have to wait for someone on your team to know how to use WordPress because you can assign them this task and then simply import the SEOPress titles, descriptions, and keywords.

For this, we’ll use the WP Sheet Editor plugin.

WP Sheet Editor

Use an intuitive spreadsheet inside WordPress to:

• View and edit posts, pages or custom post types in a spreadsheet
• Bulk edit pages, posts or custom post types
• Do advanced searches of your posts, pages or custom post types quickly
• Import posts, pages or custom post types from Excel, Google Sheets, etc.
• Download all items of any post type to a CSV file.
• Bulk edit fields generated by other plugins.

Once the plugin is installed and activated, follow these steps to export and import SEOPress titles, descriptions and keywords.

1- Open the posts spreadsheet

To open the posts’ spreadsheet, go to WP Sheet Editor > Edit Posts.

You’ll see all the posts displayed in the spreadsheet as rows and their complete information as columns.

You can see the SEOPress columns displayed in the spreadsheet if you scroll to the right.

2- Export SEOPress titles, descriptions and keywords to a CSV file

To export your posts with their SEO titles, descriptions, and keywords, you need to click Export on the top toolbar.

Now you need to configure the export, so you have to select these values in the Export tool:

• What columns do you want to export: Select the following columns: ID, Title, Content, Seopress Titles Title, Seopress Title Desc, Seopress Analysis Target Kw.
• Tick the I understand it will export all the rows from my current search checkbox.
• What app will you use to edit this file? (optional): Select any of the available options.
• Name of this export (optional): Save these settings for future exports.
• Click Start New Export to download the CSV file.

Once you do this, the CSV file will be downloaded to your computer, so you can edit it with Excel or Google Sheets.

3- Edit the SEOPress titles, descriptions, and keywords with Excel or Google Sheets

This is how the SEO titles, descriptions and keywords will look in Excel once they’ve been edited.

Now we’re ready to import the changes back to WordPress.

4- Import SEOPress titles, descriptions and keywords

Once you’re ready to import the SEOPress titles, descriptions, and keywords, you need to open the Import tool with one click; it’s on the top toolbar.

Now you need to select the CSV file from your computer.

• Source: CSV file from my computer
• CSV File: Click Choose File and select the CSV from your computer.
• Click Next.

Then, click Import all the columns.

Now configure the import:

• Do you want to update or create items: Create new items and update existing items
• CSV Field: record_id
• WordPress Field: ID
• Click Next.

Finally, you’ll see a preview of how the information will look imported. If everything is OK, click The preview is fine, start import.

Once the import process is done, you’ll see the SEO titles, descriptions and keywords updated in the spreadsheet.

That was really easy!

As you can see, you don’t have to worry if one day you run out of internet connection and wanted to update the SEOPress titles, descriptions, and keywords.

You just have to export them and download them to your computer, edit them in Excel, and when you are online again, quickly import them into WordPress.