Follow the steps below to export all your future bookings from the Open Table system
First, visit the Reports section of your OpenTable dashboard.
Click on reports - Reservations & Cancellations
Select Today's date as your 'Start Date' and choose the date of your last reservation
Select Report Type : 'Reservations'
Select in Choose Shift : “All”
Open the ‘Output Options’ tab
Choose to sort by ‘Reservation Time’ and then by ‘Guest Last Name’.
Select all the options in the right hand side for ‘Guest Phone Numbers’, ‘Guest Notes’, ‘Guest Codes’ and ‘Company Name.’
Click on reports -> 'Reservations & Cancellations'
Then click on 'Generate Report'
Click on “Export”
In the new window select “Excel (XLS)” then click on “OK”
Save the file to your Desktop
Please refer to the sample file attached and make sure that all details fall into the correct fields.