SOLVED

Export Appointments in MS Bookings to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-191451%22%20slang%3D%22en-US%22%3EExport%20Appointments%20in%20MS%20Bookings%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191451%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20that%20I%20can%20export%20MS%20Booking%20customer%20appointments%20for%20a%20service%20to%20Excel%20or%20in%20another%20format%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EErika%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-191451%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebookings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-262689%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20Appointments%20in%20MS%20Bookings%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-262689%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20so%20much%20Geoff%20for%20the%20help%20and%20tips%2C%20much%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-262670%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20Appointments%20in%20MS%20Bookings%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-262670%22%20slang%3D%22en-US%22%3E%3CP%3EA%20new%20feature%20has%20been%20introduced%20which%20should%20allow%20this%20but%20it's%20not%20currently%20working%20for%20me%20(or%20anyone%20else%20I%20have%20heard%20from).%20I%20have%20a%20ticket%20raised%20with%20Microsoft%20to%20resolve...%20see%20this%20thread%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20title%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Bookings%2FExport-more-data-as-TSV%2Fm-p%2F253802%23M608%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Bookings%2FExport-more-data-as-TSV%2Fm-p%2F253802%23M608%22%20target%3D%22_self%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Bookings%2FExport-more-data-as-TSV%2Fm-p%2F253802%23M608%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20an%20alternative%2C%20you%20can%20get%20some%20Bookings%20data%20out%20using%20the%20process%20I%20describe%20on%20the%20following%20thread%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Bookings%2FMicrosoft-Bookings-Reports%2Fm-p%2F197177%23M520%22%20target%3D%22_self%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Bookings%2FMicrosoft-Bookings-Reports%2Fm-p%2F197177%23M520%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-262505%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20Appointments%20in%20MS%20Bookings%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-262505%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20question%20as%20well.%20That%20would%20be%20really%20helpful%20for%20a%20lot%20of%20businesses%20I%20would%20imagine.%20Additionally%2C%20the%20ability%20to%20import%20data%20(staff%2C%20customers%2C%20addresses%20etc)%20from%20Excel%20would%20be%20awesome.%20(But%20maybe%20that's%20already%20possible%2C%20I%20%3CEM%3Ejust%3C%2FEM%3E%26nbsp%3Blearned%20about%20Bookings%20today).%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2132045%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20Appointments%20in%20MS%20Bookings%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2132045%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20all%20works%20but%20it%20shows%20meetings%20that%20have%20been%20cancelled%20or%20changed%20how%20can%20these%20removed%3F%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Hello

 

Is there any way that I can export MS Booking customer appointments for a service to Excel or in another format?

 

Many thanks

 

Erika

4 Replies

I have the same question as well. That would be really helpful for a lot of businesses I would imagine. Additionally, the ability to import data (staff, customers, addresses etc) from Excel would be awesome. (But maybe that's already possible, I just learned about Bookings today). 

Best Response
Solution

A new feature has been introduced which should allow this but it's not currently working for me (or anyone else I have heard from). I have a ticket raised with Microsoft to resolve... see this thread:

 

https://techcommunity.microsoft.com/t5/Microsoft-Bookings/Export-more-data-as-TSV/m-p/253802#M608

 

 

As an alternative, you can get some Bookings data out using the process I describe on the following thread:

 

https://techcommunity.microsoft.com/t5/Microsoft-Bookings/Microsoft-Bookings-Reports/m-p/197177#M520

 

Thanks so much Geoff for the help and tips, much appreciated

Hi

This all works but it shows meetings that have been cancelled or changed how can these removed?