WiscWeb - Embed a Google Sheet

The following document will walk a user through how to embed a Google Sheet within a WiscWeb webpage.

Before you begin

Use a Shared Drive for setup

We recommend that you set up your Google Sheet within a Shared Drive. Shared Drives accommodate many editors. Also, if the original owner leaves the University, someone can still have access.

Technical support and resources

Google Sheets is covered by the UW-Madison Google Workspace team’s rules and terms of service: UW-Madison Google Workspace - Terms of Service/Use and Privacy Policy.

For help and support using these tools, we recommend the following official Google support documentation:

Step 1: Publish to web

Before you embed your Google Sheet link, you will need to make sure it is set up to publish to the web. 

  1. Open the file in Google Sheet

  2. At the top, click File > Share > Publish to web

    Display of 'publish to web' setting in Google Doc

  3. In the window that appears, keep the Link tab selected 

  4. Choose if you want the entire document shared or just a single web page. Select the Publish button

    Text showing the option to publish an entire Google Sheet or just a web page

  5. After selecting Publish, you should see a new pop-up window with a URL of your doc. Copy that URL and save it for the next step. 

    Text showing URL of published Google Sheet

Step 2: Paste Google Sheets URL into text block

  1. With the Google Sheets URL copied, log in to your WiscWeb site and access the page or post that you want to paste this into

  2. In a Text Area, paste the code that you have copied into the Visual Editor. Your Google Sheet should display within a few seconds

    Text Block showing Google Sheet in the box

Keywordsgoogle, sheet, spreadsheet, embed, show   Doc ID120063
OwnerJenna K.GroupWiscWeb
Created2022-07-29 15:17:15Updated2024-06-03 11:14:31
Feedback  0   0