Connect Excel
Many entrepreneurs run their business from Excel: a tab with orders, a few formulas for margin, a pivot for the overview. The only annoying part is getting the data in. Schakel writes your orders, revenue and returns from Bol.com and your webshop straight into your Excel workbook in Microsoft 365, so your overview stays current without you downloading and pasting an export.
What travels with Excel
-
Orders per row
Every order lands as a row in your workbook, with order number, date, products, quantity and amount.
-
Revenue and costs
Revenue, commission and shipping can go in their own columns, ready for your margin formula.
-
Returns
Returns land in their own tab with the refunded amount, so your net revenue is right.
Why connect Excel
- Your trusted Excel overview always stays current.
- Margin and pivots on fresh figures, no pasting.
- Bol.com and your webshop in the same workbook.
- Never download and import an export again.
How it works
- 01
Request the connector
Request the connector and get access. You connect your sales channel and grant access to an Excel workbook in OneDrive or SharePoint.
- 02
Pick your columns
You decide which fields go in which columns, so it fits your existing workbook.
- 03
Stays current
From then on new orders are added automatically and your formulas calculate along.
Excel, common questions
Can I export my Bol.com revenue to Excel?
Yes. Request the connector and get access; your Bol.com orders and revenue land as rows in your workbook, together with your webshop if you connect it.
Does this work with Excel on my PC or only online?
It writes to a workbook in Microsoft 365 (OneDrive or SharePoint). You open that in Excel on your PC as usual; the rows are already there.
What do I need to start?
A Microsoft 365 account with a workbook and the channel you want to connect. Request the connector and get access.
A Excel connection you do not see here?
Tell us which system Excel should connect to. Request it and you get access; you hear from us within 24 hours.