Members-only tutorial

Watch the video and get the practice sheet with membership.

See membership options

Export Your Google Sheets to PDF with a URL

About this Tutorial

I want to show you a fantastic new tool that I created called bettersheets.co/pdf

It allows you to easily generate a URL to download your Google Sheet as a PDF. 

I'll walk you through the process step by step, showing you all the options you can choose from, such as portrait or landscape orientation, grid lines, sheet size, and more. 

It's super convenient and completely free for everyone. So, let's dive in and explore this awesome tool together!

Video Transcript

<div>0:01 Welcome BetterSheets members and non-members alike. This video is to show you a brand new free tool like created bettersheets.co slash PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab .<br>0:10 What this does is it easily makes a URL for you to download your Google Sheet as a PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab . I will show you.<br>0:17 So AtomicSheets.com is a Google Sheet. It is a freely open available Google Sheet and this is what you get. You get 30 UI templates, elements that you can add to your Google Sheet immediately.<br>0:30 And there's also a pro version with 100.

It is a, it's an open and free Google Sheet with a URL.<br>0:37 Your URLs, you can actually do this for yourself even if you don't share Discover how to share your Google Sheets PDFs with others effortlessly. Opens in new tab your link with anyone with the link Find out how to allow anyone with the link to access your Google Sheets. Opens in new tab if it's just restricted Understand how to manage access for restricted Google Sheets. Opens in new tab but you have access to it, you can still do this.<br>0:47 But you can take any URL, look at this. So I'm just copying this exact URL up here of this Google Sheet.<br>0:52 I'm going here to bettersheets.co. pdf Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab and what I want to do is I want to get a PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab of this.

Now what we normally would do, right, is go up to file, download, as PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab .<br>1:05 There and we'd have all these options over here on the right and you have to like select Get insights on using the query select clause in Google Sheets. Opens in new tab them. But I've already made these easy for you to select Get insights on using the query select clause in Google Sheets. Opens in new tab these options and it will configure the URL for you.<br>1:15 So you can select Get insights on using the query select clause in Google Sheets. Opens in new tab either a portrait or landscape. In my case, I'm going to choose landscape. You can show grid Learn about grid lines and how they affect your PDF exports. Opens in new tab lines or not show grid Learn about grid lines and how they affect your PDF exports. Opens in new tab lines if you don't.<br>1:21 You can even select Get insights on using the query select clause in Google Sheets. Opens in new tab your sheet size, anything from letter, Dabloid, A4, B4.

I'm going to keep that at letter and show you the differences.<br>1:30 I'm going to not show the grid Learn about grid lines and how they affect your PDF exports. Opens in new tab lines and I'm not going to print Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab the title in the PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab . But if I wanted to print Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab the title in the PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab , I could click this.<br>1:37 I will also will click fit in window. Actually, I'll first do it actual size which is not fit in window.<br>1:46 I will not show page numbers Find out how to include or exclude page numbers in your PDF exports. Opens in new tab . I will not repeat row headers Understand the importance of headers in your Google Sheets and PDFs. Opens in new tab and not show sheet Learn how to show or hide sheet names in your exported PDFs. Opens in new tab names. And I'll show you this version and then we'll do another one.<br>1:53 So all I have to do is click get URL.

Immediately it copies this URL to my clipboard or I can just click here down below and it's downloading already there.<br>2:03 It goes up in the top right and I will open it and show you here. This is what it looks like.<br>2:08 It does not have page numbers Find out how to include or exclude page numbers in your PDF exports. Opens in new tab . It does not have page titles and has no grid Learn about grid lines and how they affect your PDF exports. Opens in new tab lines, right? All the way through.<br>2:15 So it is a real PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab and downloads it immediately without having to go to the Google Sheet. But now I'm going to show grid Learn about grid lines and how they affect your PDF exports. Opens in new tab lines which you might not want to do.<br>2:24 I'm going to print Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab the title.

I'm going to use actually I'm going going to show it for A4. I am going to show page numbers Find out how to include or exclude page numbers in your PDF exports. Opens in new tab and I'm going to fit in window and show sheet Learn how to show or hide sheet names in your exported PDFs. Opens in new tab names as well. So I'm going to select all Discover how to select all data in your Google Sheets for exporting. Opens in new tab those, get URL, it gets the URL, same URL but it has all of its all of these options<br>2:42 selected. So I'm going to click this, again it's going to download the PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab and I will open it here and see we get all of the, we get the page each of the pages show the tab.<br>2:58 It shows the title in the, the title of the entire Google Sheet here.

It has page numbers Find out how to include or exclude page numbers in your PDF exports. Opens in new tab down here and it's fitting it all into a sheet.<br>3:07 So and yeah, get, get a comic sheets while you're at it. But yeah BetterSheets.com. Go slash PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab . And then what you can also do is share Discover how to share your Google Sheets PDFs with others effortlessly. Opens in new tab this URL with others if they're like, hey, I want to download this as a PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab , but here are the options.<br>3:23 Or you know already the options for like a bunch of, of sheets you want to download. Go get this. Use it.<br>3:31 And let me know how it goes. Totally free and open to everyone. BetterSheets.co slash PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab .

If you want to know more about these PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab options, I have an article on the blog about it.<br>3:42 There's a link down here. And also check out all the other free tools. There's I'll see you next time. Support as a CSV Learn how to export your Google Sheets data as a CSV file. Opens in new tab file.<br>3:48 You can add copy to Find out how to copy data to the end of your URL for easy access. Opens in new tab the end of your URL. There's also a free daily tracker. If you haven't gotten it yet, get, get track anything in a Google sheet.<br>3:56 It's a free daily tracker. Also free Google sheet add-ons that I made for you. But yeah, I thought this was really cool.<br>4:03 Bettersheets.co slash PDF Learn how to export your Google Sheets as PDFs easily with this handy tool. Opens in new tab . Bye.</div>