Download Google Sheets
Learn how to easily download Google Sheets in various formats, including PDF and CSV, and discover some hidden tricks to share and copy sheets effortlessly.
So you want to download a Google sheet. Super easy. Go to file, download, and we have a bunch of options when we do comma separated values . By the way, it's only going to download the very first tab if we download as A PDF . That's the same as printing. So if you're trying to print a Google sheet, just save as a PDF and you're gonna get a bunch of options. You can even save as a Microsoft Excel document.
Now, let me show you the coolest trick I think Google Sheets has, and it's so cool that they don't even tell you. You can go up to the URL of your Google sheet and at the very end there's this slash edit . You can delete all of this right after the ID of your sheet add a slash and put copy, and if we hit enter, we'll see that this gives us a dialogue that doesn't access the sheet. It just allows us to make a copy and if we've allowed someone to view the. Sheet itself, they can make a copy too. And instead of sending this Google sheet and saying, Hey, you make a copy, we can send this URL with slash copy up here and it will automatically show them this. We can show them the sheet if you want, slash template slash preview. And it opens like this where they get to see the sheet. And then they get to click use template to make a copy in their own Google Drive. But if you want them to just download it, you can do export . Question mark, format equals, and now put CSV or PDF . Let's do PDF . If we hit enter without accessing the sheet at all, I've downloaded it. Now how do I remember all of this?
Well, I don't, I don't have to remember all of these. I can go into my URL, go to docs.google.com instead of Docs dot, I can change this to the word dot, dot, hit enter, and it's going to redirect me to better sheets.co/download. Where I have every single magic URL possible ready to copy with your Google Sheet link already in there, so you can export as A-C-S-V-P-D-F-T-S-V. You can copy the sheet preview mode. You can even give someone minimal editor like distraction free editing mode , or even embed it in an I frame. I hope that this gives you a really awesome assortment of tools at your disposal that Google Sheets barely ever tells you. Just check out Better sheets.co/download if you ever wanna remember these.
Or just go to your URL, change that.to.dot, and you can come right here. 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.