WooCommerce to Excel
Push every WooCommerce order into a live Excel Online workbook on OneDrive the moment it is placed. Orders, products, and customers land in the workbook your finance team already reconciles in - no Zapier tasks, no Power Automate flows, no CSV downloads at month-end.
Requires the Pro tier ($79/yr or $199 lifetime), which includes WooCommerce Sync. Mirroring into Excel alongside Google Sheets is included; Excel as the sole destination also requires Primary Destinations, part of the AI Pack ($29/mo or $290/yr).
The WooCommerce-to-Excel Gap
WooCommerce reporting lives inside wp-admin, but the people who close the books do not. Finance teams reconcile revenue in Excel, and getting orders there today means hand-exporting CSVs or paying Zapier per order - a snapshot that is stale before the file finishes downloading. SheetLinkWP's Excel Online destination closes the gap with live order rows via Microsoft Graph. No plugin covers WooCommerce to Excel Online, and SheetLink is the only multi-builder WordPress plugin with direct Excel Online delivery.
How Stores Get Orders Into Excel Today
- Manual CSV export from the WooCommerce admin - free, but a stale snapshot every time, and someone has to remember to run it before each close
- Zapier meters every order as a task - a store doing 1,000 orders a month is deep into paid tiers, and each status change counts as another task
- Power Automate needs a webhook bridge plus Premium per-user licensing (~$15/user/mo), and a flow someone has to maintain when it breaks
- Google-Sheets-first workarounds sync a Sheet into Excel on a delay - two tools, an import lag, and a second copy to reconcile
How to Connect WooCommerce to Excel Online
Step-by-step setup guide
- 1
Install SheetLink & Activate the WooCommerce Sync Add-on
Install the free SheetLink Forms plugin, activate your Pro license ($79/yr or $199 lifetime) on the SheetLink -> License page, then activate the WooCommerce Sync module from SheetLink -> Add-ons. Setup details are in the WooCommerce Sync docs.
- 2
Connect Microsoft
Go to SheetLink -> Destinations -> Excel Online and click Connect Excel. Sign in with a Microsoft 365 work or school account. The OAuth handshake runs through SheetLink's hosted broker - no Azure app registration, no client secret on your site - and your refresh token is encrypted at rest.
- 3
Pick a Workbook and Table
Select an existing workbook on OneDrive or create a new one, then choose the table that should receive order rows. Existing Excel tables are detected automatically, so you can point SheetLink at the reconciliation workbook your finance team already uses.
- 4
Configure Order Data Streams
Go to SheetLink -> WooCommerce. Toggle the data types you want (Orders, Products, Customers), choose which order status changes trigger a row, pick a line item mode (flatten or expand), and map order fields to Excel columns.
- 5
Test with a Sample Order
Place a test order and confirm the row lands in your Excel table within seconds - check line items, shipping, tax, and customer details. For a click-by-click walkthrough, see the tutorial: WooCommerce orders to Excel Online, automatically.
SheetLinkWP Excel Features for WooCommerce Users
Real-Time Order Rows via Microsoft Graph
Each order posts straight from WordPress to Microsoft Graph and appears in a live workbook on OneDrive within seconds. Not a nightly export, not a CSV - the same workbook your team opens in Excel desktop, Excel on the web, or the mobile app.
Order Status Triggers
Choose which status changes write to Excel: new orders only for revenue reporting, or the full lifecycle for fulfillment tracking. Each trigger is configurable per status.
Line Item Handling
Two modes: flatten an order into a single row with delimited values, or expand it into one row per line item with the order data repeated - the shape most PivotTables and finance models actually want.
Product & Customer Sync
Beyond orders, sync your product catalog (SKU, stock, prices) and customer records (spend, order count, addresses) into their own Excel tables for margin and cohort analysis.
No Per-Order Fees
WooCommerce Sync is included in the Pro tier ($79/yr or $199 lifetime) with no volume-based pricing. Zapier's task metering punishes exactly the stores that need automation most; SheetLink's price is the same at 50 orders or 5,000.
Retry Queue
If Microsoft Graph is briefly unreachable, failed deliveries retry automatically - 3 attempts at 15-minute intervals - with manual retry from the Retry Queue page. No order silently missing from the close.
Feature Comparison
| Feature | Zapier | Power Automate | SheetLinkWP |
|---|---|---|---|
| Monthly cost | $29.99+/mo, task-metered | ~$15/user/mo Premium | Pro $79/yr; +$29 Excel-only (AI Pack) |
| Per-order fees | Yes - per task | Flow-run limits per license | None |
| Delivery | Near real-time | Flow runs | Real-time via Microsoft Graph |
| Order status triggers | Single trigger per Zap | Build one flow per status | Configurable per status |
| Line item handling | Limited | Manual expressions | Flatten or expand |
| UTM capture | Extra config | Manual expressions | Automatic |
| Retry on failure | Auto-retry | Configure yourself | 3 auto retries + manual queue |
Frequently Asked Questions
Which add-ons do I need?
Just the Pro tier ($79/yr or $199 lifetime), which includes WooCommerce Sync as a source. Mirroring orders into Excel alongside Google Sheets is included at no extra cost. Only if you want Excel Online as the sole destination - no Google Sheet at all - do you also need Primary Destinations, part of the AI Pack at $29/mo or $290/yr.
Is this a CSV export?
No. Each order is written into an Excel Online workbook on OneDrive via Microsoft Graph the moment it is placed. There is nothing to download or import, and the workbook your finance team reconciles from is always current.
Does it work with Microsoft 365 Business?
Yes. Microsoft 365 Business, Enterprise, and Education accounts all work. Personal Outlook.com accounts are not supported by Microsoft's Excel API. Connect once with Microsoft OAuth and pick your workbook.
Which order events write a row to Excel?
SheetLinkWP hooks into woocommerce_new_order and woocommerce_order_status_changed, and you choose which statuses trigger delivery - new orders only, completed orders only, or the full lifecycle for fulfillment tracking.
How are order line items handled in Excel?
Your choice of two modes: flatten (one row per order with delimited line item values) or expand (one row per line item, with order totals and customer data repeated on each row). Expand mode is usually the right shape for PivotTables and revenue models.
Can our finance team build dashboards on the data?
Yes. Because orders land in a real Excel workbook on OneDrive, PivotTables refresh as rows arrive, and Power BI can sit directly on the workbook for live sales dashboards - revenue by day, by product, by campaign - without any export step.
Other Supported Integrations
WooCommerce
Sync WooCommerce orders, products, and customers to Google Sheets in real time.
WPForms
Push every WPForms submission into a live Excel Online workbook the moment it arrives.
Gravity Forms
Deliver every Gravity Forms entry into a live Excel Online workbook - compound fields decomposed into columns, multi-page forms captured on final submit, payment metadata included.
WooCommerce Orders in Excel the Moment They Are Placed
Real-time delivery to the workbook your finance team already opens. Excel mirroring is included with the WooCommerce Sync add-on; see pricing for the full breakdown.