Importing WooCommerce Products from Microsoft Excel File

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:

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

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

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.