Embed editable Google Docs spreadsheet without header & toolbar

embed editable google sheet
embed google sheet without header
publish interactive google sheet
embed google spreadsheet without publishing
adjust size of embedded google sheet
embed google sheet in canvas
google docs embed url
embed in google docs

I have the requirement to embed a Google Docs spreadsheet on a webpage, but it needs to be just the editable cells, without the Google navigation and toolbar at the top.

I can't find a reference to the querystring variables for embedding Google docs anywhere but it seems that the only thing which removes the toolbar etc is by adding 'output=html' to the querystring. However, this is what seems to be converting it from an editable spreadsheet to a non-editable spreadsheet too, which is the problem.

Can anyone suggest how to manipulate the URL below to produce an editable document with only the cells visible (no toolbar)?

https://docs.google.com/spreadsheet/ccc?key=0AngcQK0IFROwdHZySkUwd0JtY0N6Zk5RaTAyZDFVekE&widget=true

Note, this URL doesn't work - it's just an example.

Thanks!

Try adding rm=minimal as in: https://docs.google.com/spreadsheet/ccc?key=0AngcQK0IFROwdHZySkUwd0JtY0N6Zk5RaTAyZDFVekE&rm=minimal

Embed only cells from Google Spreadsheet and not application , I have the requirement to embed a Google Docs spreadsheet on a webpage, but it needs to be just the editable cells, without the Google navigation and toolbar  A short guide on how to embed a Google Sheet to a website, and users to edit it if they go onto that page. How To: Embed an editable Google Docs Sheet - Google Apps - Spiceworks Home

The answer provided by Henrique requires a slight adjustment to work with the new Sheets.

Add ?rm=minimal to the end of your document's URL, i.e.

https://docs.google.com/spreadsheets/d/1zHZdAImcjI4gAy5ATBA0rSImYUowL4HC8h-vvYOdpfA/edit?rm=minimal

Embedding Google Spreadsheets with more control over appearance, I want to embed cells only, and not the Google Docs application header. How can I get such result? I tried to add &widget=false to the URL but  How to embed specific cells range when embedding a Google spreadsheet 36 Comments / How To Guides , writing / By tumo If you find this post helpful, please consider a donation to help me continue creating free how-to guides for everyone.

Try these:-

single – setting to true displays just one sheet in the spreadsheet. The default sheet it will display is the first one created in the spreadsheet. This can be changed using ‘gid’ below.

gid – this needs to be a numeric identifier of the sheet you want to display. The first sheet created is 0, but others will have longer identifiers. To find the ‘gid’ for the sheet you want to display, go to the spreadsheet in Google Apps itself, and click on to your desired sheet. The URL in your browser should change to something like this: https://docs.google.com/a/mycompany.com/spreadsheets/d /15B___SOYjsRmU9tiwZly318HZnFHOHeayS6UTHx7Pu2I/edit#gid=419657423

The bit at the end of the URL shows you the ‘gid’ for the sheet, and that is the number you need to bring into the shortcode in your website.

range – set this to the cell range you want to display within the sheet (or leave it out to display the whole sheet). In our example, we set this to f2:g6. Note if you’re being pedantic then you should really change the ‘:’ to ‘%3A’ since colons should be encoded in URLs – but most browsers should understand the colon, so don’t worry. If you like to be correct, you’d use range=f2%3Ag6 instead.

headers=false - Row numbers and column letters are not displayed.

widget – setting this to false removes the sheet selector bar when it’s embedded.

chrome – setting this to false removes the title bar showing the spreadsheet name, above the sheet.

So putting all together:-

iframe src="https://docs.google.com/spreadsheets/d/[Googlekey]/pubhtml?gid=28&range=a1:s45&single=true&widget=true&headers=false"

Allan

Clean Embedding of Google Sheets, A great feature of Google Apps is the ability to embed live spreadsheets in your Here, I'm using our Google Drive Embedder plugin for WordPress – but the Each parameter/value pair is separated by a '&', like this (but without spaces): /​15B___SOYjsRmU9tiwZly318HZnFHOHeayS6UTHx7Pu2I/edit#gid=419657423. A Google account is not necessary to view the original Google Doc. Any user on the web can access the original Google spreadsheet in view-only mode. They won't be allowed to alter the original table in any way, but they will have access to a spreadsheet downloadable in different formats (e.g. .pdf, .csv, .txt). To download, simply click File

This works:

https://docs.google.com/spreadsheets/d/1MEdbr8WA.../edit?rm=minimal#gid=0

Don't forget to include the /edit? part before rm=minimal.

(The sheet has to be shared as Access:Anyone (no sign-in required) with Can edit option selected → Public on the web - Anyone on the Internet can find and edit)

How can I fix the embedded sheet in new site from , I am looking to embed a limited access Google Sheet (I don't want to publish and would like the tradition Google header information (menu, graphics, etc) I'​m no computer security expert and certainly not a Google expert,  Access Google Sheets with a free Google account (for personal use) or G Suite account (for business use).

Well, as of Sept 2018 and on a privately shared (lengthy URL, but no password, easily testable in a private browser window), you have at least these 2 options:

    https://docs.google.com/spreadsheets/d/[hash]/edit#gid=0

Which gets you all the header crud. Even on a read-only share. (you can leave out the /edit#gid=0 part, but it will be added again)

    https://docs.google.com/spreadsheets/d/[hash]/htmlview

Which leaves out all of the header crud:

How do you embed a Google sheet but keep the top two rows frozen , /pubhtml?widget=true&headers=false"></iframe>. Details You can embed a spreadsheet so that no pop-out icon shows. <iframe height="500" src="​https://docs.google.com/spreadsheets/d/ID##########/edit?usp= width="75%​"></iframe> With this method viewers can edit it directly on the page. Google Sheets makes your data pop with colorful charts and graphs. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks. All for free

Google Docs – Support, You must insert the spreadsheet using the embed code function: <iframe height="​500" src="https://docs.google.com/spreadsheets/d/SPREADSHEET ID/edit?usp=​sharing&embedded=true&rm=demo" That will freeze the rows in the spreadsheet itself, but has no effect on the embedded spreadsheet. Create and edit web-based documents, spreadsheets, and presentations. Store documents online and access them from any computer.

Embedding and Linking to a Google Doc and Sheet in Blackboard, How do I change the size of an embedded Google Doc? Add dates, titles, or names to every page in a document using headers and footers. You can do this with Google Docs, but not Google Sheets or Slides. On your computer, open a document in Google Docs. In the top left, click Insert Header & page number. Choose Header or Footer. Enter text for the header or footer. Click a header or footer.

How To: Embed an editable Google Docs Sheet, will now appear in your course as a full-sized document. To add a header, you can freeze rows, using the menu: View > freeze rows. For printing, go to File > Print. Make sure to select 'repeat row headers ' and any other options you may like such as 'include page numbers'. This will print the frozen rows at the top of each page.

Comments
  • Looks like it stopped working recently, works for spreadsheets, but not for docs (shows 'File unavailable' popup, removing rm=minimal fixes it) :/ i.imgur.com/RiCDlom.png
  • @pambuk Looks that now is fixed. I just tried both, docs and spreadsheets, embedded in google sites pages through the "Include gadget (iframe)".
  • it works here on august 13th of 2018
  • Worked for me just now. I think the people it didn't work for may not know what query parameters are and were interpreting this answer very literally instead of using ? instead of & when appropriate. See stackoverflow.com/a/32747537/470749
  • Note that these query strings are only supported for the "Published" sheets, not the editable links discussed in other answers.