Pangoni + Microsoft Excel
Pull Pangoni data into Excel with a live connection — rent rolls, arrears reports, and income statements refresh at the click of a button.
What you'll be able to do
- Connect Excel to the Pangoni API via Power Query for live-refreshing tables.
- Build custom rent rolls, arrears ageing, and collection reports in Excel.
- Export any Pangoni list to .xlsx with one click — tenants, leases, payments, invoices.
- Share templated reports with owners and accountants who prefer Excel.
- Use your existing Excel models and pivots on fresh Pangoni data.
Building something sooner? The Pangoni API is open today — your developer can wire Microsoft Excel to Pangoni directly. See the API overview for endpoints and authentication.
Why this matters for Kenyan landlords
Most Kenyan landlords still keep rent records in Excel — even after they switch to property management software. Their accountant wants Excel, their owner reports go out in Excel, and they personally feel comfortable double-checking numbers in a spreadsheet. Pangoni's Excel integration accepts that reality and makes it useful: a live connection between Pangoni and Excel so your spreadsheets refresh automatically with current rent rolls, arrears, and income statements.
How the Microsoft Excel integration works
Once shipped, setup looks like this. Your data flows in the background; you keep working in both tools.
Generate an Excel connection token
Pangoni issues a read-only token tied to your account. Tokens can be scoped per property or per data type.
Add a Pangoni data connection in Excel
Use Excel Data > From Other Sources > Pangoni Connector (we ship a connector add-in) or the OData URL.
Pick the data tables
Tenants, leases, payments, invoices, properties, arrears, expenses — bring in whatever your spreadsheet needs.
Refresh on demand or schedule
Refresh manually or set Excel to auto-refresh daily. The data updates in place — your formulas and pivot tables don't break.
Share the workbook
Share via SharePoint, OneDrive, or just attached to an email. The recipient sees the data as of the last refresh.
Real use cases from Kenyan landlords
- A landlord whose accountant insists on a monthly Excel rent roll: the spreadsheet is now a live view of Pangoni, no manual updates needed.
- A property manager building custom owner-statement spreadsheets: each owner's workbook refreshes from their property's Pangoni data.
- An old-school landlord who genuinely prefers Excel for analysis: keep the Excel workflow, swap the data source from manual entry to Pangoni.
Frequently asked
The Microsoft Excel integration is on the Pangoni roadmap and being built. Sign up for a Pangoni account today and we will email every account the moment it ships. In the meantime, you can use the Pangoni API to wire Microsoft Excel directly if your team has developer capacity.
The Microsoft Excel integration will be included on Pangoni Elite (KSh 3,500/month for landlords) and all Agent and Agency plans at no additional charge. You only need an active Microsoft Excel subscription on your side.
Yes. The Microsoft Excel integration is built around the same multi-property and multi-owner model as the rest of Pangoni — each property maps to the right account on the Microsoft Excel side, and reporting can be filtered per property or per owner.
Yes. The Pangoni API is fully open and your developer can wire Microsoft Excel to Pangoni today. See the API documentation at api.pangoni.com — webhooks for real-time events, REST endpoints for data, OAuth for authentication.
Be first to know when it's live
Sign up for Pangoni today — we'll email every account when the Microsoft Excel integration ships. In the meantime you'll get the rest of Pangoni: M-Pesa rent collection, tenant management, and financial reporting.
Sign up free