WooCommerce – Export Orders to CSV (Excel, Google Sheets, etc.)

Imagine you want to review the progress of your online store, and you need a detailed report of the orders you have received. The best way to achieve this would be to export all WooCommerce orders to a CSV file that you can review and edit with Excel or Google Sheets.

Important: This post shows you how to generate a CSV compatible with Google Sheets or Excel. But if you want to export your orders directly to Google Sheets, you can follow this tutorial using our Google Sheets Sync service.

For this, you’ll need to use the WooCommerce Orders Spreadsheet plugin, which displays all your orders and their complete information on a spreadsheet, where you can edit your orders quickly.

These are some features you can find in this spreadsheet.

• Bulk Edit – You can apply massive changes to all your orders in seconds.
• Search – You can filter all your orders in minutes and apply changes to them.
• Import – You can import a lot of orders from a CSV created with Excel or Google Sheets.
• Export – You can export all your orders and their complete information to a CSV from Google Sheets or Microsoft Excel.
• Locate cell/column – You can enter values to find the exact cell/column where those values are.

This plugin will completely simplify your orders’ management.

Once installed and activated, you need to open the plugin by going to Sheet Editor > Edit Orders.

Now you’re ready to export all your orders. Just follow these simple steps.

If you don’t want to filter your orders, go to step two.

1- Optional: Filter the orders you’ll export

To filter your orders, you need to open the Search tool, which is located on the plugin’s toolbar.

Once you open the search tool, you’ll find these search options.

• Contains keyword – Enter a keyword to search for all the orders containing it on the title.
• Status – You can search for all your orders with these statuses: Pending Payment, Processing, On hold, Completed, Cancelled, Refunded, Failed, Trash.
• Find orders containing these products – You can search for orders containing specific products.
• Order notes – You can search for all orders containing a specific keyword in the order notes.
• Enable advanced filters – This checkbox enables the filters you need to search for your orders by billing and shipping info, order total, date range, etc.

Whatever option you select, click on Run search to filter all your orders. Then, you’ll see all your filtered orders displayed on the spreadsheet.

2- Export your orders to a CSV file

The Export tool is located on the top toolbar. So you need to click to open it, and select these values.

• Click on Select all to export all the columns, or select specific columns
• Tick the I understand it will export all the posts from my current search
• OPTIONAL: Tick the I will edit this file with Microsoft Excel
• Click on Start new export to start the export process.

Done!

This is how simple it is to export WooCommerce orders to your computer. You can print, edit, and import them back to WooCommerce using the Import tool if you want.