Spreadsheet.com makes it easy to share workbooks with other workbook collaborators. Use Spreadsheet.com's built-in sharing feature, send permissioned users a link, or share your workbook publicly as a view-only workbook, or embed your workbook in another website or app.
Embed your workbook publicly is a great way to keep your audience apprised of important data, dates, or project milestones contained in your worksheets. Embedding Spreadsheet.com workbooks expands the capabilities of any website you administer and allows you to share the latest information with your audience. For instance, embed a Gantt chart of your application's updated release calendar on your application's blog, embed a workbook with your sales team's biographical and contact information on your About us page, or provide important public-facing financial documents in a spreadsheet on your investor pages.
To embed a workbook publicly
The public sharing and embedding settings dialog can be opened from the share dialog below Invite by email and Get link, or from the File menu in the top menu bar of your workbook.
Note: Only workbook owners can access the public sharing and embedding settings.
The public workbook sharing and embedding dialog will open, allowing you to enable sharing and embedding, adjust what is shared, get embedding code, and preview the way the shared workbook will look. Let's take a closer look at the dialog:
Before editing the workbook’s sharing settings, make sure that (1) Enable public sharing and embedding is selected in the top left corner 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.
The (4) Settings dialog 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.
Finally, the (5) Preview window lets you see what the public will see when they visit your workbook. 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.
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.
Embedding Workbook Templates
Creating workbook templates is a great way to standardize and automate work across teams. Your collaborators can create new workbooks off your custom template, matching the formatting, data types, and formulas you created. You can share workbook templates via Spreadsheet.com's built-in share feature, or embed your template so that anyone from the public can copy your template and use it for their own workbooks.
To allow users to copy your workbook, enable Allow users to copy your workbook in (4) Settings dialog.
Form views have a slightly different means of being shared or embedded, see our article on embedding form views. Or note other ways to share, like sharing using Spreadsheet.com's built-in sharing feature, share an editable workbook link with permissioned users, or publicly share a workbook with a link.