Search code examples
htmlgoogle-sheetsembed

Embed editable Google Sheets without Cell Coordinates


I wish to embed a spreadsheet made on Google Sheets such that it is editable and as "clean" as possible, for this I want to find a way to embed an editable sheet which also doesn't show the Cell numbers or letters (on the side and above).

I have arrived at two different outputs which approximate what I want. By using the link to share with others as such:

<center><iframe width="1000" height="700"  src="[GOOGLE SPREADSHEETS LINK TO SHARE WITH OTHERS]?single=false&widget=false&headers=false&rm=minimal"></iframe></center>

Leads to the following output which is editable enter image description here

By using the link given when you select "publish to the web" as such:

<center><iframe width="1000" height="500"<iframe src="[GOOGLE SPREADHSHEETS LINK TO PUBLISH TO THE WEB]pubhtml?widget=true&amp;headers=false"></iframe></center>

Leads to the following which does not have the cell coordinates but is not editable: enter image description here

Note that: Both HTML codes have the parameter &headers=false which is used for getting rid of the coordinates (it works in the second but not the first)

Is there a way to "combine" both outputs and get an embedding such as the one I am looking for?


Solution

  • Found this similar question and it looks like these parameters are only supported for the “Published” sheets and not the editable link.

    You can request this feature to be available through Google Sheets by going to a Google Sheet file, click on ‘Help’ > ‘Help Sheets improve’ and give a description of your request.