Others

How to Download a Microsoft Bookings TSV Report with Power Automate

Camila MilosovichCamila Milosovich Nov 13, 2026 868 views

Question details

The user wants to download a Microsoft Bookings calendar report in TSV format and create a custom recurring export when the standard report does not meet reporting requirements.

How to Download a Microsoft Bookings TSV Report with Power Automate
Product
Microsoft Bookings and Power Automate
Device & OS
not provided
Scenario
The user needs a Bookings calendar report in TSV format and may need a custom or recurring export because the built-in report is limited.
Observed behavior
The built-in Microsoft Bookings report provides only a limited 120-day calendar TSV download, so a custom Power Automate export is needed for more specific or recurring reporting requirements.
Before you start

Confirm that you have access to Microsoft Bookings and its reporting page. If you plan to automate the export, make sure your account can create Power Automate flows and that you can configure a Microsoft Graph custom connector or Azure AD app registration.

Solution 1

Download the built-in 120-day calendar TSV file from Microsoft Bookings

Use this solution when the standard Bookings report meets your requirements and you only need a quick manual export.

Microsoft Bookings includes a built-in calendar report, but the standard TSV download is limited to a 120-day date range.

1
Open Microsoft Bookings reporting

Sign in to Microsoft 365, open Bookings, and go to the reporting or calendar view that contains the Bookings calendar report.

2
Export the TSV file

Select the desired date range within the 120-day limit, then choose the download or export option to save the TSV file.

Built-in report limit: The standard calendar report is limited to 120 days. For longer periods or recurring custom exports, use the Power Automate method instead.
Free Microsoft Office alternative

Use WPS Office as a Free Microsoft Office Alternative for Report Files

WPS Office does not change how Microsoft Bookings or Power Automate export reports, but it is a free, lightweight office suite that opens, edits, and shares Microsoft Office-compatible spreadsheets, CSV, and TSV files with a familiar interface.

Opens and edits the TSV, CSV, and Excel report files produced by Microsoft Bookings and Power Automate without needing a Microsoft 365 license.Free, lightweight Office alternative with a familiar ribbon-style interface for easy migration.Strong compatibility with Microsoft Excel, Word, and PowerPoint file formats.Includes WPS Spreadsheets, Writer, and PDF tools to clean, analyze, and distribute exported reports.
microsoft office alternative - wps office

Frequently Asked Questions

Can I download more than 120 days of data from Microsoft Bookings?

No, the built-in calendar report is limited to a 120-day TSV window. For a longer or custom export, create a Power Automate flow that calls the Microsoft Graph Bookings API and writes the results to SharePoint.

Do I need special permissions to automate the Bookings report with Power Automate?

Yes. You need an account that can create flows in Power Automate and a custom connector or Azure AD app registration with the appropriate Microsoft Graph permissions for Bookings data.

Can WPS Office open the TSV or CSV file produced by the export?

Yes. WPS Spreadsheets can open TSV, CSV, and Excel-compatible files, so you can view, clean, and analyze the exported report without Microsoft 365.

How can I make the custom report file refresh daily?

Use a recurrence trigger in Power Automate and add an action that creates or overwrites the CSV or TSV file in SharePoint. The flow can delete and recreate the file on each run so the latest Bookings data is always available.

What should I do if the standard Microsoft Bookings TSV download does not meet my reporting format?

Build a Power Automate flow to call the Bookings API, parse the JSON, and write a custom CSV or TSV file. You can then open and organize the resulting file in WPS Office Spreadsheets.