SOLVED
Home

Microsoft Bookings - Reports

%3CLINGO-SUB%20id%3D%22lingo-sub-197177%22%20slang%3D%22en-US%22%3EMicrosoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197177%22%20slang%3D%22en-US%22%3E%3CP%3EWould%20love%20to%20be%20able%20to%20report%20on%20Microsoft%20Bookings.%3CBR%20%2F%3EFuture%20pipe%20line%2C%20previous%20appointments%20%26nbsp%3Bect.%3C%2FP%3E%3CP%3Eis%20this%20in%20the%20roadmap%20at%20all%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-197177%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebookings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECalendar%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOutlook%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355277%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355277%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20export%20function%20seems%20to%20have%20been%20taken%20off.%20Any%20info%20how%20to%20get%20the%20data%20from%20the%20bookings%3F%20(I'm%20on%20a%20mac%20computer%20so%20no%20Get%20Data%20is%20working%20from%20Excel%20either.)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299472%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299472%22%20slang%3D%22en-US%22%3E%3CP%3EWorking%20for%20me%20as%20well%20now%2C%20but%20is%20only%20picking%20up%20bookings%20from%20mid-October%20onwards%20-%20so%20it%20can't%20be%20used%20for%20historical%20reporting%20but%20is%20still%20a%20big%20step%20forward.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-298691%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-298691%22%20slang%3D%22en-US%22%3E%3CP%3EMine%20is%20now%20working%2C%20Louise.%3C%2FP%3E%3CP%3ESave%20the%20TSV%20file%20to%20your%20desktop%2C%20open%20excel%2C%20then%20go%20File%20%26gt%3B%20Open.%20bottom%20right%20of%20this%20screen%20select%20all%20files%2C%20then%20find%20the%20TSV%20file.%3C%2FP%3E%3CP%3Epress%20next%20to%20the%20promps%20and%20you%20will%20have%20a%20simple%20view%20of%20your%20bookings!%3C%2FP%3E%3CP%3EModern%20technology!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293332%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293332%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20just%20tried%20that%20but%20it%20still%20wont%20download%2C%20asks%20me%20to%20open%20with%20word%20etc%20but%20nothing%20shows%20%2F%20downloads%20-%20i'll%20keep%20trying%20at%20least%20with%20chrome%20it%20opens%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293319%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293319%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20only%20get%20mine%20to%20open%20whilst%20using%20Google%20Chrome..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293317%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293317%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20quick%20reply%20%3A)%3C%2Fimg%3E%20i%20did%20see%20the%20option%20for%20the%20CSV%20file%20but%20the%20link%20on%20my%20homepages%20doesn't%20seem%20to%20work.%20I'll%20check%20with%20our%20admin%20that%20we%20have%20the%20latest%20update%20as%20this%20would%20be%20a%20huge%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293315%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293315%22%20slang%3D%22en-US%22%3EYes%20this%20is%20now%20working%20for%20me%20with%20newly%20created%20calendars%2C%20but%20only%20seems%20to%20export%20data%20after%201st%20October%202018%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293307%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293307%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20seems%20to%20have%20been%20an%20update%20over%20the%20past%20couple%20of%20days.%3C%2FP%3E%3CP%3Eyou%20can%20now%20export%20some%20data%20to%20TSV%20file%20-%20you%20can%20open%20this%20with%20Excel%2C%20mine%20however%20downloads%20a%201kb%20file%20without%20any%20data%20on..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esee%20link%20below%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Freporting-information-for-microsoft-bookings-e150b415-d335-4818-93ac-acff4797a1b1%3Fui%3Den-US%26amp%3Brs%3Den-GB%26amp%3Bad%3DGB%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Freporting-information-for-microsoft-bookings-e150b415-d335-4818-93ac-acff4797a1b1%3Fui%3Den-US%26amp%3Brs%3Den-GB%26amp%3Bad%3DGB%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293285%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293285%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20the%20same%20result%20-%20reporting%20on%20bookings%20is%20essential%20-%20is%20there%20an%20alternative%20address%20to%20enter%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-227784%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-227784%22%20slang%3D%22en-US%22%3EHas%20anyone%20got%20the%20Dash%20API%20setup%20for%20Bookings%3F%20This%20seems%20like%20it%20would%20be%20the%20way%20to%20go.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199976%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199976%22%20slang%3D%22en-US%22%3E%3CP%3Ehmmm%2C%20that's%20the%20address%20for%20my%20bookings%20page%2C%20no%20idea%20why%20it%20has%20an%20onmicrosoft%20domain%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199972%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199972%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Luis%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBased%20on%20what%20you've%20said%20the%20mailbox%20name%20you%20would%20enter%20in%20Excel%20is%26nbsp%3Bsomename%40company.onmicrosoft.com%20%2C%20although%20I%20would%20have%20expected%20you%20to%20be%20using%20your%20own%20domain%20name%20(i.e.%20company.com)%20rather%20than%20company.onmicrosoft.com%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199970%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199970%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Geoff%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20with%20your%20guide%20but%20I'm%20getting%20an%20error%20that%20the%20mailbox%20address%20isn't%20valid%2C%20my%20address%20is%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Foutlook.office365.com%2Fowa%2Fcalendar%2Fsomename%40company.onmicrosoft.com%2Fbookings%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Foutlook.office365.com%2Fowa%2Fcalendar%2Fsomename%40company.onmicrosoft.com%2Fbookings%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20about%20this%20error%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199903%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199903%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Luis%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20the%20attached%20file%20-%20hope%20that%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGeoff%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199669%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199669%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Geoff%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20explain%20me%20in%20deep%20how%20do%20you%20accomplish%20this%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199663%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199663%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20agree%26nbsp%3B%20x2%20-%20this%20would%20be%20great.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197240%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197240%22%20slang%3D%22en-US%22%3E%3CP%3EI%20agree%20-%20this%20would%20be%20great.%20The%20only%20way%20I've%20found%20so%20far%20to%20extract%20data%20from%20Bookings%20is%20using%20Excel%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EData%26gt%3BGet%20Data%26gt%3BFrom%20Online%20Services%26gt%3BFrom%20Microsoft%20Exchange%20Online%26gt%3B%20and%20then%20entering%20the%20email%20address%20associated%20with%20the%20booking%20page%20of%20the%20calendar.%20This%20will%20at%20least%20allow%20you%20to%20pull%20a%20list%20of%20bookings%20and%20show%20cancellations%2C%20etc%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1170089%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1170089%22%20slang%3D%22en-US%22%3E%3CP%3EThanks!%20It%20works!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

Would love to be able to report on Microsoft Bookings.
Future pipe line, previous appointments  ect.

is this in the roadmap at all?

18 Replies
Highlighted
Solution

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

Highlighted

I agree  x2 - this would be great. 

Highlighted

Hi Geoff,

 

Can you explain me in deep how do you accomplish this???

 

Thanks in advance,

Highlighted

Hi Luis

 

See the attached file - hope that helps.

 

Geoff

Highlighted

Thanks Geoff,

 

I tried with your guide but I'm getting an error that the mailbox address isn't valid, my address is like this:

 

https://outlook.office365.com/owa/calendar/somename@company.onmicrosoft.com/bookings/

 

Any idea about this error?

Highlighted

Hi Luis

 

Based on what you've said the mailbox name you would enter in Excel is somename@company.onmicrosoft.com , although I would have expected you to be using your own domain name (i.e. company.com) rather than company.onmicrosoft.com

Highlighted

hmmm, that's the address for my bookings page, no idea why it has an onmicrosoft domain :(

Highlighted
Has anyone got the Dash API setup for Bookings? This seems like it would be the way to go.
Highlighted

i have the same result - reporting on bookings is essential - is there an alternative address to enter?

 

thanks in advance

Highlighted

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-...

Highlighted
Yes this is now working for me with newly created calendars, but only seems to export data after 1st October 2018
Highlighted

Thanks for the quick reply :) i did see the option for the CSV file but the link on my homepages doesn't seem to work. I'll check with our admin that we have the latest update as this would be a huge help.

 

Highlighted

Could only get mine to open whilst using Google Chrome..

Highlighted

Thanks, just tried that but it still wont download, asks me to open with word etc but nothing shows / downloads - i'll keep trying at least with chrome it opens !

Highlighted

Mine is now working, Louise.

Save the TSV file to your desktop, open excel, then go File > Open. bottom right of this screen select all files, then find the TSV file.

press next to the promps and you will have a simple view of your bookings!

Modern technology!

Highlighted

Working for me as well now, but is only picking up bookings from mid-October onwards - so it can't be used for historical reporting but is still a big step forward.

Highlighted

The export function seems to have been taken off. Any info how to get the data from the bookings? (I'm on a mac computer so no Get Data is working from Excel either.)

Highlighted

Thanks! It works!

Related Conversations
google is pathetic and abominable
HotCakeX in Discussions on
4 Replies
Unable to book same day
The_IT_Wizard in Microsoft Bookings on
2 Replies
Report for Videoconferencing quality
Thomas_Steibl in Microsoft Teams on
3 Replies
Collaboration for services
Derek Miller in Microsoft Bookings on
2 Replies
Overnight booking possible?
polken in Microsoft Bookings on
0 Replies