WooCommerce Order Export Excel Analysis
WooCommerce exports orders to Excel with one row per line item, not per order. This structure makes it difficult to calculate total order values, identify refunded orders, or group sales by customer without manual cleanup.
Upload your WooCommerce order export and get order-level metrics without pivot tables or duplicate removal.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountOr start with
What this export contains
| Order ID |
| Order Date |
| Order Status |
| Billing Name |
| Billing Email |
| Product Name |
| Product SKU |
| Quantity |
| Item Cost |
| Item Total |
| Order Total |
| Payment Method |
| Shipping Method |
| Customer Note |
Common questions
How do I analyze a WooCommerce order export in Excel?
WooCommerce order export Excel files have one row per line item, not per order, so Order Total repeats for each product. To analyze revenue correctly, sum Order Total only for unique Order IDs using SUMIF or remove duplicate Order IDs first. Filter out refunded orders by excluding rows where Order Status contains 'refunded', since those still show the original amount.
Why is my revenue total wrong when I sum the Order Total column?
Order Total repeats on every line item row. An order with three products shows the same Order Total three times. You need to sum Order Total only for unique Order IDs, or use SUMIF to count each order once.
How do I separate completed orders from refunded ones?
Filter the Order Status column to exclude any row containing 'refunded'. Refunded orders still show the original Order Total, so leaving them in inflates your revenue. Completed orders typically show 'wc-completed' or just 'completed'.
Can I get one row per order instead of one row per product?
WooCommerce exports one row per line item by default. To consolidate, you need to group by Order ID and aggregate the product details, which requires pivot tables or formulas that concatenate Product Names for each unique order.
Why won't my Order Date column sort correctly?
The export uses your WordPress site's date format, which Excel may read as text instead of dates. Select the column, use Text to Columns with the correct date format, or reformat cells to Date type matching your locale.
How do I find the best-selling product when variations are separate rows?
Sum Quantity by Product Name or Product SKU. If you want to group all variations of a product together, you'll need to extract the base product name before the variation details, usually everything before a hyphen or size indicator.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file