How to export WooCommerce orders to CSV
Last updated: July 2026
You need your orders out of WooCommerce and into a spreadsheet — for your accountant, a VAT return, a backup or a report your bank wants. Here is the thing most guides skip: WooCommerce core has no dedicated "export orders to CSV" button. It ships a product exporter, not an order one. So the real question is which of three routes fits your situation.
This page covers all three honestly — the native workaround and its limits, the plugin route and its friction, and the one-click export from an external dashboard reading the REST API — then lists exactly which fields you can get out.
Short version: WooCommerce core can export products to CSV but not orders. Native, the closest you get is the Analytics > Orders report "download", which exports the filtered rows you see (large exports get emailed), not full order and line-item detail. For a real orders-with-line-items export you either install an export plugin (extra load, formatting work) or read the WooCommerce REST API. WooDashAI takes the REST-API route: connect read-only in ~30 seconds and export orders, customers, products, line items, refunds and taxes to a clean CSV in one click, no plugin on your site.
Method 1 — Native WooCommerce (and why it falls short)
WooCommerce core includes a CSV importer/exporter, but only for products (Products → Export, added in WooCommerce 3.1 back in 2017). There is no equivalent for orders in core. New store owners hunt for an "Orders → Export" button and it simply is not there.
The closest native route is the Analytics tab: Analytics → Orders shows a filterable table with a download control that exports the rows currently displayed to CSV. It works, but with real limits: you get the report’s columns (not the full order object with every line item, tax and meta field), the export follows whatever date filter the report is on, large exports are emailed to you rather than downloaded on the spot, and the whole thing lives behind your WordPress admin login. Fine for a quick pull, not for structured accounting data.
If someone tells you "just use WooCommerce’s built-in order export", they mean this Analytics report download. It is useful, but it is a report export, not a complete orders-and-line-items dump.
Method 2 — An export plugin (and its friction)
The common fix is an order-export plugin (free ones like "Order Export Lite" / "Advanced Order Export For WooCommerce", or WooCommerce’s own paid Customer/Order/Coupon export extension). These do give you real order exports with line items, chosen columns and scheduling. That is the upside.
- It is another plugin running inside WordPress: the export job builds the CSV on your server, so a big export can spike load — worst on shared hosting mid-day.
- Field mapping and formatting take setup: date formats, decimal separators, one-row-per-order vs one-row-per-line-item, and how taxes and refunds are represented all need configuring.
- Free plugins often gate the useful bits (scheduling, custom fields, filters) behind a paid tier.
- Every plugin is surface area to maintain and update — one more thing that can break on a WooCommerce upgrade.
If you only export once a year, a plugin is a reasonable choice — install, export, deactivate. If you export regularly, running the job on your storefront’s server every time is the part worth avoiding.
Method 3 — One-click export over the REST API (WooDashAI)
The cleanest route for regular exports is to read the official WooCommerce REST API from outside your site — the same /wp-json/wc/v3/orders endpoint WooCommerce documents — and generate the CSV off-server. Nothing is installed on your store, so building the file never competes with your checkout.
WooDashAI does exactly this. You connect once with read-only API keys, and your orders (plus customers, products, line items, refunds and taxes) are ready to export to a clean, spreadsheet-ready CSV in a click. Filter by date range first, export only what you need, repeat whenever — without logging into WordPress and without a plugin dragging on your host.
- 1Connect your store: Create a free WooDashAI account and generate a read-only WooCommerce REST API key (or install the one-click helper plugin). Paste your store URL and key.
- 2Let the sync run: WooDashAI pulls your orders, customers, products, line items, refunds and taxes over the REST API in about 30 seconds — nothing is installed to slow your store.
- 3Filter to what you need: Pick the date range and the data you want to export — for example only orders from last quarter for your accountant.
- 4Export to CSV in one click: Download a clean CSV ready for Excel, Google Sheets or your accounting software. Repeat any time without touching WordPress.
Which fields you can export
A useful order export is more than order number and total. Reading the REST API gives you the full picture:
| Object | Typical fields |
|---|---|
| Orders | Order ID, status, date, currency, subtotal, shipping, discount, total, payment method |
| Customers | Name, email, billing and shipping address, guest vs registered, order count |
| Line items | Product, variation, SKU, quantity, unit price, line total |
| Products | Name, SKU, category, price — to enrich each line item |
| Refunds | Refund amount, date, reason, linked order |
| Taxes | Tax rate, tax total per order and per line — for VAT reporting |
Common reasons to export orders to CSV
- Accounting and bookkeeping: hand your accountant a clean file instead of admin screenshots.
- VAT / sales-tax returns: line-item tax totals per period, ready to total in a spreadsheet.
- Backups: an off-site copy of your order history you control, independent of your host.
- Reporting in Excel or Google Sheets: pivot tables, custom charts and formulas your analytics tool does not have.
- Sharing without admin access: send figures to a partner, investor or bank without handing over a WordPress login.
WooCommerce order export FAQ
Can I export WooCommerce orders without a plugin?
Partly. WooCommerce core has no dedicated order exporter, but the Analytics > Orders report has a download control that exports the filtered rows to CSV — useful, though it is the report’s columns, not full order and line-item detail, and it is emailed for large exports. For a complete export without installing anything on your site, use a tool that reads the WooCommerce REST API from outside (like WooDashAI): you connect with read-only keys and export in one click, no plugin on your store.
How do I export only orders from a date range?
The native Analytics > Orders report lets you set a date filter before downloading, so the CSV covers just that window. Export plugins add date filters too. In WooDashAI you pick the date range first, then export — so you can pull, say, only last quarter’s orders for your accountant without exporting your whole history.
Does WooCommerce have a built-in order export?
Not a dedicated one. Core ships a product CSV importer/exporter (since WooCommerce 3.1), but there is no core "export orders" button. The nearest native option is the Analytics > Orders report download; a full orders-with-line-items export needs a plugin or the REST API.
Will exporting orders slow down my store?
It depends on the method. A plugin builds the CSV on your own server, so a large export can spike load — noticeable on shared hosting. Reading the WooCommerce REST API from an external tool builds the file off-server, so it has no impact on your storefront speed.
Can I export WooCommerce customers and refunds too, not just orders?
Yes. The REST API exposes customers, line items, refunds and taxes alongside orders, so a tool reading it (like WooDashAI) can export all of them. That is what makes it suitable for accounting and VAT, where you need tax totals and refunds, not just order headers.
Export your WooCommerce orders in one click
Connect your store with read-only API keys in ~30 seconds and export orders, customers, line items, refunds and taxes to a clean CSV — no plugin, no slowdown.
Free: 1 store, 30 days of history, no card. Pro €19/month, Business €49/month.