Then, paste in the other URL before the ampersand. Basically, delete everything in the quotation marks after src= starting with but leave &widget=true. Now what needs to happen is most of the URL in the iframe embed code needs to be deleted, and replaced with the link you’ve just copied from the Sharing settings popup. Copy the Link to share and close the popup

The Sharing settings popup will appear.

At the bottom of the Who has access popup, change the Can view drop-down to Can edit and click Save.

Under Who has access, click the Change link and select On: Anyone with link.

In the Share with others popup, click Advanced.

Go back to the spreadsheet in Google Sheets, and press the Share button.

Follow these steps to enable live editing of the spreadsheet on the page: At this point if you publish the page, the sheet will be viewable but not editable. Copy the embed code, which will look something like this:Īfter copying the text ( Edit>Copy) and pressing the Close button, paste the embed code into a text editor or the blog editor (make sure the raw code or HTML view is showing).Under Get a link to the published data, change Web page to HTML to embed in a page.In the Publish to the Web popup, press the Start publishing button.Open the spreadsheet, and select _File>Publish to the Web.Notice you can highlight cells, but can’t input or change information, or use any other features of Sheets:īut there’s a workaround. For example, here is an embedded spreadsheet. That is, when you embed the spreadsheet on a blog post or Web page, you won’t be able to edit or format the cells, or create formulas. While Google Sheet’s Share button makes it easy to share a link to a spreadsheet, and allows the owner of the spreadsheet to enable anyone to edit it, editing is not possible if the embed option is chosen for the File>Publish to the Web feature. It involves a small hack, which I will describe below. This post explains how to embed a live spreadsheet using Google Sheets, the free online spreadsheet program offered by Google.

xlsx file, I also embedded a live version of the same spreadsheet that people can edit and play with, right on the blog post. Recently, I published Sample spreadsheet: AutoFill on the official Excel Basics In 30 Minutes website.

How to make google drive url