Exporting WooCommerce Products to 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!

With Product Import Export Plugin for WooCommerce, you can export WooCommerce products into a CSV (Comma-Separated Values) file. If you wish to save all product data in a Microsoft Excel file rather than CSV, simply open the CSV in Microsoft Excel and save it with .xls extension. That’s as simple as clicking Save As and selecting Excel Workbook from the file type drop-down list. With this, you can get all the details about products like images, categories, price, etc in an excel spreadsheet.

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

Suppose, you have two products in your WooCommerce store. A variable and a simple product as shown in the screenshot of  the WooCommerce product page below:

product-page

Following are the steps to export products with their respective attributes:

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

screenshot-woocommerce-product-export-import

If you wish to skip a certain number of products, enter an offset value from which you wish to start the export. You can specify a limit to export a finite number of products. You can also specify product categories and product types to be exported. Configure other settings and select desired columns to be exported. Finally, click Export Products to start exporting products. The CSV file is automatically downloaded on your computer.

To know more about exporting products, read this article.

A screenshot of the exported CSV file in Microsoft Excel is as shown below:

exported-csv

Note: You can download a sample CSV here.

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 *