• Before you begin
• Step 1: Publish to web
• Step 2: Paste in the Google Sheets URL

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 - Core Apps.

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

• Google Sheet how to’s 

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
   
   
   
   
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
   
   
   
   
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. 
   
   

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