Body
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, you first need to export a tsv file from Bookings:
- 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.
![an arrow from the menu chevron to "Open"](https://td.cscc.edu/TDPortal/Images/Viewer?fileName=b7109fe6-1410-46bc-97ea-f08609a46f96.png)
- Click Export data in a TSV file.
!["Export data in a TSV file" highlighted below "Booking activites" heading](https://td.cscc.edu/TDPortal/Images/Viewer?fileName=3d45810e-64b7-4832-8335-e5efb2904cd3.png)
- Select your desired date range and click Export.
By default, the TSV file will save to the Downloads folder on your device.
![Window to export recent data with "Export" button highlighted at the bottom](https://td.cscc.edu/TDPortal/Images/Viewer?fileName=bb16b1ee-d2a7-48ed-a8e8-e70549beaf97.png)
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.
Mac
- To view the file, open Microsoft Excel.
- Click Open > On My Mac then select your Downloads folder, the Bookings file: BookingsReportingData.tsv, and click Open.
![path to Downloaded tsv file is highlighted, the tsv file is selected and the "Open" button is highlighted](https://td.cscc.edu/TDPortal/Images/Viewer?fileName=5165f41b-3acd-4fe6-92a4-831bb1eb2e55.png)
- If the Text Import Wizard appears, click Next> Next> Finish. Following these prompts will help Excel divide your data into columns.
![Import wizard open with "next" and "Finish" buttons highlighted at the bottom](https://td.cscc.edu/TDPortal/Images/Viewer?fileName=23af059b-d93c-495a-b728-23593532da4b.png)
- 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.