Google Sheets Easter Eggs

0:00 You might know already about the pride easter egg if you type in pride across the top five cells it'll change colors p r i d e it'll change colors you may know that i'm going to show you actually more easter eggs in google sheets that are actually much more useful before we get to that though you can type in pride in spanish or in portuguese and get the exact same thing so or gulo or cool It will work, Spanish and Portuguese. But let me show you actually useful Google Sheet and Google Drive Easter eggs. So if you go to any URL bar and you just type in sheet. new, if you just type in sheet. new, It it will create a new spreadsheet in whatever Chrome domain or workspace you're in Chrome. If you have multiple workspaces signed in what you can do is sheet.

0:47 new slash two will get you the second one, and that will create it in the second one here. I have actually three. Sheet. new slash three I can use, and it will create a new Google Sheet. In the Google Drive. That's the third account there. So sheet new slash two slash three, however many accounts you have signed in will work here. And that creates a brand new Google sheet. It is in your Google drive already. Really cool. Now, three more. Once you have a Google sheet and you want to copy it, even if you have someone else's Google sheet, URL, and you wanna copy that. Of course, you can go to file, make a copy, but you don't even have to access the file itself. You can take the entire URL and add slash copy at the end. What this will do is it'll bring up this dot this thing that you can say, make a copy. And when you click, make a copy, it'll make a copy in your Google drive.

1:33 Now, That's really cool, right? But you might not know that you have to get rid of all this edit stuff. So what I did is if you go to better sheets. co slash copy just knowing slash copy, you can take a entire Google sheet URL, put it into the here and add copy, and it will copy to your Google, to your clipboard, the exact. URL you need to make a copy. This is great for sharing a sheet that, the people who are going to use your sheet are going to make a copy immediately. It saves them from having to open the sheet, go to file, make a copy. It saves that much time. Great for bosses. Save your boss time or save people who are constantly making copies. You can even put this URL inside of your sheet. You can do command K and say, copy this sheet and put the link there, apply.

2:22 And now this link here will copy this sheet. So that's really cool. If you're trying to distribute a sheet and people are going to use it as a template or something, use this slash copy in really cool ways. And it's slightly undocumented. So I think it is a really cool Easter egg. I think it's one of the coolest ones. Now, another Easter egg you may not know of is you could go to file and download Google sheets as PDFs as CSE files, but you can also do that through the URL itself. This is a little complicated because there are some there are some slight variations here. So what I did is I created another tool for you, totally free at bettersheets. co slash CSV , take the whole URL, put it here. And what it does is it adds this export question mark format equals CSV . So that's a little bit more complicated, but you don't have to remember that.

3:10 You just have to remember bettersheets. co slash CSV and put in any spreadsheet URL here and you're going to get it copied to your clipboard. Now, if I create a new URL. If I put, paste this URL here, what happens is actually does not open the sheet at all. It automatically downloads as a CSV . So again, you can go to your sheet, add a link that says download as . CSV . And paste this link with export ? format csv so that someone can, from your sheet that you give them, download it immediately. Again, they can go to file, download, CSV, totally fine. But if you want to make a quick reference to this, or you want to send this in an email, you're like, hey, I want to attach a CSV file, but I don't want to download it, and I don't want to make the other person download it

3:56 by going to file, download as CSV . You can make this super easy. It's a little quick. Quick hack, you could say for sharing Google Sheets as CSV files, especially if you don't want to attach it as a CSV in an email, you just want to send a link. So that's really cool. Now, the next one is a little bit more complicated, but it is incredibly useful. You can file, download as a PDF , and when you do this, you get a lot of options. All of these options are available to do in a URL. So let me show you that I'm going to take this URL again. I'm going to go to better sheets. co slash PDF here. I have given you all of the options that you need. Paste the URL here. I want it in actually landscape. I do want to show the grid lines or I don't want to show the grid lines. If you want to check that off. I do want to show page numbers, repeat header, row headers.

4:43 Not this case. You can select your sheet size. Let's get a big one tabloid. I want the title. I want to fit in window. Sure. And I want to show the sheet names. You can select all these, get the URL. It's going to add all of those parameters to that URL. So now if I just go to that URL, it'll download a PDF exactly as I wanted. So that PDF will show up here. It has all of the things that I've asked for. It's in landscape mode. It has a sheet name , tab name, all that stuff. This is really cool. This slash PDF where is it? Here it is. Slash PDF better sheets. I co slash PDF is really cool because many times we're creating maybe invoices or again, templates that need to be printed out quickly. Maybe there's an event we organized or a seating charts and we need to download that as a PDF.

5:29 Sometimes we don't want to download it as a PDF and attach it to an email. We want to send it to someone, they download it immediately as a PDF . Our Google drive folder doesn't get big with a bunch of PDF files. We don't have our Gmail getting too outrageous Gigabytes of data in there. We can make it super easy to, for someone to download this. And again, they don't have to go to file, download as a PDF and select all of those options. You can embed those options in the URL itself. So I hope this is super useful for you. And I hope this is really fun to find out these Google sheets, Easter eggs. You can copy sheet , you can use pride, you can use Gulo or Gulo in Portuguese. Also we can see here. It works. And sheet. new and sheet. new with a number if you have a number of different Google drives on your

6:16 fold on your Chrome, slash copy, slash PDF to download a PDF , slash CSV . And I shared with you these bettersheets. co slash CSV , bettersheets. co slash copy, and bettersheets. co slash PDF to make it super easy for you to create these really cool URL hacks.