Table of Contents
Creating and importing SEO content in bulk, as known as Programmatic SEO, can help you improve your website's Google ranking quickly and efficiently. And the best part? You can now easily implement this strategy on your WordPress site using WP All Import plugin. Get ready, because we're about to take you through the steps of how to do it!
It implies that you can create 100s and 1000s of SEO-friendly pages in WordPress without going through the grueling manual process. No more spending hours copying and pasting product listings, uploading images, and filling in metadata. WP All Import Plugin by WordPress lets you import data in the form of a CSV file and then create a page template to use the imported data.
Let us understand this in more detail, shall we?
In the following section, we will go through each step of using the WP All Import Plugin.
The first and foremost step is to ensure that you have WP All Import Plugin installed in your WordPress. If not, add the WP All Import plugin from Plugins > Add New section in your WordPress dashboard. The plugin appears as “Import any XML or CSV File to WordPress.” Don’t get confused by the name difference. As the name suggests, the plugin imports both XML and CSV files.
Now that you have the plugin installed, it is time to prepare your spreadsheet with all the data points needed to create the blog posts. You can either use Google Sheets or Microsoft Excel to prepare the spreadsheet. Put together the title, Images, meta description, and content in the excel sheet and save it in CSV or XML format.
In this example, we are experimenting with a website that will have several blogs talking about the different landmarks in Chicago city and information related to each of them. Each column header will serve as a variable while creating the template with WP All Import. Make sure you add sufficient data points to your spreadsheet to create better and more SEO-friendly web pages. Please note that image and meta description is only supported in the pro version of WP All import.
As you can see, there are three ways to import the XML/CSV file using WP All Import: upload from a computer, download from a URL, or use a pre-existing file on the server. The best choice is to download from the URL since you can schedule WP All Import to run later and continuously monitor the file for updates, creating, deleting, and updating posts on your website as necessary.
After successfully importing your file, go to the “Create New” option and select posts from the drop-down menu. Click “Continue to Step 2” to go to the next page.
Once you click on step 2, you will see all the different elements that were present in your CSV/XML file. You can choose which elements to import amongst these. For example, we can see the categories we used in our CSV file - name, id, address, date, architect, meta title, meta description, and image URL. All 19 landmarks from our csv file will be imported and turned into a new post.
Additionally, you can add filtering options as well. Select the element to which you would like to add the filter. Select a rule and then add a value. Add this rule, and WP All Import will only select the elements fulfilling this rule. For instance, we want to import only the landmarks built after Jan 1900. So, we will add a filter setting ”date-built” as the element, “equals or greater than” as a rule, and “1900-01” as the value. Imported elements went down from 19 to 5. WP All Import filtered out the rest of the elements as they do not fulfill the selected criteria.
You might already be aware that WP All import is entirely drag-and-drop. So, you have to drag the elements from the right-hand side and drop them on the left to create the template. We wanted the title for this blog to say the “<landmark name> information page”. Under the content section, add the body of your blog along with details of the title.
Use Preview to see how your content will look after publishing. Make changes accordingly.
The Advanced Options section contains the following:
You can add images to your blog by adding the URL. If multiple images exist, separate the URLs with a comma or add them one after the other. Use the “Preview & Test” button to see if your image URL works. After Preview, click on Test and WP All Import will download your image to the server and show you how much time it takes to do so.
If you are uploading multiple images, checking the “See the first image to the Featured image” will ensure that the first image becomes the featured image of your blog post. Please note that the image feature is only available in the WP All Import pro version ($249). You can learn more about how to import the image in this video.
The custom field allows you to add your custom columns with SEO metadata that you want to add to your site, like “meta title”, “meta description,” etc. Check this post to find all the keys of all the custom fields used in WP All Import. Here is a quick tutorial to help you understand how to use custom fields.
WordPress uses taxonomies to group posts, products, and other post kinds depending on their relationships. By default, two taxonomy kinds are available: Categories and Tags. Categories are used to organize post topics, whereas tags are used to describe posts in greater depth. Check out this step-by-step tutorial on how to import categories and tags.
This section allows you to play around with how you would like to publish your post. Start by selecting the post status - published, draft, or set with Xpath. Specify the date when you want the action to be taken on the post. You can either pick a specific date or use the random date selector to pick any date between the specified period.
Do you want to keep the comment section active? Do you wish to get notified when other sites link to your blog? Choose the comment field and Tracebacks & Pingbacks options accordingly. You can also add a post slug and author name and select the page template in this section.
WP All import has a built-in code editor where you can add your custom functions. This feature is available only in the Pro Edition.
Once you have all the content in place and the different options, continue to Step 4.
As part of this step, all you have to do is detect a unique key. The unique identifier should be unique for each file record and stay the same even when the file is updated. This unique key allows WP All Import to correctly link the records in your updated file with the listings it will create now. If multiple records in this file have the same unique identifier, only the first will be created. The others will be detected as duplicates.
Here we have used Auto-detect to let WP All Import decide the Unique Identifier. You can also pick this option to save yourself the hassle of choosing one.
The final & last step once you have your template and values in place is to run the import. Importing takes 2 - 3 minutes, based on the number of posts you aim to create. As we had only 20 records, it took less than a minute for the import to complete. Let’s go to posts and see if our blogs are ready.
We can see all 19 blogs created through WP All Import in the posts section.
The web pages have all the data as per the datasets provided in the spreadsheet. You can verify the content here to ensure everything looks as intended.
For a more detailed overview of how to use the WP All Import Plugin, check out this video. It explains how WP All Import is used to create bulk pages.
WP All Import has unique features that are highly beneficial for creating and publishing content in bulk. Let's take a look at some of the top benefits of using the WP All Import Plugin.
There is an option to add Filters if you are importing a sizable data file but do not want to create new posts for each row in the data file. To remove extraneous rows, you can add filters to any data file element (as seen in the screenshot above).
WP All Import Plugin offers different post options to help you publish a large number of web pages. Some of these options include:
While WP All Import is the best plugin for you if you plan to do create and import content in bulk in WordPress, but it has its limitations. Let us take a look at them one by one:
SEOmatic helps you overcome the above challenges with ease. It successfully enables you to harness the power of creating and publishing SEO pages in bulk for your website. With SEOmatic, you can expand your business organically by generating bulk content in less than 10 minutes. Here are some distinct advantages of using SEOmatic.
With the help of SEOmatic, you can transform your website from a technical burden into a marketing advantage. SEOmatic generates material in less than ten minutes instead of taking hours with WP All Import. Drastically reducing the time required for content production by 75% makes automating and scaling content simpler. SEOmatic makes sure that you successfully deploy your SEO pages to maximize your benefits.
Visit SEOmatic to learn more about how your organization can benefit from creating and publishing SEO pages at scale. Access the programmatic SEO course for beginners on YouTube for Free!
Join 103+ niche site owners, digital agencies, SaaS startups and start driving traffic to your website today.