Exporting Data from MS Bookings

Exporting data from MS Bookings.

• Open Excel:
  1. Click the Data option from the ribbon tools.
     
      
• From the Data tab:
  2. Click Get Data
  3. Click From Online Service
  4. Click From Microsoft Exchange Online

5. Find the Mailbox address. From the MS Bookings URL take only the portion that looks like an email, that is the mailbox address.
   • e.g., https://outlook.office365.com/owa/calendar/CITTraining@myeasternct.onmicrosoft.com/bookings/texijqmVikmIBfw0La_Avg2
6. Click OK

7. Click on the Microsoft account option
   
    
8. On the Microsoft account window
9. Click Sign in
   
    
10. Click on your Eastern O365 account when prompted.
    • Sign in with your ECSU credentials and authenticate if requested.

​​​​​​​

11. Click Connect
    
     
12. Select People or other data you wish to export.
13. Click Transform Data