Importing WooCommerce Products From Microsoft Excel File

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

If you have product data in Microsoft Excel spreadsheet and wish to import it to your WooCommerce, our Product Import Export Plugin for WooCommerce can easily help you achieve that. Before importing, you have to save your Excel file with the .csv extension, that’s as simple as clicking Save As and selecting Comma Separated Values from the file type drop-down list.

Let us understand this procedure with the help of the following example:

Suppose, you have following products on your excel spreadsheet as shown in the screenshot of a sample excel spreadsheet below:

csv file

Note: You can download a sample CSV here.

Following are the steps to import products:

  • Navigate to WooCommerce > Product Im-Ex section of the plugin. Under Product > Import, move to Import Product in CSV Format section, as shown below:

Import-Products-settings

Import settings Choose a file from the file selection option and click Upload file and import. You can also map the fields with column headings (CSV file header), and use Evaluation field to fix/update the required value for the particular field. Finally, click Submit to import the products into your online store.

To know more about importing products, read this article.

Once the import is successfully we can see the products have come perfectly into the system. Here, are the product pages of simple and variation product.

Simple Product

simple product 1

In the above image, you can see the simple product – Samsung Galaxy Ace Duos is imported to WooCommerce as specified in the CSV.

Variation Product

Variation Product 1

In the above image, you can see the variation product – Men’s Cotton T-Shirt is imported to WooCommerce with two variations – blue and red, as specified in the CSV.

To know more about other features of the plugin, read the documentation.

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Leave a Reply

Your email address will not be published. Required fields are marked *