Public sharing and embedding

  • Updated

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. 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 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. makes it easy to share your workbook through either method, as well as control the parts of your workbook that are made public.

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.


Let's take a closer look at the public workbook sharing and embedding 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.

You can also share workbooks using's built in sharing feature, share an editable workbook link with permissioned users, or embed workbooks into a website of your own.