Public sharing and embedding allows you to easily share read-only copies of your workbooks with the public.
Sharing a workbook publicly is a great way to share a workbook’s data and information directly without having to format it into something else. Spreadsheet.com enables you to share workbooks publicly in two ways: public link sharing and embedding.
Public link sharing and embedding both allow you to publicly share your workbook, but work in different ways:
- Public link sharing allows viewers to visit a read-only copy of your workbook within Spreadsheet.com. For example, you may want to include a link to a workbook with a calendar of upcoming events in a newsletter to your organization’s subscribers.
- Embedding allows viewers to see and interact with a read-only copy of your workbook without leaving the place where it is embedded. For example, you may want to embed a workbook showing a roadmap of upcoming features in a blog post about what users can expect from your product in the future.
Spreadsheet.com makes it easy to share your workbook through either method, as well as control the parts of your workbook that are made public.
This article features Spreadsheet.com's Employee Directory template. Explore the Template Gallery to find ready-to-use templates in over 20 different categories, or learn more about starting a new workbook from a Spreadsheet.com template.
Accessing Public Sharing and Embedding
You can access public sharing and embedding settings from the bottom portion of the Share workbook dialog. You can access the Share workbook dialog from your Spreadsheet.com homepage by right clicking on the workbook name – or clicking the downward arrow to the right of the workbook name – and selecting "Share..." from the dropdown.
Or, you can access the Share workbook dialog from inside your workbook via the File menu or the Share button in the top right corner.
With the Share workbook dialog open, you can access Public sharing and embedding options by clicking on the bottom section of the dialog.
This will open the Public workbook sharing and embedding dialog, which we'll explore below.
Configuring Public Sharing and Embedding Options
The Public workbook sharing and embedding dialog allows you to configure the appearance of your workbook when shared with the public or embedded in a website. Let's take a closer look at the options.
To begin, make sure that Enable public sharing and embedding is toggled on in the blue box in the top left corner of the dialog.
It’s important to keep in mind that while publicly shared workbooks are read-only, they are visible to anyone with the public share link. Before publicly sharing a workbook, make sure that there is no confidential or sensitive information within it, and always double check the settings in the public sharing and embedding dialog.
The (1) Settings options allows you to control the ways in which the public can view and interact with your workbook. “View toolbar settings” allows you to choose whether or not viewers can enable filters, sorting, and column visibility. “Worksheet visibility” allows you to choose which worksheets viewers can see within the shared workbook. And “Workbook settings” allows you to choose whether or not viewers can copy the shared workbook.
As you change these settings, the (4) Preview window, which lets you see what the public will see when they visit your workbook, will dynamically update to reflect the settings. As you edit the sharing and embedding settings, this view will update to reflect your selections. To see a larger version of the preview window in a full browser window, click “Full page view” in the top right hand corner.
At the top of the dialog, the (2) Public share link can be sent to people you want to share your workbook with. They can use this link to access a read-only version of your workbook so they can view – but not edit – the data. The (3) Embed code allows you to embed a read-only version of your workbook in a site or app that supports the iframe format.
You can also share workbooks using Spreadsheet.com's built in sharing feature or by sharing an editable workbook link with permissioned users. Or, read on to learn more about collaborating in workbooks with features like Channels and Messages.