How to Export your OpenTable Guest List and import it into your Engage Subscriber DB

How to Export your OpenTable Guest List and import it into your Engage Subscriber DB

It's easy to export your Guest data (name, phone number, email address, etc.) from your OpenTable system. Follow these steps to get going!

  1. From your OpenTable desktop, select the "Reports" tab
  2. Click on "Marketing Options," and then, "Guest Export"
  3. Select the "Only export guests with E-Mail addresses" option from within the Export Options section to ensure you're only pulling names with email addresses attached
  4. Click "Export"
  5. Make note of the entire file location so that you can easily find it on your computer. The location will be quite long, and will begin with C:\
  6. The file you've exported will be in text format. You will need to convert it to a CSV File to upload it into your Spillover Marketing DB.   Follow these steps or email the file to Spillover Support who will convert it and upload it into your Spillover Subscriber DB
  1. Open Excel, and choose "Open" from the file menu
  2. Find the file that you saved
  3. Change the "All Excel Files" option to "All Files"
  4. Click "Open"

 


    • Related Articles

    • Viewing & Downloading all Subscribers

      1. Click on Segments->All in the Audience Section of the Engage Admin Navigation 2. Under Segment Manager, go to your "All Subscribers" list and select the option "Export List" to export a CSV file with First Name, Last Name, Email. You can also ...

    • Accessing your ENGAGE Management Dashboard

      1. Go to Spillover.com and click on the client login button on top right 2. Enter your email address and password. If you forget your password please click the password reset link. 3. Your ENGAGE Admin presents a snapshot of your online activity on a ...

    • Best Practices for managing subscribers to your Mailing list

      This guidance presents 5 ideas for how you can stay in touch with your Mailing List Subscribers using a combination of the Engage Email Marketing pre-built templates and Engage's DIME automated messages. 1. Thank You Email (Autoresponse on form ...

    • Accessing your ENGAGE Campaign Calendar

      The ENGAGE Campaign Calendar allows you to view your Monthly Marketing plan : current month as well as previous and future months. You can see all your scheduled email campaigns, Facebook, Instagram, X and Google posts and Website Calendar Events in ...

    • How to manually upload an external Email List

      1. To upload an email list click on the “Subscribers >Import” in navigation. 2. You can upload lists in CSV or .xls or .xlsx format. It is important that you "clean" your list before importing it. Delete columns that do not match up with subscriber ...