View a Bookings report in Excel

How to access your Bookings report

You can now see a report with up to four months of your bookings in a TSV file. You can run the report multiple times to see different time periods within the last year.

This appointment level information can be used to visualize the customer activity around your Bookings calendar. TSV files are tab separated value files. You can view or edit a file like this with any text editor or spreadsheet program, such as Excel.

 

Export TSV file from Bookings

To get the report information out of Bookings:

  1. Go to bookings.office.com. Log in to the web app using your Columbus State email address and password and open the appropriate calendar if needed.


     
  2. Click Export data in a TSV file.


     
  3. Select your desired date range and click Export.
    By default, the TSV file will save to the Downloads folder on your device.

 

Import TSV file into Excel

Read the instructions for your computer's operating system below to learn how to import the TSV file you exported above into Excel. 

  1. To view the file, open Microsoft Excel.
     
  2. Click Open > Browse and select your Downloads folder.


     
  3. In the drop-down, for file type, select All Files.  Select your Bookings file: BookingsReportingData.tsv and then Open.

  4. If the Text Import Wizard appears, click Next> Next> Finish. Following these prompts will help Excel divide your data into columns.


     
  5. Your file will then open up in Excel. Before editing, save the file in the location of your choice with a new name and specify an .xls or .xlsx file type (Excel workbook) so it opens normally next time.

  1. To view the file, open Microsoft Excel.
     
  2. Click Open > On My Mac then select your Downloads folder, the Bookings file: BookingsReportingData.tsv, and click Open.


     
  3. ​​​​​​​If the Text Import Wizard appears, click Next> Next> Finish. Following these prompts will help Excel divide your data into columns.


     
  4. Your file will then open up in Excel. Before editing, save the file in the location of your choice with a new name and specify an .xls or .xlsx file type (Excel workbook) so it opens normally next time.
Was this helpful?
0 reviews

Details

Article ID: 555
Created
Wed 5/12/21 1:37 PM