How to build dynamic Confluence reports from live SharePoint and OneDrive data

Katerina Rudkovskaya [Stiltsoft]

Hey Atlassian Community! 👋

If your team works across both Microsoft 365 and Atlassian Cloud, you’re likely familiar with this reporting bottleneck:

1. Operational logs or budget sheets are updated in SharePoint or OneDrive.
2. Someone manually downloads the spreadsheet, formats the rows, and pastes a static table into Confluence.
3. Days later, the source numbers change, leaving the Confluence page outdated.

Instead of keeping static snapshots, you can now stream tabular files directly from Microsoft 365 and build live, interactive reports inside Confluence Cloud.

The Workflow in 2 Steps:

1. Using the Live Table from SharePoint and OneDrive macro in Live Tables from CSV & JSON for Confluence, paste your file link and complete a quick OAuth 2.0 authorization. Any new updates in SharePoint or OneDrive automatically reflect on the Confluence page.
2. Wrap the live data output inside Table Filter, Charts & Spreadsheets for Confluence to:
   • Filter rows on the fly: Let stakeholders filter by dates, status, or categories without altering the master spreadsheet.
   • Aggregate summary metrics: Group metrics with pivot tables (spend per team, ticket counts by priority, etc.).
   • Visualize trends: Generate real-time bar, line, and pie charts that update automatically alongside the source file.

Want to see the full step-by-step setup?

We broke down the complete walkthrough, common approaches, and real-world enterprise reporting scenarios in our detailed guide:

👉 Read the full article on the Stiltsoft Blog

How is your team currently bridging the gap between Microsoft 365 storage and Confluence reporting? Are you still relying on manual exports, or using automated live feeds?