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.

Email it over to 
Please allow up to 5 working days for these to be uploaded.

Welcome to ResDiary!