Plugins Plugin hub Backup SEO Caching Security Forms WooCommerce Images Best backup plugins
Hosting Hosting directory Shared hosting Managed WordPress Cloud hosting VPS hosting By reader location Hosting finder
Themes & builders Compare Rank Math vs Yoast
Tools All tools Hosting finder Plugin stack builder Cost calculator Salt generator Theme detector Who is hosting this? Speed test Headline analyzer robots.txt generator Redirect generator Uptime calculator Blog name generator
Blog Best backup plugins Deals
Guides All guides Speed up WordPress Choose hosting Back up WordPress
How we test

WooCommerce · Guide

How to Export WooCommerce Orders to CSV (Built-in and Plugin Methods)

How to Export WooCommerce Orders to CSV (Built-in and Plugin Methods)

Short answer

To export WooCommerce orders to CSV without a plugin, go to WooCommerce > Analytics > Orders, choose the date range and any filters, then click Download above the orders table. WooCommerce sends a CSV of the report, emailing a link for large exports. For custom columns, line items or scheduled exports, use an order export plugin instead.

Key takeaways

  • WooCommerce Analytics can download order reports as CSV without any plugin.
  • Large Analytics exports run in the background and arrive by email.
  • Export plugins add custom columns, line items, filters and scheduled exports.
  • Pick the export format your accounting or fulfilment tool expects before exporting.
  • Order exports contain personal data, so store and share them carefully.

Why export WooCommerce orders to CSV?

CSV exports let you move order data into spreadsheets, accounting software, fulfilment partners or reporting tools, and keep an offline record of sales for a given period.

Common reasons include monthly bookkeeping, tax reports, sending orders to a warehouse, analysing sales by product, and auditing refunds or discounts.

A CSV file is plain text with values separated by commas, so almost any spreadsheet or business tool can open it, from Excel and Google Sheets to accounting and shipping software.

Before exporting, check what the receiving tool needs. Accountants often want one row per order, while warehouses usually want one row per item.

How do you export orders with WooCommerce Analytics?

Go to WooCommerce > Analytics > Orders, set the date range, apply any filters you need, then click Download above the orders table to get a CSV of the report.

  1. Go to WooCommerce > Analytics > Orders
  2. Choose a date range at the top
  3. Use Show and Advanced filters to narrow the orders, if needed
  4. Choose which columns to show in the table
  5. Click Download above the table
  6. Open the CSV in a spreadsheet app

The WooCommerce Analytics documentation explains that every report table includes a CSV download option.

If the report spans more than one page, WooCommerce processes the download in the background and emails you a link when it is ready.

What does the Analytics export include?

The Analytics orders CSV includes summary columns such as date, order number, status, customer, customer type, products, items sold, coupons and net sales, depending on the columns you choose.

It is designed for reporting, not for importing orders into another system. It does not include full billing and shipping addresses or one row per line item.

If your data looks out of date, check the analytics data status and update it. Recent WooCommerce versions show when analytics data was last refreshed.

How do you export full order details with a plugin?

Install an order export plugin, choose orders as the export type, select the columns you need, such as billing address, line items and payment method, set filters and run the export.

Plugins exist in the WordPress plugin directory and on WooCommerce.com. Popular free and paid options let you pick fields, rename columns and export to CSV, Excel or XML.

WooCommerce's own Customer / Order / Coupon Export extension supports manual and automated exports of orders, customers and coupons.

Choose a plugin that is actively maintained and compatible with your WooCommerce version, especially if your store uses high-performance order storage.

Which columns should you include?

Include only what the receiving system needs, such as order number, date, status, totals, taxes, shipping method, payment method and, for fulfilment, product SKUs and quantities.

Fewer columns make files easier to read and reduce the personal data you share. You can always run a second export with different columns.

Keep column names and their order consistent between exports. Accounting imports and spreadsheets often rely on exact column headers.

How do you export orders from the Orders screen?

Some export plugins add bulk actions to WooCommerce > Orders, so you can tick specific orders or filter the list and choose Export to CSV from the Bulk actions menu.

This is handy for exporting a handful of orders, such as today's shipments or a batch for a particular supplier.

Without an export plugin, the Orders screen has no built-in CSV export. Use Analytics or install a plugin to add the option.

How do you schedule automatic order exports?

Paid export plugins and extensions can run exports on a schedule and send the file by email, FTP, SFTP or to a cloud folder, so your accountant or warehouse receives orders automatically.

Automatic exports save time for stores with daily fulfilment or monthly bookkeeping. Set them to export only new orders since the last run.

Test the first few scheduled files carefully, comparing them with the orders screen. A wrong filter can send duplicates or miss orders without anyone noticing.

How do you open the CSV correctly?

Open the file in a spreadsheet app such as Excel or Google Sheets using UTF-8 encoding, check that dates, currency and leading zeros look right, and avoid saving over the original export.

Some spreadsheet apps change long numbers or remove leading zeros from postcodes and phone numbers. Importing the file with text formatting for those columns prevents this.

If accented characters look wrong, the file was opened with the wrong encoding. Re-import it as UTF-8.

The CSV format itself is described in RFC 4180, which many tools follow when reading and writing these files.

How do you keep exported order data safe?

Treat order exports as sensitive files, since they contain names, addresses, emails and purchase history; store them securely, share them only with people who need them and delete old copies.

Avoid emailing full exports when a shared secure folder works instead. Remove columns such as phone numbers when the recipient does not need them.

Data protection laws such as the GDPR apply to customer data in exports. The European Commission's data protection overview summarises the main obligations.

How do you export orders for accounting?

Export orders with totals, tax, shipping, discounts, refunds and payment method for the period, or connect an accounting integration that syncs orders automatically instead of using CSV files.

Many accounting tools offer WooCommerce integrations that send each order to your books as soon as it happens. That avoids manual exports and reduces typing errors.

If you do use CSV, agree a fixed format with your accountant and keep it the same every month.

What if the export is missing orders?

Check the date range and status filters, refresh analytics data if you use Analytics, and confirm the plugin supports your order storage method and payment statuses.

Analytics excludes some statuses by default, such as cancelled or failed orders, depending on your settings. Adjust the actionable and excluded statuses under Analytics settings if needed.

For very large stores, exports may time out. Background exports, smaller date ranges or a plugin that processes in batches usually solve this.

How do you export customers and products too?

Customers can be downloaded from WooCommerce > Customers or the Analytics customer report, and products can be exported to CSV from Products > All Products with the built-in Export button.

The product exporter lets you choose columns, product types and categories, and it creates a file you can later import into another store with the built-in product importer.

Customer exports are useful for loyalty programmes or moving to a new email platform. Only export customers who agreed to marketing if you plan to email them.

Keep these exports separate from order files. Mixing customers, products and orders in one sheet makes them hard to re-import.

How do you move orders to another store?

Use a migration plugin or a full database migration rather than CSV, because order CSVs usually cannot recreate orders with their customers, payments and notes intact.

Some export plugins pair with import tools that can rebuild orders, but they need careful field mapping and testing on a staging site first.

Our guide on migrating a WooCommerce store explains the safest approaches.

How often should you export orders?

Match the schedule to how the data is used: daily for fulfilment, weekly for stock planning, and monthly or quarterly for accounting and tax.

Name files consistently with the date range, such as orders-2026-11.csv, so they are easy to find later and nobody exports the same period twice.

How do you back up orders beyond CSV exports?

Use full site and database backups for real protection, since a CSV export is a report rather than a complete copy of your store's data.

Orders link to customers, products, refunds and notes. Only a database backup preserves all of these relationships.

Our guide on backing up a WooCommerce store covers how often to back up and what to include.

Frequently asked questions

Can I export WooCommerce orders to CSV without a plugin?

Yes. Go to WooCommerce, then Analytics, then Orders, set the date range and filters, and click Download. The CSV contains the report columns rather than every order detail.

Why did WooCommerce email me the export instead of downloading it?

Large Analytics exports that span more than one page are processed in the background. WooCommerce emails a download link when the file is ready.

How do I export order line items and addresses?

Use an order export plugin or WooCommerce's Customer, Order and Coupon Export extension. These let you choose fields such as billing and shipping addresses and individual line items.

Can WooCommerce export orders automatically?

Yes, with a paid export plugin or extension. They can run scheduled exports and deliver files by email, FTP or cloud storage.

Why are leading zeros missing in my exported CSV?

Spreadsheet apps often treat postcodes and phone numbers as numbers and drop leading zeros. Import the file and set those columns to text format to keep them intact.

Sources

  1. WooCommerce Analytics WooCommerce Docs
  2. Customer / Order / Coupon Export WooCommerce Docs
  3. RFC 4180: Common Format and MIME Type for CSV Files RFC Editor
  4. Data protection European Commission
  5. Plugin search: WooCommerce order export WordPress.org Plugins

Is your product missing, or something out of date?

Tell us what to add or correct. We read every note and reply when we need a source. A message does not buy a ranking.

About the editors

Written and checked byWPLegible Editorial Team Independent WordPress reviews and guides

Researched from the primary sources listed above and checked against our editorial rules before publishing.