Analyze WooCommerce Order Export Data in Seconds
WooCommerce exports one row per line item, not per order, which breaks pivot tables and makes totals wrong. The CSV includes combined billing addresses, mixed date formats, and product variations that need splitting before you can analyze sales by SKU or customer.
Upload your WooCommerce order export and get a clean dataset where each order appears once, addresses are split into usable columns, and you can pivot by product without double-counting revenue.
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 Address |
| Billing First Name |
| Billing Last Name |
| Billing Email |
| Product Name |
| Product SKU |
| Quantity |
| Item Cost |
| Item Total |
| Order Total |
| Payment Method |
Common questions
Why is my revenue total three times higher than WooCommerce shows?
The export repeats the Order Total on every line item row. An order with three products appears three times with the full order amount on each row. Sum only unique Order IDs or use a pivot table that groups by Order ID first.
How do I filter orders by state when Billing Address is one cell?
WooCommerce combines street, city, state, and postal code into one Billing Address field with line breaks. You need to split this column by line breaks, then extract the state from the second-to-last line before you can filter or count by state.
Can I see which t-shirt size sold if Product Name is the same for all?
Variable products export with only the parent name. The variation attributes like size or color do not appear in the standard order export. You need to cross-reference with a product export or use a plugin that adds variation details to the order CSV.
How do I create a daily sales report when Order Date has timestamps?
The Order Date column includes hours, minutes, and seconds. Extract just the date portion into a new column using a date function, then pivot or group by that column to see sales per day.
Do refunded orders show negative amounts in the export?
No. Refunded orders keep their original positive Item Total and Order Total. The Order Status column shows 'Refunded', but the amounts do not change. Filter out refunded rows or subtract them manually to calculate net revenue.
Why do some orders have multiple Billing Email entries?
Each line item row repeats the billing information. If an order has four products, the customer's email appears four times. Use 'Remove Duplicates' on Order ID and Billing Email together if you need a unique customer list.
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