Microsoft 365
Microsoft Excel
Export reports to Excel and import bulk data from prepared workbooks.
Microsoft
Microsoft 365 · Accounting
On RequestWorks with AnantaTech Hub · Provided by Microsoft
What this connects
Report output and bulk import to Excel workbooks.
Supported workflows
- Exporting reports for analysis
- Bulk product, customer or opening-balance import
- Handing figures to an accountant
Data exchanged
- Tabular report data
- Import records
- Column mappings
Setup requirements
- A prepared workbook matching the expected column structure
Permissions required
- File access on the device performing import or export
Security and privacy
- Data is transmitted over encrypted connections (TLS).
- Credentials and tokens are stored server-side and never exposed to the browser.
- Access can be revoked at any time from the provider's own account settings.
Known limitations
Stated plainly, because finding these out during implementation is worse than knowing them now.
- Import requires the column layout to match the expected template; mismatches are reported rather than guessed.
Need Microsoft Excel connected?
Tell us how you use it today and we will confirm what is possible for your configuration before anything is committed.

