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

    • How to Export your Toast 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 Toast system. Follow these steps to get going! 1. From your Toast desktop, select the "Marketing" tab 2. Click on "Guestbook" and then, "Guest Export" 3. Select ...

    • 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 ...

    • Logging in to ENGAGE

      If you are accessing your account for the first time you need to first verify your account : Accessing your ENGAGE Account for the first time 1. Go to Spillover.com and click on the client login button on top right 2. Enter your email address and ...

    • 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 all ENGAGE Tools

      All ENGAGE Tools can be accessed via the collapsible left Navigation Bar of your Engage Account. You can also access your Monthly Consolidated Reports here (located beneath the Home link). Tools are organized into the following categories : 1. Online ...