top of page
Work Desk

How to Embed Editable Google Sheets in Website

Have you ever wanted to share an editable Google sheet on your website so that you can easily collaborate with other people? Maybe you want to share your historical stock price calculator or another editable sheet that can be cleared and reused multiple times?

This is great for people who want to easy find the spreadsheet they need to collaborate on without losing them in their files on Google Drive.

Knowing how to embed editable Google Sheets in website is great for people who have a password-protected area of their site where only certain users can access the pages. An example of this might be an Employee only area, members-only area, and so forth.

Before we get started on the how-to instructions, lets take a look of an example.

Step 1: Publish to the web

First we need to make the spreadsheet eligible to publish on a website. For this you will click File and then click on Publish to the web near the bottom.

The pop-up box that pulls up, you’ll first want to click on Embed. Then you can decide if you want to publish all tabs from the Entire Document or only on of the tabs from the spreadsheet.

Next, you’ll click the green Publish button. Once you do that, your browser will pop up a box that says “Are you sure you want to publish this selection?” Click the blue Ok button to continue.

Now you’ll have the html code that you need to put on your website!

Step 2: Make the sheet editable

Now that you’ve published the spreadsheet to the web, you can embed it on your website but it won’t be editable. Here is what you need to do to make your spreadsheet editable and embed it on your live website.

The first thing you need to do is click the green Share button in the upper right. From here you will click on Change to anyone with the link at the bottom of the pop up screen.

Next, you need to change the dropdown that defaults to Viewer and make it Editor. This allows anyone to edit the spreadsheet from your website page.

Once you’ve changed it to Editor, you can click Copy link to get the link we need to paste in the code above.

Step 3: Edit the Publish to the Web Embed Code

Here is the code that we got from going through Step 1 above. Replace the RED section below with the URL that we copied in Step 2.

<iframe src=";headers=false"></iframe> 

Your code should now look like this:

<iframe src=";headers=false"></iframe> 

Now that we’ve changed the link, you’re going to see something that looks like this:

Not too appealing right? So let’s make some more adjustments to the code so that it looks cleaner and more professional.

Here is a list of changes you can make and what each change accomplishes.

Before adding any of these customizations, make sure you add &amp; to the end of sharing? in the URL.

  1. Center the spreadsheet on the page. Add <center> to the beginning of your code and </center> to the end of your code.

  2. Change height and width. After the <iframe you can add width=”500″ height=”500″. You can set your own width and height (or use percentages instead).

  3. Hide the editing toolbar. If you want to hide the sheet title and editing toolbar at the top, add rm=minimal&amp; to the end of he URL string.

  4. Show only the first tab in the spreadsheet. If you shared the whole document but decide that you only want to display the first tab, add single=true&amp; to the end of the URL string.

<center><iframe width="500" height="500" src=";rm=minimal&amp;single=true&amp;"></iframe></center> 

Now You’re Ready to Embed Editable Google Sheet on Your Website

Let me know if you have any questions or any other tips or tricks that you have found for embedding editable Google Sheets on your website!

Feel free to leave a comment below!

Want to learn more helpful tips and ideas? Check out these helpful articles:


13 comentários

Impact Labs
Impact Labs
14 de ago. de 2023

Step 1: Publish to Web: New Menu Location:


Impact Labs
Impact Labs
11 de ago. de 2023

Can we assume after publishing this post, you you turned-off edit privileges for this sheet? Back to Viewer instead of Editor, which allows anyone to edit the spreadsheet from your website page?


This is great, thank you so much. The only issue I am having is that on mobile I can't edit the content. Any work around for this? Thank you


Giuliana Rojas
Giuliana Rojas
06 de abr. de 2023

How can I hide the numbered rows and lettered columns that show that this is clearly an excel?


bas van Tartwijk
bas van Tartwijk
07 de jan. de 2023

Worked perfect exept for one thing. Once i hid the editing toolbar my macro's dont work annymore bacuse of the part after =sharing?widget=true&amp.

Any ideas?

Hire a Pinterest Virtual Assistant sidebar ad.png



Business Tips Directly to Your Inbox

Thanks for subscribing!

Don't Spend Hundreds of Dollars on Logos! Learn how to create your own. 

I'll show you how!

canva logo design book mockup.png
bottom of page