How it works
- Say what can be used. Add a small configuration table to the workbook that names the inputs and outputs (and any tables) AccessEXL may read or update, with allowed values and limits for each input.
- Connect the workbook. Sign in with Microsoft and pick the workbook from your organisation's SharePoint. It stays where it is.
- Call it. Send the input values to one endpoint. The workbook recalculates with your own formulas and the outputs come back in the same response.
What you can do
- Run what-if scenarios: set inputs, recalculate and read results in one atomic call.
- Read and write named cells and ranges, and read or add rows to Excel tables.
- Use the same workbook from Make.com, Zapier, Power Automate, n8n, your own code or an AI assistant.
- Keep control: every workbook has its own key, access is per organisation, and what can be touched is limited to what the workbook's configuration table lists.
Good to know
- The workbook must be stored in SharePoint or OneDrive for work (Microsoft 365).
- Accounts need a work email address; personal email addresses are not accepted.
- Calls count against your plan's monthly allowance; see the pricing page for the plans.
Frequently asked questions
Can I call an Excel workbook from an API?
Yes. AccessEXL connects a workbook stored in SharePoint or OneDrive for work and exposes the named ranges and tables you choose over a secure HTTPS API. You send input values, the workbook recalculates with its own formulas, and you read the results back.
Does the workbook leave SharePoint?
No. The file stays where it is. AccessEXL reads and writes only the ranges and tables listed in a configuration table inside the workbook, and each workbook has its own API key that can be rotated or revoked.
What do I need to start?
A work email address, a workbook in SharePoint or OneDrive for work with a small configuration table (APIConfigTable) that lists what may be read or written, and permission to connect it with your Microsoft account.
Is there a machine-readable description of the API?
Yes, an OpenAPI description is published at https://accessexl.accessanalytic.com.au/openapi.json.
Connect your first workbook API reference Pricing