How to Download Appointment Data
Issue:
How do I pull a report of my Bookings appointment information?
Solution:
Microsoft Bookings provides a default report of appointment information. This report can be ran for any four month period the user selects (past or future).
Please Note - This information is downloaded as a TSV file, but can be converted to an XLS to be viewed in Excel.
1, On the Booking calendar dashboard, select Export more data as TSV.
2. Select the date range of your file and select "Export".
3. View the downloaded file within your local Downloads folder.
4. In the Downloads folder right click the file and select “rename” to save the file with a new name, and adjust the file extension from .tsv to .xls.
5. In the example below, the file is renamed to “BookingNameChange.xls”.
Changed to:
Open the file to see the 120-day view of your Booking calendar.
6. Open the file to view the appointment data.
7. If desired when viewing the file, you may re-save your file to an Excel workbook (.xlsx).
Microsoft documentation on the fields included in the report can be found here: Reporting info for Bookings
Related articles