Forum Discussion
Microsoft Bookings - Reports
I agree - this would be great. The only way I've found so far to extract data from Bookings is using Excel:
Data>Get Data>From Online Services>From Microsoft Exchange Online> and then entering the email address associated with the booking page of the calendar. This will at least allow you to pull a list of bookings and show cancellations, etc
There seems to have been an update over the past couple of days.
you can now export some data to TSV file - you can open this with Excel, mine however downloads a 1kb file without any data on..
see link below
https://support.office.com/en-gb/article/reporting-information-for-microsoft-bookings-e150b415-d335-4818-93ac-acff4797a1b1?ui=en-US&rs=en-GB&ad=GB
I have been using the bookings for about 1 year now, and it still does not show anything being booked in the home section of bookings, even though we are getting loads of appointments. This being said, when I export to TSV, there is no data. Am I missing a setting or something?
Thanks!
I hope this is helpful
How to export Bookings to an Excel sheet
Find out the ID that Bookings uses for a calendar. In our case I defined the business name as “School Primary School” and so so the name it used was
school@school.com
- Go to the MS admin portal and change the password of that user
- Log on to https://outlook.office.com/calendar with that user
- Go to Settings – View all Outlook Settings -> Shared Calendars – Select the calendar
- Check that your own user can view the calendar
- Go to the desktop Outlook app
- Go to File -> Account Settings -> Account Settings -> Change -> More settings -> Advanced -> Add mailbox and enter your equivalent of
school@school.com - Click OK -> Next -> Done -> Close
- Click File -> Open and Export – Import/Export -> Export to File -> Next -> Comma Separated Values -> Next
- Choose the calendar that matches your business name
- Next -> Choose a file name (I chose calendar_output.CSV -> Next -> Finish
- Choose a date range – OK
- Open the exported CSV and open another new Excel sheet. The new excel sheet needs two rows:
- Row one contains the following text fields
- Date
- Start Time
- End Time
- Length
- Staff Member
- Student Email
- Join link
- Name_Pos
- Name-Len
- Email_Pos
- Email_len
- Booking_pos
- Join_pos
- Join_len
- If_you_pos
- Row two should contain the following formulas
- =(calendar_output.CSV!B2)
- =(calendar_output.CSV!C2)
- =(calendar_output.CSV!E2)
- =C2-B2
- =(calendar_output.CSV!K2)
- =MID(calendar_output.CSV!P2,L2,M2)
- =MID(calendar_output.CSV!P2,N2,O2)
- =MID(calendar_output.CSV!P2,Q2,R2)
- (…blank – for sanity)
- =HYPERLINK((MID(calendar_output.CSV!P2,Q2,R2)),"Join link")
- =(calendar_output.CSV!A2)
- =FIND("Name:",calendar_output.CSV!P2)+6
- =N2-L2-6
- =FIND("Email:",calendar_output.CSV!P2)+6
- =P2-N2-6
- =FIND("Booking Info",calendar_output.CSV!P2)+6
- =FIND("Join Teams Meeting",calendar_output.CSV!P2)+18
- =S2-Q2
- =FIND("If you need a local number, get one here",calendar_output.CSV!P2)
- Copy/drag row two down to match the number of rows in calendar_output.CSV
- You should see your data in an easy to read format.
SimonWindisch I found that the export in the bookings page does work, you just need to change your date range to when the bookings are expected to happen, not when the bookings take place. Once i changed the date to one day past our scheduled event, the TSV file was fully populated.
One limitation i did notice is that the when it is imported into Excel, the person who received the booking is only their initials, not their full name. This caused confusion because we had multiple employees with the same 2 initials.
Thanks for the Reply!
- Amazing! Thank you! This has saved me so long as was about to give up and manually create a list!
