Creating a Live Worksheet

A Scoop Live Worksheet is basically a cloud spreadsheet (Google Sheet), that is linked to your Scoop account. Linking to your Scoop account allows you to do two several powerful things:

• Utilize the Scoop plugin (Scoop for Sheets) in your spreadsheet to bring data in from Scoop datasets and automatically update it
• Bring named ranges into Scoop Explorer to dynamically visualize, slice and dice data in your spreadsheet tables
• Bring named ranges into Scoop Canvases to enable users to directly modify cells in that spreadsheet

To create a new Live Worksheet, move to the Live Worksheets page by clicking on the last icon in the icon bar, and then click on New Live Worksheet.

You can either upload an existing .xlsx workbook into Scoop or have Scoop create a new one. Note that if you upload your own sheet, Scoop will save it in the cloud and allow you to make changes to that version.

The Scoop for Sheets plugin will only work with Live Worksheets. If you attempt to use the plugin with a sheet that is not a Live Worksheet, it will register and error.