How to Convert WooCommerce Orders and Products CSV to Excel

To convert a WooCommerce orders or products CSV to Excel, export the CSV from WooCommerce, then open it in Excel or convert it with a free online converter. The result is a spreadsheet you can filter by order status, sort by date, total by product, and use for refunds, tax, and inventory reports.

WooCommerce does not export directly to Excel. It exports CSV, which is the right starting point. The conversion step turns that plain-text export into a real workbook with formatted dates, numeric totals, filters, and separate sheets if you want them.

Why Convert WooCommerce Exports to Excel?

A raw WooCommerce CSV is hard to work with. It opens in a text editor as a wall of commas, and even in a spreadsheet program it often needs cleanup before it is useful. Converting it to Excel gives you:

• Readable reports. Filter orders by status — completed, processing, refunded, on-hold — and see exactly the rows you need.
• Correct totals. Sum revenue by day, week, or product, and check totals against your payment processor payouts.
• Refund and customer work. Find an order by customer email or order ID, check what was bought, and process a refund with the full order in front of you.
• Product and stock checks. A products export becomes a price list you can sort, fix, and re-import, or hand to a supplier.
• Tax and accounting. Group orders by month and tax rate so your accountant gets clean numbers instead of a raw export.

If you run a store, you will repeat this export often — weekly for reports, monthly for tax, and on demand for refunds. A repeatable process matters more than a one-time trick.

What Is Inside a WooCommerce Orders CSV?

An orders export typically has one row per order, with columns for the order number, date, status, customer name and email, billing details, line items, quantities, item totals, shipping, tax, discounts, and the order total.

Line items are often packed into a single cell or spread across item columns, depending on how the export was generated. A single order with three products may show all three products in the line-item field, separated by commas or line breaks inside the cell. That is normal for CSV, but it means you may need to split or reshape the data before a pivot table works cleanly.

A products export is different: it usually has one row per product or per variation, with columns for SKU, name, price, sale price, stock quantity, stock status, categories, tags, weight, dimensions, and image URLs. This layout is already close to a spreadsheet table, so it converts more cleanly than an orders export.

Before converting, note which export you have — orders or products — because the cleanup steps differ. Orders need date, status, and total work. Products need price, stock, and image URL work.

Step 1: Export Orders or Products From WooCommerce

Export Orders

1. In WordPress admin, go to WooCommerce > Orders.
2. Use the date and status filters if you only want a slice — for example, last month's completed orders.
3. Select the orders you want, or leave the list unfiltered for a full export.
4. Use the export action to download the CSV file. Save it to a folder you can find again, and name it clearly, such as orders-2026-10.csv.

Export Products

1. In WordPress admin, go to Products > All Products.
2. Use the Export action at the top of the list.
3. Choose which columns to include. For a price-and-stock check, include SKU, name, price, sale price, stock quantity, and stock status. For a full backup, include all columns.
4. Download the CSV and save it with a clear name, such as products-2026-10.csv.

Export Tips That Save Cleanup Time

• Export a narrow date range when you only need one month. A smaller file converts faster and is easier to verify.
• Keep the original export untouched. Work on a copy so you can always re-export or compare against the source.
• Check the file size. A very large export with many years of orders may be easier to split by year or quarter before converting. If you need to split a large file by a column value, see the guide on how to split a CSV into multiple Excel sheets by column.
• Watch for commas inside fields. Customer notes, product names, and addresses can contain commas. A proper CSV wraps those fields in quotes, and a good converter or Excel's import will respect the quotes. Do not open the file in a plain text editor and re-save it, because that can break the quoting.

Method 1: Convert With a Free Online Converter (Fastest for One-Off Jobs)

For a quick conversion, an online converter is the fastest path:

1. Go to the CSV to Excel converter.
2. Upload your WooCommerce orders or products CSV.
3. Download the XLSX file.
4. Open it in Excel or Google Sheets and check the result.

After conversion, do the checks in the verification section below: dates should look like dates, totals should be numbers, and order IDs should not have lost leading zeros.

If your export contains real customer emails, phone numbers, or addresses, think before uploading. For ordinary store reports, an online converter is convenient. For exports with sensitive customer data, prefer a local method such as Excel or Power Query, which never sends the file anywhere. The same caution applies to any payroll or customer file — keep sensitive data on your own machine when you can.

Method 2: Open the CSV Directly in Excel

Excel can open a CSV directly, and for a products export this is often enough:

1. Open Excel, then open the CSV file from File > Open.
2. Excel will show the data as a single sheet.
3. Save the file as Excel Workbook (.xlsx) so future edits stay in Excel format.
4. Turn on filters on the header row with Ctrl+Shift+L.

The catch: Excel guesses column types when it opens a CSV. Dates may be reinterpreted, long order IDs may turn into scientific notation, and product codes with leading zeros may lose the zeros. If you see any of those problems, use the Text Import Wizard instead of a plain open:

1. In Excel, go to Data > From Text/CSV.
2. Select your CSV file.
3. In the preview, set the correct delimiter (usually comma) and check that headers are detected.
4. Change the data type of problem columns — order IDs, SKUs, ZIP codes — to Text before loading.
5. Click Load and save as XLSX.

The Text Import Wizard takes one extra minute and prevents the most common conversion damage.

Method 3: Clean and Shape With Power Query (Best for Recurring Reports)

If you export WooCommerce data every week, Power Query is worth the setup. You build the cleanup once, and then you refresh it when a new export arrives.

A useful Power Query cleanup for orders:

1. Load the CSV with Data > Get Data > From File > From Text/CSV.
2. In the Power Query Editor, set the date column to Date type and the total columns to Decimal Number type.
3. Set order IDs, SKUs, and phone numbers to Text type so nothing is reformatted.
4. Split the line-items field if you need one row per product. In Power Query, you can split a column by delimiter and then expand the result into new rows.
5. Filter out test orders or cancelled orders if your report should exclude them.
6. Close and load to a worksheet.

For products, Power Query is useful for normalizing categories and fixing image URLs. You can split the image column if a product has multiple images, trim whitespace from names, and replace blank sale prices with the regular price before loading.

Power Query also pairs well with combining files. If you export orders monthly and want one workbook for the year, you can combine several monthly CSVs into one table. The guide on combining multiple CSV files with Power Query walks through that flow.

Cleaning Up the Converted File

Most WooCommerce exports need a little cleanup after conversion. Work through this list:

Fix Dates

Order dates may arrive as text such as 2026-10-05 14:32:10 or in a locale format. Select the date column, use Data > Text to Columns or Format Cells > Date, and confirm the dates sort from oldest to newest. If a date column sorts alphabetically instead of chronologically, it is still text — convert it to a real date type.

Fix Totals and Currency

Totals should be numbers, not text. If a total column aligns left and will not sum, it is stored as text. Select the column, change the format to Number or Currency, and use Text to Columns with a single click-through to force conversion. Remove any currency symbols from the cells before summing, or keep the symbols only as cell formatting, not as typed characters.

Fix Order IDs and SKUs

Order IDs and SKUs must stay as text. If 001234 became 1234, the leading zeros are gone. The safest fix is to re-import with those columns set to Text in the import preview. You cannot reliably restore leading zeros after they are dropped, because you cannot tell which codes originally had them.

Handle Multi-Item Orders

If line items are packed into one cell, decide what your report needs. For a revenue summary, the packed cell is fine — the order total already reflects all items. For a product-level report, split the cell so each product gets its own row, and divide or repeat the order total carefully so you do not double-count revenue. A common approach: keep the packed cell for reference, and build a separate product-level table only when you need it.

Remove Test and Cancelled Orders

Filter the Status column and decide which statuses belong in your report. A monthly revenue report usually includes completed and processing orders, and excludes cancelled, failed, and refunded orders — or shows refunds as a separate negative line. Be explicit about what you excluded so the report is reproducible.

Building a Simple Sales Report From the Converted File

Once the data is clean, a pivot table turns it into a report:

1. Select any cell inside the orders table.
2. Go to Insert > PivotTable and place it on a new sheet.
3. Put Date in Rows, grouped by month.
4. Put Order Total in Values, summarized as Sum.
5. Put Status in Filters so you can switch between all orders and completed orders only.

For a product report, put Product Name in Rows and Quantity and Line Total in Values. Sort descending to see your best sellers.

For a full walkthrough of pivot tables after a CSV conversion, see the guide on creating a pivot table after converting CSV to Excel.

Common Mistakes With WooCommerce CSV Exports

Opening the CSV and Saving It Again as CSV

If you open the CSV in Excel, make edits, and save it as CSV again, Excel may rewrite dates, drop leading zeros, and change delimiters. Always save your working copy as XLSX. Keep the original export as a backup.

Trusting the First Total You See

A pivot total that looks right can still be wrong if the underlying totals are stored as text or if refunded orders are included. Always compare the pivot total to a manual sum of a small sample, and to your payment processor's payout for the same period.

Double-Counting Multi-Item Orders

Splitting a multi-item order into one row per product is useful, but if you then sum the order total on every row, you count the same order several times. When you split rows, sum line-item totals, not order totals.

Ignoring Time Zones

Order dates in WooCommerce use your store's time zone setting. If you compare WooCommerce totals to a payment processor that reports in a different time zone, a few orders near midnight can land in different days. For monthly totals this rarely matters, but for daily reports it can shift numbers by a small amount.

Forgetting to Re-Check After Re-Import

If you edit the products file and re-import it into WooCommerce, re-export afterward and confirm the changes took effect. A failed re-import can leave prices or stock unchanged while the spreadsheet looks correct.

Frequently Asked Questions

Can WooCommerce export directly to Excel?

No. WooCommerce exports CSV. You convert that CSV to Excel by opening it in Excel, using Power Query, or using an online converter such as the CSV to Excel converter. The conversion is quick, and the result is a standard XLSX workbook.

How do I convert only last month's WooCommerce orders?

Filter the Orders list by date and status before exporting, then convert the smaller CSV. A narrow export converts faster and is easier to verify. Name the file with the month, such as orders-2026-09.csv, so you can find it later.

Why do my order totals show as text after conversion?

Totals show as text when the CSV stores them with currency symbols, thousands separators, or extra spaces. In Excel, remove the symbols, set the column to Number format, and use Text to Columns to force conversion. Then confirm the column sums correctly.

How do I handle orders with multiple products in one row?

Keep the packed line-item cell for order-level reports. For product-level reports, split the cell into one row per product and sum line-item totals instead of order totals, so revenue is not double-counted.

Is it safe to upload a WooCommerce export to an online converter?

It depends on the data. A products export with prices and stock is low risk. An orders export with customer emails, phone numbers, and addresses is sensitive, so prefer a local method such as Excel or Power Query for that file. When in doubt, convert sensitive files locally.

Final Checklist

Before you use a converted WooCommerce file for reports or re-import:

• Dates sort chronologically and are real date values.
• Totals are numbers and sum correctly.
• Order IDs and SKUs kept their leading zeros.
• Statuses are filtered the way your report needs.
• Multi-item orders are handled without double-counting revenue.
• The original export is saved as a backup.
• Sensitive customer data was converted locally, not uploaded.

If every check passes, your WooCommerce data is ready for reports, refunds, and accounting.