Your First 30 Minutes with Workday OfficeConnect
This is the fastest path from “Workday OfficeConnect isn’t installed yet” to “I have a refreshable Excel report showing live Adaptive Planning data.” It threads together the canonical guides for each step so you don’t have to figure out the right order.
What you’ll have at the end: A working OfficeConnect installation, a tenant connection, and an Excel workbook with at least one live account/period/version intersection pulling from your Workday tenant.
What you’ll need:
- A Windows PC running Excel (Microsoft 365 or Excel 2021 standalone) — Mac works too, see OfficeConnect on Mac
- Your Workday OfficeConnect API client details from your Workday administrator (Client ID + two endpoint URLs)
- Workday sign-in credentials with the Access OfficeConnect permission
- 30 minutes
Minutes 0-10 — Install
Minutes 10-15 — Sign in and create your tenant
After sign-in, the Reporting pane appears on the right side of Excel populated with your Adaptive Planning accounts, time periods, and levels.
Minutes 15-25 — Build your first report
Minutes 25-30 — Save and explore
.xlsx. The OfficeConnect formulas are preserved.Result
You have a live, refreshable Workday OfficeConnect report and you understand the core build → refresh → drill workflow. From here, every other tutorial on the site builds on this foundation.
Next steps
- Common next builds: Rolling 12-Month Report, Budget vs Actuals Variance, Department P&L.
- Working with Financials data? Jump straight to Trial Balance Report.
- Picking between OfficeConnect and Adaptive web reports? See the decision framework.