With Product Import Export Plugin for WooCommerce, you can export WooCommerce products into a CSV (Comma-Separated Values) or XML (Extensible Markup Language) 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, prices, etc in an excel spreadsheet.
Steps to Export WooCommerce Products to Excel
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:
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/XML Format section, as shown below:
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 on Export Products(CSV)/Export Products(XML) to start exporting products to CSV/XML file respectively.
To know more about exporting products, read this article.
A screenshot of the exported CSV file in Microsoft Excel is as shown below:
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 70,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 ProductBuy Now!