WooCommerce shows orders on screen, but accounting and stock reviews happen in a spreadsheet.
Choose the period and statuses
Usually the past month, processing and completed orders.
Pick only useful columns
Order, date, customer, country, items and total are enough for most needs.
Per order or per item
Per order for accounting, per item to see what sold.
Separators and accents
European Excel expects semicolons and decimal commas; a UTF-8 file with BOM keeps accents and the euro sign.
Exportly does all of this in one click. See the demo.
Frequently asked questions
Why are my accents broken in Excel?
The file needs UTF-8 with BOM.
Comma or semicolon?
Semicolon for most European Excel versions.
Can I export one line per product?
Yes, choose one row per item.