Quick answer: WordPress’s built-in importer doesn’t read Excel files. With Content Importer for WordPress & WooCommerce with Excel you upload an .xlsx file to create or update posts, pages, products and categories in bulk, and delete them the same way. The steps below cover each tab.
Do you want to learn how to import content to your WordPress & WooCommerce site using Excel instead of manual importing and a complicated CSV file? You are in the right place!
Whether you want to import hundreds or thousands of products, files, blog posts, or any custom data you want from another site to your WordPress & WooCommerce site, you can now import them all at once using an Excel spreadsheet with a drag & drop feature easily- no more time-consuming manual work or confusing CSV formatting.
✔ Import any custom Posts, Pages, Simple & variable Products for WooCommerce, and any WordPress Content with Excel
✔ Benefit from all custom fields support, including ACF and other plugins’ post meta fields.
So, in this article, we will walk you through everything you should know to teach you how to use the Content Importer for WordPress & WooCommerce with Excel to import any data or content you want, accurately, easily, quickly, and without human errors.
What Can You Import?
Think of your WordPress site as a big digital notebook. Instead of writing each page by hand, this plugin lets you bring everything in at once.
Here’s what you can import:
Posts – Got dozens of articles or blog updates? Just prepare them in Excel, and the plugin will import posts into WordPress all at once. After a bulk import it is worth checking your permalink history, where you can remove old slugs in WordPress.
Pages – Whether it’s About, Contact, or service pages, you can import pages in bulk instead of creating each one manually.
WooCommerce Products – If you run a store, you can upload your entire product list, complete with descriptions, prices, and images.
Images and Media – No more broken pages; the plugin makes sure your images move with your content, so you don’t have to re-upload them.
SEO Details – Titles, descriptions, and slugs can all be imported to keep your site visible in search engines.
It doesn’t stop there; if you’re moving to a new website, the plugin also helps you migrate content from one WordPress site to another.
You can migrate WordPress content to a new site without losing formatting or links. Even if you need to migrate blog posts from WordPress to WordPress with images included, it takes care of that too.
Key Benefits at a Glance
Why do people choose this plugin? Because it makes life easier, here are the biggest wins you get right away:
Saves Hours of Work Instead of adding posts and pages one by one, you can import content into WordPress in bulk and finish in minutes.
Works with All Kinds of Content Import posts, import pages, WooCommerce products, images, and even SEO details, all from a single Excel file.
Smooth Migration Between Sites Need to migrate content from one WordPress site to another? Or migrate WordPress content to a new site? The plugin keeps everything in place, including links and formatting.
Keeps Images Intact When you migrate blog posts from WordPress to WordPress, images don’t get left behind. WordPress migrate posts with images is fully supported.
Perfect for Blog Updates Whether you want to import new posts or migrate blog posts, the plugin makes WordPress migrate content simple, accurate, and quick.
Let’s see how easy it is to get started with this smart tool!
After downloading the plugin from your WPFactory account, upload it to your WordPress site.
Step2:
➡ Access the Plugin
Once the plugin is installed and activated, you can tailor it to fit your business needs.
Go to WPFactory > “Content Excel Importer Pro”
Step3:
➡Import/Update Content
Before you start importing your data through the plugin, you need to prepare an Excel file containing the data you want to import. To prepare an Excel file that the plugin can read, download the CONTENT SAMPLE FILE.
This file is divided into columns with headers that the plugin can read.
Note: the plugin cannot handle just any Excel file. It requires a specific structure and format. So, it’s highly recommended to use the CONTENT SAMPLE FILE, as it is already formatted with the correct columns and headers that are compatible with the plugin and can read it.
After downloading it, you can modify the content within the columns and add the content you want to import to your site.
To start Import/Update your content:
Now, make sure you are in the Import/Update Content tab.
From the Select Post Type option, choose the type of content you want:
3. Then upload the Excel file you modified
4. Click the upload button, and all the data will be imported.
Step4:
➡Delete Content
This section is dedicated to deleting custom content from your site using an Excel file.
Delete only if has term
This option allows you to set a condition for deleting the content, meaning that if the condition you specified is not met, the content will not be deleted.
This condition contains of two parts:
1. Taxonomy: It refers to the type of classification (such as category, post_tag, or any custom taxonomy).
2. The Term: The term or name found within this category, (for example: News, sale, or the name of a specific category).
Practical example: If you wrote:
Taxonomy = category
Term = news
Will only be deleted if it exists under the category news.
So, from here, you select the Excel file that contains the items you want to delete and then click on the upload button.
Step5:
➡Import Category
This option is dedicated solely to creating categories (which can be for article categories, product categories, etc.)
The Excel file should contain the category name, the parent category (if it is a subcategory), the description, and the slug.
You will upload the file through the tab, and the addition will automatically create these categories on your site, under the type of content you specify.
Step6:
➡Delete Category
The same settings explained in the Delete Content section, will also apply here, but for Delete Categories section.
Step7:
➡Settings
Img/Gallery ACF – custom fields
This field is used to enter the names of the custom fields (ACF) associated with images or galleries. If you are using ACF – Advanced Custom Fields, and you want to upload images or a photo gallery from Excel file to these fields, you write the field name here.
Manually add custom field
If you have other custom fields (other than images), and you want to add data to them from Excel, you write the names of these fields here.
Who can use the plugin besides Admin?
Here, you choose who can use the extension other than the Admin.
Enable Log File
If you enable this option, the plugin will start recording the import or delete operations.
This feature is very useful for tracking if an error occurs or if you want to know what happened during the upload of the Excel file.
Step8:
➡Instructions
This section shows you some instructions that you should know regarding this plugin.
Instead of taking long hours manually transferring content transfer, and risking errors along the way, now with the Content Importer for WordPress & WooCommerce with Excel, you can import any content, blog posts, pages, custom content, all at once without the need of manual entry.
This saves you a lot of time, effort, and reduces many human errors that may occur during manual transfer. This tool can significantly ease your workflow. In addition, this giving you full control over your data, making content management faster, easier, and more reliable.
Prefer watching? This short video summarizes the article in just a few minutes.
A lot of the posts here reference WPFactory plugins because that's what we build with. All Access gets you every plugin we make, on as many sites as you run. Pay once. Own it.
