Add Table to Google Sites
Learn how to effectively add a table from Google Sheets to your Google Site by embedding it with an iframe, ensuring accessibility while maintaining data protection.
Let's add a table to a Google site. So we have a Google sheet here. We have a couple of tabs, and we just want to add one tab to this site. So normally you might go to insert and go to sheets, select the sheet you want and insert. But there's going to be a problem with this. People can't access the file. We are gonna need to do something else. So I'm actually going to delete this and go to our sheet and go to file share publish to web . And here I can actually select to only one tab. I want the embed one tab publish . Are you sure you wanna publish this? And I am gonna get an eye frame here. So I'm gonna take this iframe , copy it, and I'm going to insert and embed
by embed code paste that there insert. We might need to not restrict. Publish it. Let's get the I frame again. And there we can see everything, but this might be very small, so let's edit the I frame. So we're going to add here where it says headers equal false. Right next to the last quote, we're gonna add a space and do style equals, and in quotes, we're going to write Width colon 100%. Height and let's say 800 pixels. Let's click next save, and it's much bigger. We can drag this out. We can click publish . Let's get that link. And see if it works on an incognito window.
Yes. So I'm not logged in. This is a public site. I have a nice table from a Google sheet embedded here, and if I want to go to the sheet, I'd have to sign in, right? So this sheet is protected. It doesn't need to have any more protection . It's a restricted sheet. Just publishing this one particular tab and. We can put it as any size we want. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna
be your next Google sheet.