WordPress SEO by Yoast Import as CSV

August 5, 2015

Install and activate WP ultimate CSV Importer and Yoast SEO. After installation and activation completed, enable the “Yoast SEO” plugin in the wp ultimate CSV importer settings. In the settings page, select the SEO settings and press “Enabled” button nearer to the Yoast SEO. You can’t able to enable both the SEO’s plugin simultaneously

CSV Import procedure for YOAST:

Select anyone of the modules from the import option using the drop down menu. We are providing four options to upload the required CSV file

Upload File
Upload using FTP
Upload using external link
Choose file in the server
Select anyone of the above mentioned options to upload the required CSV file. Once it is uploaded, press “Import” button to proceed. To update the existing module, select “Update” button.

Mapping

In the mapping page, map the wp fields with CSV header fields. There are two important fields which are necessary for this import one is Core Fields and another one is YOAST SEO Fields.

Core Fields

It contains the basic wp fields. “Post title” field is a mandatory field.

YOAST SEO Fields

In the “SEO Title” field, specify the title that will be displayed in the Google search result. In the “Meta Description” field, specify the description that will be displayed under the SEO Title during Google search result.

In the “Meta Robots Index” field, specify 1 for “no index”, specify 2 for “index” and specify “0” for “Default for the post type, currently: index” in the CSV file. Specify “0” for “follow” otherwise specify “1” for “nofollow” in the “Meta Robots Follow” field.

For “Meta Robots Advanced” field, specify “None” “NO ODP”, “NO YDIR”, “No Image Index”, “No Archive” and “No Snippet” as “none”, “noodp”, “noydir”, “noimageindex”, “noarchive” and “nosnippet” in the CSV file. Multiple values are separated by a comma (,). If you didn’t specify any value, by default it will take “none” value.

For “Include in sitemaps” field, specify “Always include” and “Never include” as “always” and “never”. If you didn’t specify any value, by default “Auto detect” value will set.

“Sitemap Priority” field is used to prioritize the sitemap. The priority values that are given by YOAST are 1,0.9,0.8,0.7,0.6,0.5,0.4,0.3,0.2,0.1 specify anyone of the above mentioned priority value in the CSV file.

Specify the URL in the “Canonical URL” field. Specify the redirect URL in the “301 Redirect” field.

If you want another title and description for facebook instead of the post title and meta description, then specify the title and description in the “Facebook Title” and “Facebook Description” field. If you want to override the existing image then specify the image URL in the “Facebook Image” field.

If you want another title and description for twitter instead of the post title and meta description, then specify the title and description in the “Twitter Title” and “Twitter Description” field. If you want to override the existing image then specify the image URL in the “Twitter Image” field.

If you want another title and description for Google+ instead of the post title and meta description, then specify the title and description in the “Google+ Title” and “Google+ Description” field. If you want to override the existing image then specify the image URL in the “Google+ Image” field.

wordpress seo import

After mapping, click “Next” button to continue. The next page will have the summary of the mapping. Just verify it and click the “Proceed Import” button to proceed.

“Import right away” option is used to import immediately and the “schedule now” option is used for later import. Choose anyone of the above mentioned options according to your convenience. After filling the necessary details, Press “Next”.

Click “Import Now” to start the import process. Wait until the CSV file was imported. “Import successfully completed!” message will be displayed. Click “Admin View” or “Web View” to verify.

Leave a Reply

Your email address will not be published.