How to Export Orders from WooCommerce in CSV or XML Format

To export WooCommerce orders, use one of three built-in methods Classic Reports, the WordPress Export Tool, or WooCommerce Analytics or install an order export plugin for full control over fields, filters, and formats.

This guide covers every method step by step: how to export WooCommerce orders to CSV or XML without a plugin, how to use a free plugin to export orders with custom fields, and how to export WooCommerce customer data, coupon data, and order data to Excel, QuickBooks, or Xero.

How to Export WooCommerce Orders Without a Plugin

WooCommerce provides three built-in options for exporting order data. Each has a different scope and format.

Method 1: Classic WooCommerce Reports (CSV)

The Classic Reports tool is still available in WooCommerce even as it is being phased out in favor of Analytics. It lets you export summarized sales data to CSV by date, product, category, coupon, or download.

Steps:

Step 1. Go to WooCommerce > Reports in your WordPress dashboard.

Step 2. Click the Orders tab.

Step 3. Choose a report type:

• Sales by date: filter by year, last month, this month, last 7 days, or a custom date range.
• Sales by product: review and download per-product sales figures.
• Sales by category: export sales data for a specific product category.
• Coupons by date: download discount usage data.
• Customer downloads: export download records for digital products.

Step 4. Set your desired date range or filter.

Step 5. Click Export to CSV to download the file.

What the CSV includes:

• Date
• Number of items sold
• Number of orders
• Average net sales
• Coupon amount
• Shipping amount
• Gross and net sales
• Refund amount

Limitations of Classic Reports:

• Summary data only no individual order numbers, order statuses, or customer details.
• No product-level details such as SKU, variation, or quantity per order.
• No customer segmentation or purchase history.
• Limited filter and customization options.

Method 2: WordPress Export Tool (XML)

The WordPress Export Tool downloads a complete XML file of your WooCommerce orders. It is the fastest way to get a full order history export in XML format, though it does not support filtering.

Steps:

Step 1. Go to Tools > Export in your WordPress dashboard.

Step 2. Select Orders from the list of content types.

Step 3. Click Download Export File.

WordPress will generate an XML file covering your entire order history.

What the XML includes:

• Order date and time
• Order number and status
• Payment method and currency
• Customer IP address and browser
• Billing name, address, phone, and email
• Discount and tax amounts
• Shipping details and shipping tax
• Order total

Limitations:

• Exports all orders at once — no date range or status filtering.
• XML is not human-readable and cannot be opened directly in Excel.
• Requires XML editing tools to modify or transform the data.
• Not practical for analysis or integration with most accounting or CRM tools.

Method 3: WooCommerce Analytics (CSV)

WooCommerce Analytics is the current built-in reporting system and replaces the Classic Reports tool. It requires WordPress 5.3 or later. It offers advanced filters, nine report types, and CSV downloads.

How to export WooCommerce orders using Analytics:

Step 1. Go to Analytics > Orders in your WordPress dashboard.

Step 2. Set your date range using the date picker at the top. You can select a preset (today, yesterday, last 7 days, last month, and so on) or enter a custom range.

Step 3. Use the Compare to option if you want to compare results against the previous period or previous year. This comparison is required — you cannot skip it.

Step 4. Apply any additional filters from the Orders tab (order status, product, customer type).

Step 5. Click the Download button to export a CSV file.

What the CSV includes:

• Date
• Order number and status
• Customer name and type
• Products and items sold
• Coupon code
• Net sales

How to export WooCommerce customers from Analytics:

Go to Analytics > Overview, then click on any customer to open the Customers page. From there, apply your filters and click Download.

The customer export CSV includes: name, username, last active date, registration date, email, number of orders, total spend, average order value (AOV), country, city, region, and postal code.

Other reports available for CSV download in Analytics:

• Products
• Revenue
• Variations
• Categories
• Coupons
• Taxes
• Downloads
• Stock

Limitations of WooCommerce Analytics for order export:

• You are required to set a comparison period there is no option to skip it.
• The export only includes completed orders and orders with refunds. Processing orders and other non-completed statuses may be excluded.
• The Order Status filter does not always work as expected, which can cause orders to be missing from the export.
• If the comparison period (previous year or previous period) has no completed sales, Analytics will not display or export any current data at all.
• You cannot download your full order history in a single export.
• Navigation can be unintuitive for new users.

How to Export WooCommerce Orders Using a Plugin

A WooCommerce order export plugin fills the gaps left by the built-in tools. For stores that need full order history exports, custom field exports, specific order status filters, or scheduled auto-exports, a plugin is the practical choice.

Using the Advanced Order Export for WooCommerce Plugin

The Advanced Order Export for WooCommerce plugin (free on WordPress.org) supports CSV, XLS, XML, TSV, PDF, HTML, and JSON formats. It gives you granular control over which fields to include, how to label columns, and which orders to include based on status, date, product, or custom field.

Steps:

Step 1. Install and activate Advanced Order Export for WooCommerce from the WordPress plugin repository.

Step 2. Go to WooCommerce > Export Orders in your dashboard.

Step 3. Set your filters:

• Date range
• Order status (pending, processing, completed, refunded, and so on)
• Customer type
• Product or product category
• Coupon usage

Step 4. Select the fields to include in the export. You can also rename column labels and reorder columns.

Step 5. Choose your export format: CSV, XLS, XML, or another supported format.

Step 6. Click Preview to review the file before downloading, then click Export to download.

What the export includes (default settings):

• Order number, status, and date
• Billing and shipping name, company, address, city, state, postcode, country
• Customer email and phone
• Payment method
• Cart discount, order subtotal, shipping method, shipping amount
• Refund, total, and total tax amounts
• SKU, item name, quantity, and item cost
• Coupon code, discount amount, and discount tax

Exporting WooCommerce orders with custom fields: The plugin supports custom order fields and custom product terms. You can add any custom field assigned to orders or products to your export without additional configuration.

Exporting WooCommerce orders for QuickBooks or Xero: Use the CSV export from this plugin and import it into QuickBooks or Xero using their standard CSV import workflow. For Xero, match the column headers to Xero’s required format before importing. For QuickBooks Desktop, use the IIF import option or a third-party connector.

Scheduling automatic WooCommerce order exports: The pro version of the plugin supports scheduled exports you can configure daily, weekly, or monthly auto-exports delivered to an email address or FTP location. This is useful for accounting teams or dropshipping partners who need regular order data without manual downloads.

Exporting WooCommerce Orders to Excel

WooCommerce does not export directly to .xlsx format. To get a WooCommerce orders Excel file, export to CSV first and then open the file in Microsoft Excel or Google Sheets.

Steps:

Step 1. Export your orders as a CSV using WooCommerce Analytics or the Advanced Order Export plugin.

Step 2. Open Microsoft Excel.

Step 3. Go to File > Open and select the CSV file. Excel will open it with data in columns.

Step 4. If needed, use Data > From Text/CSV to control delimiter settings for a cleaner import.

Step 5. Save the file as .xlsx using File > Save As.

For recurring exports to Excel or Google Sheets, the Advanced Order Export plugin (pro) can automate the delivery schedule.

When to Use CSV vs. XML

Your choice of format depends on how you plan to use the data.

CSV (Comma-Separated Values):

• Best for analysis in Excel, Google Sheets, or similar tools
• Supported by most accounting and CRM platforms (QuickBooks, Xero, HubSpot)
• Human-readable and easy to share with stakeholders
• Ideal for order data, customer lists, and sales reports

XML (Extensible Markup Language):

• Best for structured data integration with other software systems
• Carries data relationships and tags, making it easier to parse programmatically
• Used for site migrations and full-site content transfers
• Not suitable for direct analysis in spreadsheets

For most WooCommerce store owners, CSV is the practical default. XML is typically used for data migration or integration with systems that specifically require it.

Best WooCommerce Order Export Plugin: Advanced Order Export for WooCommerce

Advanced Order Export for WooCommerce is the most capable free option for exporting WooCommerce order data. It handles everything the built-in tools cannot: custom field exports, granular status filters, full order history downloads, and multiple file formats.

Key Features

• Select specific fields to include and rename column labels
• Reorder columns to match your target system’s format
• Export WooCommerce custom fields for orders, products, and coupons
• Apply filters by date, order status, customer type, product, and coupon
• Bulk export and mark orders after export
• Supported formats: CSV, XLS, TSV, PDF, HTML, XML, JSON
• Schedule automatic exports (pro version)

The free version covers most export scenarios for small and mid-size stores. The pro version adds scheduled exports, FTP delivery, and additional integration options.

Frequently Asked Questions

Key Takeaways

• WooCommerce has three built-in export options: Classic Reports (CSV, summary only), WordPress Export Tool (XML, full history, no filters), and WooCommerce Analytics (CSV, filtered but with comparison period required).
• WooCommerce Analytics is the most feature-rich built-in option, but it cannot export all orders at once and excludes non-completed statuses unless a refund is present.
• To export WooCommerce orders with custom fields, by specific order status, or on a schedule, you need a plugin; the free Advanced Order Export for WooCommerce plugin covers most needs.
• To get a WooCommerce ordered Excel file, export to CSV first and open it in Excel or Google Sheets; save as .xlsx from there.
• For QuickBooks or Xero integration, export a CSV and use each platform’s standard import flow, mapping columns as needed.
• CSV is the right format for analysis, reporting, and accounting integrations. XML is better suited for site migrations and system-to-system data transfers.