Send WooCommerce Orders to Excel Online Automatically
Skip the daily CSV export. SheetLink Pro adds each WooCommerce order to a table in your Excel Online workbook as it happens, through Microsoft Graph, with no automation service in between.
In This Guide
- Why Do CSV Order Exports Keep Breaking?
- How Does Direct WooCommerce-to-Excel Delivery Work?
- How Do You Connect Microsoft 365 to WordPress?
- How Do Order Fields Reach the Right Columns?
- Excel Alongside a Sheet, or Excel Alone?
- What Happens When a Write Fails?
- Manual CSV Export vs Direct Delivery
- What Can You Do With a Live Order Table?
- Does This Work Beyond WooCommerce Orders?
- How Do You Get Started?
- Frequently Asked Questions
Why Do CSV Order Exports Keep Breaking?
Because an export is a snapshot, not a feed. Someone has to run it, the file is out of date as soon as the next order arrives, and pasting its rows into the workbook the team actually uses is where mistakes get in.
The fix is not a better export. It is to stop exporting: have each order written to the workbook when it happens, so the workbook is the record and nobody has to remember anything.
How Does Direct WooCommerce-to-Excel Delivery Work?
WooCommerce Sync, the part of SheetLink Pro that handles store events, listens on your own site for six of them: order created, order completed, order refunded, customer created, product created and product updated. From SheetLink Pro 1.2.0, each event can be added as a row to a table in your Excel Online workbook.
The row goes from your WordPress server to Microsoft Graph, the API behind Excel Online. There is no automation service in the path and no charge per order. The write is scheduled when the event fires and runs straight afterwards, outside the customer's request, so a slow workbook never holds up checkout.
How Do You Connect Microsoft 365 to WordPress?
Once, on the SheetLink → Excel Online screen. Click Connect Excel, sign in with the Microsoft 365 work or school account that can open the workbook, then pick the workbook and click Save workbook + table.
You do not register an application in Azure. A SheetLink sign-in service sets up the connection and renews its access token, and that is all it does: it never receives an order, and the refresh token is stored encrypted in your own WordPress database.
Personal Microsoft accounts (Outlook.com, Hotmail, consumer OneDrive) cannot be used. Microsoft's Excel API does not accept writes to workbooks stored there, so this needs a work or school account with OneDrive for Business or SharePoint.
How Do Order Fields Reach the Right Columns?
By heading. In Excel, make a table for the event and name its columns after the fields you want. On the event's card under SheetLink → WooCommerce Sync, tick Also add this event as a row in an Excel table and pick that table. There is no mapping screen.
A column is filled when its heading matches a field, ignoring capitals, spaces and punctuation, so "Order ID" receives order_id. For an order the fields are order_id, status, total, net_total, total_refunded, currency, email, first_name, last_name, phone, billing_city, billing_country, items, date_created, date_paid, date_modified, billing_state, tax_total, shipping_total, discount_total, coupon_codes, payment_method, payment_method_title, shipping_address, shipping_city, shipping_state, shipping_postcode and shipping_country. A column headed event receives the event's name. Columns that match nothing stay empty, which leaves room for your own notes and formulas.
Totals are written as numbers, so they can be summed. All of an order's items go into one cell, as product names with quantities; there is no mode that writes one row per line item. Each event can use its own table, so refunds and customers do not have to share columns with orders.
Excel Alongside a Sheet, or Excel Alone?
Both work, and the difference is the licence. Excel alongside a Google Sheet is part of WooCommerce Sync; Excel as an event's only destination requires SheetLink Plus ($29/month or $290/year).
Alongside means the event card has a Receiver URL for a Google Sheet and an Excel table. The two are sent, logged and retried separately, so a problem with one does not hold back the other. Alone means the Receiver URL is left empty. If the licence does not cover that, the save warns you and nothing is written to Excel until it does.
What Happens When a Write Fails?
Every write is listed in the Sync Log. If Microsoft is unavailable, throttling, or the workbook is locked, the row is queued in WordPress and retried about 5 minutes, 30 minutes and 2 hours later. If the last retry also fails it is kept in the Retry Queue with its full contents, where one click re-sends it.
Some failures cannot be fixed by waiting, such as a table that was deleted. Those are logged and not retried. And if you add or remove a column in Excel, SheetLink reads the table's headings again and sends the row once more, so a changed table does not need a visit to WordPress.
Manual CSV Export vs Direct Delivery
The table sets the two side by side. The export costs nothing in software and something in attention every day; direct delivery is the other way round.
What Can You Do With a Live Order Table?
A table that grows by one row per event is ready for the things Excel is good at. A PivotTable on the orders table gives revenue by day, by status or by billing country. SUMIFS on total between two dates gives a period total without filtering anything by hand.
One caution. These are event rows: an order that is created, completed and then refunded produces three rows. Keep each event in its own table, or filter on the event column, before adding up a total. The refund event carries refund_amount and net_total, which is the figure to use for what you actually kept.
Does This Work Beyond WooCommerce Orders?
Yes. Form submissions reach Excel through the free SheetLink Forms plugin, which supports 12 form plugins, and 17 with Pro. A site connects one workbook: form rules write to one table in it, and each WooCommerce event can write to its own table beside it. The Excel Online page covers the form side.
How Do You Get Started?
- Install the free SheetLink Forms plugin and SheetLink Pro (1.2.0 or later), and activate a Pro or Agency licence.
- Connect Microsoft 365 and choose the workbook under SheetLink → Excel Online.
- Make a table for each event, with headings named after the fields you want.
- Under SheetLink → WooCommerce Sync, tick the event, tick the Excel row, pick the table and click Save all events.
- Press Send test, then place a test order.
The WooCommerce to Excel Online page has every step, the headings for all six events and the fixes for the usual problems.
| Manual CSV export | SheetLink direct to Excel | |
|---|---|---|
| Timing | A snapshot, run by hand | Per event, as it happens |
| Human steps | Sign in, filter, export, paste | None after setup |
| Where mistakes get in | Copying rows between files | No re-keying |
| If Excel is unreachable | Does not apply | Retried, then kept for a one-click re-send |
| Cost | Staff time | A Pro licence; no fee per order |
Frequently Asked Questions
Does sending WooCommerce orders to Excel Online require Zapier?
No. WooCommerce Sync writes each order from your WordPress server to Excel Online through Microsoft Graph. There is no automation service in between and no charge per order.
What does it cost?
WooCommerce Sync is part of SheetLink Pro, $79/year or $199 lifetime, and of Agency. Excel alongside a Google Sheet is part of WooCommerce Sync; Excel as an event's only destination requires SheetLink Plus, which is $29/month or $290/year.
How fast does an order reach the workbook?
Usually within moments. The write is scheduled when the event fires and run straight afterwards, outside the checkout request. There is no polling schedule.
What happens if Microsoft Graph is temporarily down?
The row is queued, not lost. It is retried about 5 minutes, 30 minutes and 2 hours later, and if the last retry fails it is kept in the Retry Queue for a one-click re-send.
Which order fields can I put in the table?
The order number and status, the total, net total, amount refunded and currency, the billing email, name, phone, city and country, the line items in one cell, and the order date. Name a column after a field and it is filled.
Do I need my own Azure app registration?
No. You sign in with a Microsoft 365 work or school account through SheetLink's sign-in service. It sets up the connection and renews the access token; it never receives an order.
Does it work with a personal Microsoft account?
No. Microsoft's Excel API does not accept writes to workbooks in a personal OneDrive, so a Microsoft 365 work or school account is required. This is a Microsoft limit, not a SheetLink plan limit.
Can the same install also send WordPress form data to Excel?
Yes. Form submissions go to Excel through the free SheetLink Forms plugin. Form rules write to one table in the connected workbook, and each WooCommerce event can use its own table in the same workbook.
More Tutorial guides
Put Every Order in Your Excel Workbook
Connect Microsoft 365 once, name a table's columns after the fields you want, and each WooCommerce order arrives as a row. Part of SheetLink Pro.
