WordPress SEO Plugins Data Import as CSV

The purpose of blogging is to create insight and brand awareness. And the purpose of SEO is to bring more visitors to your website. These two are interrelated with each other so it is important to know that your SEO works effectively. Although, there are many SEO plugins available for WordPress websites. Among that Yoast SEO is the most popular one. This checks sitemap, meta-title, meta-description, and so on. While updating your post, you have to provide this information. This allows Google bot to index your website content for the user query. Updating each SEO based record takes a lot of time, an alternative is to import all the SEO plugin data into WP ultimate CSV importer in a single CSV file format.

WordPress SEO by Yoast Import as CSV

While updating your post, you have to provide this information. This allows Google bot to index your website content for the user query.

How will you update these for each post? You can simply enter these data in a CSV file and upload it into WP ultimate CSV importer. This makes the SEO process easy. WP Ultimate CSV Importer supports the Yoast SEO plugin and All-in-one SEO plugin. First, Install and activate WP Ultimate CSV Importer and Yoast SEO or All-in-one-SEO. You can activate both plugins.

CSV Import procedure for YOAST:

Select any one 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 from desktop, FTP, external URL and server. Select any one of the above-mentioned options to Import the required CSV file which contains plugin data. Once it is uploaded, press the “Import” button to proceed. To update the existing module, select the “Update” button.

ultimate-csv-importer-wpimport-browse-file-from-desktop.png

Mapping

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

  • WP Ultimate CSV Importer Pro
    WP Ultimate CSV Importer Pro

    WP Ultimate CSV XML Import Export plugin is a robust import tool designed to help you make your website development easy.

    $149

Core Fields

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

Yoast SEO Fields

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

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 “no follow” in the “Meta Robots Follow” field.

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 the “none” value.

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. The “Sitemap Priority'' field is used to prioritize the sitemap. The priority values that are given by YOAST are 1.1 or 0.1 specify any one of the above-mentioned priority values in the CSV file.
Specify the URL in the “Canonical URL” field. Specify the redirect URL in the “301 Redirect” field.

Social Media Content

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. 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. 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.

After mapping, click the “Next” button to continue.

ultimate-csv-importer-yoast-seo-import.png

Media Handling

In the media handling session, any external images that are in a CSV file get downloaded to the WP media gallery. You can optimize images for Google.

Import Configuration

  • Backup and Rollback- Always have a backup of your content. If any errors occur in the middle of import, just roll-back to prevent complications.
  • Duplicate Prevention- This mode validates your file while uploading and prevent duplicate record import.
  • Schedule Import- When you have 10,000 records to upload, don't waste your time. Just schedule your import with the date and timestamp.
  • Maintenance Mode- It notifies the visitors that your website is temporarily unavailable.

Import All in One SEO with Ultimate CSV Importer:

Similarly, install All-in-One SEO and activate the plugin. All-in-one SEO plugin is a WP plugin used to optimize the website based on search engine algorithm. It helps your website to rank higher among the competitors. For this, you have to add post or page optimization information manually. You can maintain an interactive web page use WP ultimate CSV importer. In this, simply upload the details in a CSV or other file formats and directly upload it in your post.

  • WP Ultimate CSV Importer Pro
    WP Ultimate CSV Importer Pro

    WP Ultimate CSV XML Import Export plugin is a robust import tool designed to help you make your website development easy.

    $149

CSV Import procedure for All in one SEO

We can upload the CSV files in four ways. Upload using browse from the computer or using FTP or external link or Choose file from server. As shown in the above you can choose the corresponding option as you needed Import the plugin data stuffed CSV file. Then click the import option to import the CSV file, once the file was uploaded then click import button to import the CSV file. Map the core fields and core custom fields with WP fields to CSV Header.

ultimate-csv-importer-all-in-one-seo-import.png

Title

Specify the title name as seo_title in the CSV file. The maximum number of characters for the title is 60 characters.

Description

Provide the description of the title fields. In the CSV file specify as seo_description. The maximum character for description is 160 characters.

Keywords

Keywords in the CSV files should be separated by a comma.

Robots Meta NOINDEX

If you want to make a page not to be indexed means, then specify “on” in the CSV file. Suppose you don’t want to make a page indexed, specify “off” in the CSV file.

Robot Meta NOFOLLOW

If you want to make engines follow the link on a page, specify ‘off’ in the CSV file. Else specify "on" in the CSV file.

Robot Meta NOODP

If you want to use the description from the open directory, specify off in the CSV file. Otherwise, specify ‘on’ in the CSV file.

Robot Meta NOYDIR

If there is no need to use the description from Yahoo directory, specify ‘on’ in the CSV file. Otherwise, specify the value as ‘off’ in the CSV file.

Map the WP fields to CSV Header. After mapping All In One SEO fields to CSV Header, click next button. Next page will show you the summary of the mapped records using that you can see what are fields are not mapped.

Then click the proceed import button. There are two ways to import, they are import right way and schedule now. Click the next button to import the files then click import now button to start the import as shown below. After importing all the CSV files you can verify in the web view or admin view.

Wrapping Up

Optimize your web pages with WP SEO plugin. Work smartly with SEO integrated WP Ultimate CSV importer. Import all your posts, pages and custom posts and SEO data using our Ultimate CSV Importer plugin. You can also import optimization data in the existing file using the same procedure. Check out our CSV documentation for more details. Contact our Support team for guidance.

Cookies help us deliver our services. By using our services, you agree to our use of cookies.