BLACK FRIDAY

&

CYBER MONDAY

Up to

25% OFF Sale

On WordPress & CRM Products

Limited time Offer

Knowledge Base

RankMath Data Import and Export

Rank Math is a free plugin that covers most of the features provided in the Yoast SEO premium version. To write high-quality content for a website then Rank Math is the best choice of SEO plugin. The Rank Math SEO plugin scans your content and retrieves data from Search Console and Analytics to form performance reports. Rank math has several modules and features when compared to other SEO plugins. We can easily customize the important settings in SEO, which helps to get a good ranking for the custom posts and pages of our website to display in Google results. With the help of the Rank Math SEO plugin, we can easily track and identify the low-ranking posts, pages, and content on our website.

Supported Modules #

PostsPagesCustom PostsEvent
Recurring EventsLocationWooCommerceMarketPress
Wp eCommerceeShopTaxonomiesCategories
TagsWooCommerce TagsWooCommerce Attributes 

Step 1- Install and Activate #

The first step in RankMath setup is to download and install the Rank Math plugin in WordPress. 

Once done, activate the plugin.

Step 2-Rank Math Setup Wizard #

  • To start the wizard, select any one of the modes such as Easy, Advanced, and Custom modes.
  • Now you can import data from Yoast SEO which is optional.
  • On the “Your Websites” section, Fill in the required fields with our website information.
  • On the Analytics, connect with your Google account or simply skip this one
  • No setup indexes for Posts/Pages in the Site map section 
  • On the Optimization section, Set up SEO tweaks.
  • Finally, continue by clicking on Ready.

Step 3- Advanced Settings #

  • We are directed to Advanced Settings. Enable Role Manager and other options.
  • Then, enable redirection.
  • The Schema Markup is enabled by default.
  • Finally, Click on ‘Save and Continue.
rankmath-plugin-highlighted-wordpress-dashboard

How to create CSV files for Rank Math?

WP Core Fields The post title is a mandatory field in WP core fields. We can also provide Post Content, Postdate, Post Author, etc.

Rank Math SEO Pro Fields #

Focus Keyword

We can get a ranking for a post/page by adding a focus keyword in SEO. By default, Rank Math allows adding 5 keywords per post.

Rank math Focus Keyword

Pillar Content

Pillar content is a unique Rank Math feature. This helps to attract extra SEO recommendations. If you want to enable this option in WordPress, mention the value as “on” in the CSV file.

Rank Math robots Meta

In this section, we have custom Meta like Index, No Index, Nofollow, No Archive, No Image Index, and No Snippet. For this option, first, we have to enable post-robots meta. index: This is a default one. Instruct the search engine to include the page in the index. noindex: Instruct the search engine to not include the page in the index. nofollow: Instruct the search engine to not follow any links on the page. noarchive: Not allowing a cached copy of this page on search results. noimageindex: Instruct to not allow any images on a page. nosnippet: not allowing snippet (Meta description) on the search result of the page. If you want to enable this option, mention the value as 1 is a CSV file.

Advanced Robots Meta

This helps us to determine our content in search results. Here we have three options to configure. Snippet – We can set the maximum length of text characters for a page. The default value is “-1”. Video Preview – Set the maximum duration (in seconds) for a preview. The default value is “-1”. Image Preview – We have three choices to set the image preview on the page. “Large, Standard, and None”. We have to mention these values with a comma separator in the CSV file. (Eg: -1,-1,large)

Canonical URL

This option helps to direct us to the main page if we have duplicate content.

Redirect

This option is disabled by default. This option helps us in various ways like updating the URL, moving the website to a new domain, creating temporary redirect URLs, and redirecting to a new URL from the old one. There are two things we need to mention in our CSV file while setting up the Rank Math Redirect Option.

Redirection Type:

Select any one of the following types based on our use.

  • 301 for Permanent Move
  • 302 for Temporary Move
  • 307 for temporary Redirect
  • 410 for Content Deleted
  • 451 for Content unavailable for Legal Reasons

Destination URL:

Mention the URL where we want to redirect our visitors.

Schema

We can select any one of the options from more schema types. 

Headline – Set an SEO headline for a page/post

Description – Set a default description for a page/post.

Article Type – Prefer any one of the article types from these three (Article/ Blog Post/ News Article)

Speakable Schema – This option lets our article be speech-friendly. When enabling this option, have to fill the cssSelector field by providing any particular content value in the CSV file.

General Title

Give the SEO title of the post in the rank_math_title field.

Permalink

In this field mention the permanent link of a post/page in the CSV file under wp_old_slug. In this, the first part is the domain name and the second one is a slug.

General description field

Provide any text characters as a description of a post in Rank Math.

Social media in Rank Math

This option helps to notify the followers about new posts/pages. We can also control how our content is displayed. Facebook – We can give a specific “Facebook Title”, “Facebook Description” and “Facebook Image”. We also leave this blank, by default, it will assign the post title, description, and image. Also, add an icon overlay to the thumbnail, here we have two options: “Play Icon” & “GIF Icon”.

Twitter – By default, it will copy the relevant data from Facebook. We can disable this option and can give a specific “Twitter Title”, “Twitter Description” and “Twitter Image”. Also, add an icon overlay to the thumbnail, here we have two options: “Play Icon” & “GIF Icon”. Specify any Card Type from “Summary Card with Large Image”, “Summary Card”, “App Card”, and “Player Card”.

Rank Math Pro FieldsDescription & CSV ValuesCSV Sample Value
Focus KeywordAdd Possible keywords to rankedSearch engines, SEO
           This Post is Pillar Content      To link related       articles/posts. To     enable mention – On                          On
              Robots Meta Index To include the page in  the index To enable mention – 1. Otherwise, leave empty                            1
          Robots Meta NofollowDo not follow any links on the page. To enable mention – 1. Otherwise, leave empty                             1
     Robots Meta No Image IndexDo not allow any images on a page. To enable mention – 1. Otherwise, leave empty                              1
           Robots Meta No IndexNot to include the page in the index. To enable mention – 1. Otherwise, leave empty                               1
         Robots Meta No ArchiveNot allowing a cached copy. To enable mention – 1. Otherwise, leave empty                              1
        Robots Meta No SnippetDo not allow snippets. To enable mention – 1. Otherwise, leave empty                                1
         Advanced Robots MetaProvide the values for the snippet, image preview, and video preview. Each value is selected by using Comma(,) separation E.g.: Snippet – “-1”       Image    – “-1”       Video    –  “large”                                      -1,-1,large
                 Canonical URl Mention the main page  URL.  https://www.smackcoders.com/documentation/wp-  ultimate-csv-importer-pro
                Redirection TypeSelect any type to redirect the website301 – Permanent Move302 -Temporary Move307 – Temporary redirect410 – Content Deleted451 – Content unavailable for Legal Reasons                           301
              Destination URLMention the URL to redirecthttps://www.smackcoders.com/documentation/wp-ultimate-csv-importer-pro/seo-import
                   HeadlineMention SEO headline                Search engine
             Schema DescriptionMention description for a page/post.   With the help of the Rank Math SEO plugin, we can easily track and identify the low-ranking posts, pages, and content on our website.
                   Article Type   Specify the type of     article.                 Blog post
                  General Title     Mention SEO title.      Search Engine – What is it?
                   PermalinkSpecify the permanent link to display below the post title.                   Yoast SEO
               General DescriptionSpecify the description for the post/page.When you are creating and updating these data on a website manually it will take a lot of time to complete this process.
                 Facebook TitleSpecify the title for the Facebook post                SEO plugin
           Facebook DescriptionSpecify the description for the Facebook postHow to download Rank Math SEO and customize SEO settings? 
             Facebook ImageUse media gallery URL or any publicly accessible external URL.https://i.ytimg.com/vi/Bta0km0YlM8/maxresdefault.jpg
      Add icon overlay to thumbnailTo add overlay, enable this option by entering Value as On. Otherwise, leave it empty.                          On
                   Icon overlayTo Add icon, we have two options “Play Icon” & “GIF Icon”                          Play
        Use Data from Facebook TabTo collect the data from Facebook to Twitter, enable this option. Enable – On To disable – Off                      Off
                     Twitter TitleSpecify the title for the Twitter post              SEO – Rank Math
              Twitter DescriptionSpecify the description for the Twitter post          Rank Math fields Setting
                       Card TypeSpecify content by selecting any one of the cards.Summary Card with      Large ImageSummary CardApp CardPlayer Card                     Player
                App DescriptionSpecify the description for the app          IOS/Android version.
              iPhone App NameMention name for App card                 iPhone App
                iPhone App IDMention the app id from the app store                    324561
              iPhone App URLSpecify the URL schemehttps://www.apple.com/in/iphone-12/key-features/
             iPad App NameMention name for App               iPad App
              iPad App URLSpecify the URL schemehttps://www.amazon.in/dp/B0932STDMD/ref=fs_a_ip_1
           Google Play App NameMention name for Android app               SEO android
               Google Play App IDSpecify the ID of the app from the App store                   6789012
              Google Play App URLSpecify the URL scheme  https://play.google.com/store/apps/details?id=net.seobility.seocheck&hl=en_IN&gl=US
                   App CountryEnter the country code of the app store                IN
                    Player URLSpecify the URL to the iFrame player. https://www.youtube.com/watch?v=UPLd0gE1A2A
                    Player SizeSpecify width and height of iFrame pixel.                  600×400
                   Stream URLProvide optional URL               https://youtu.be/fOg2nvHkfT8 
               Stream Content TypeSpecify the content type contained in Twitter: player: stream.                   MIME
                   cssSelectorSpecify any particular content for headline, summary or any other cssSelector.            SEO data import
                  Image URLUse media gallery URL or any publicly accessible external URL.https://i.ytimg.com/vi/Bta0km0YlM8/maxresdefault.jpg
                  Author TypeMention the Author Type                   Admin
                Author NameSpecify the name of Author               Smackcoders
             Speakable type  
           Enable SpeakableTo enable this option mention value as on, to disable mention the value as off                 On
                DateModifiedSpecify the date in DD/Mm/YYYY format                                   22/08/2022
                DatePublishedMention publish date in DD/Mm/YYYY format                                    24/08/2022

Step 1: Import/Export Settings- Browse the file
  #

After creating all the required fields in the CSV file, go to Ultimate CSV Importer Pro in WordPress to Import.

Select any one of the modules from the import. We are providing four options to upload the required CSV file. Upload files from the desktop, FTP, external URL, and from the server.  Select any one of the above-mentioned options to Import the required CSV file which contains plugin data. Once it is uploaded, select continue. (Note: If you are updating the data, select Update Content).

upload-import-file-csv-importer

Step 2: Mapping Section #

In the mapping page, map the WP fields with their appropriate CSV header fields. Check all the necessary fields in WP Core Fields and Rank Math Pro Fields. You can choose advanced mapping to select the desired fields from the drop-down and can choose drag and drop mapping to map the fields by dragging the right widget and dropping it in the appropriate fields. Once done with the mapping, Save the Mapping template. Click on Continue.

Rankmath Mapping Section

Step 3: Import Configuration- WP all import Rank Math #

You can update/ import Rank Math data either instantly or schedule it to do later. To schedule your import – add the Schedule Date, Frequency, UTC Time, and Zone. We can import instantly by clicking on the import button directly. Press the “Import” button to proceed. To update the existing module, select the “Update” button.

Step 4: Export Rank Math data: Rank Tracking CSV export #

You can export Rank Math field data along with Posts, Pages, or Custom Posts data export. To export,

  • Move to the Export tab and select the post type which can be Pages, Posts, or Custom Posts.
  • If you select Custom Posts, select one Custom Post name from beside the dropdown.
  • Give a name for the file to export and select one file type.
  • Configure the advanced filter if you require it. Refer to the export WordPress data with CSV Importer documentation to know more.
  • Click Export.
  • After the file is ready to export. Click download to save the backup on your local desktop.

Frequently Asked Questions (FAQ) #

How do I import redirects in Rank Math?

You can import the RankMath redirect directly from the Rank math Plugin or you can use the WP CSV  importer to import your redirections along with its assigned posts/pages.

To import redirects into Rank Math, you can follow these steps:

  1. Prepare your redirects: First, make sure you have your redirects prepared in a compatible format. Rank Math supports CSV files for importing redirects.
  2. Format your CSV file: Create a CSV file with two columns: “source_url” and “target_url”. The “source_url” column should contain the URLs you want to redirect from, and the “target_url” column should contain the URLs you want to redirect to.
  3. Access Rank Math: Log in to your WordPress dashboard and navigate to the Rank Math settings.
  4. Go to the Redirections Module: Once in the Rank Math settings, find and click on the “Redirections” module. This is where you manage all your redirects.
  5. Import Redirects: Look for an option to import redirects. Depending on the version of Rank Math you’re using, this option might be in different places. Usually, it’s either a button or a link that says “Import”.
  6. Select your CSV file: When prompted, select the CSV file you prepared earlier that contains your redirects.
  7. Map the Columns (if necessary): If Rank Math asks you to map columns, ensure that the “source_url” column from your CSV file is mapped to the appropriate field for the source URL, and the “target_url” column is mapped to the appropriate field for the target URL.
  8. Complete the Import: Follow the on-screen instructions to complete the import process. Once done, Rank Math should have imported all your redirects from the CSV file.
  9. Verify Redirects: After importing, it’s always a good idea to verify that the redirects have been imported correctly. You can do this by visiting some of the source URLs and ensuring that they are redirected to the correct target URLs.

By following these steps, you should be able to import redirects into Rank Math successfully.

To import and export data from Rank Math, including redirects, and to import a CSV file into WordPress, you can follow these general steps:

How do I import export from Rank Math?

  1. Export Data from Rank Math:
    • Log in to your WordPress dashboard.
    • Navigate to the Rank Math -> Status and Tools-> Export Settings.
    • Select the data you want to export, such as redirects, settings, etc.
    • Follow the prompts to generate and download the export file.
  2. Import Data to Rank Math:
    • Log in to your WordPress dashboard.
    • Navigate to the Rank Math settings->Status and Tools-> Export Settings.
    • Browse the CSV file or select the exported file
    • Then follow the prompts to import the data into Rank Math.

How do I import a CSV file into WordPress?

  1. Log in to WordPress Dashboard
  2. Navigate to the WordPress admin sidebar, go to “Tools” > “Import”.
  3. Install and Activate the Importer Plugin. Follow the on-screen instructions to install the plugin.
  4. Map the WP fields with its appropriate CSV headers
  5. After mapping the fields, proceed with the import process. Depending on the size of your CSV file and the complexity of the data, this might take some time.
  6. After the import is complete, verify that the data has been imported correctly by checking your WordPress site.

By following these steps, you should be able to export data from Rank Math, import it into Rank Math if needed, and import CSV files into WordPress. Remember to always backup your website before making significant changes or imports

WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.

New Release Unveiled:

WP Ultimate CSV Importer v8.0