While webmasters can create and format tables on their Web pages to display data, Google Sheets can look better, plus you can update them much more easily.
Luckily you can publish Google Sheet spreadsheets to the web with a command in the application.
If you want to create a downloadable copy of your spreadsheet, then our Google Sheet to PDF article can show you how.
How to Publish as PDF from Google Sheets
Use these steps to publish a Google Sheets spreadsheet online.
Total Time: 3 minutes
Step 1: Sign in to your Google Drive and open the Sheets file to publish.
You will need to know your Google crednetials if you aren’t already signed in.
Step 2: Select the File tab at the top of the window.
It’s at the top-left corner of the window, under the filename.
Step 3: Choose the Publish to the web option.
Note that you can always come back here later if you want to unpublish or make changes to the file.
Step 4: Click the Web page dropdown menu, then choose the PDF document option.
There are a bunch of other options on this drop down menu, including CSV files, Excel files, OpenDocument files, and more.
Step 5: Copy the generated link and send it to your desired recipients.
Note that there is also an “Embed” tab on this window. If you select that you will see code that you can copy and paste into a Web page so that you can display the spreadsheet data there instead.
Supply:
- Google Sheets file
Tools:
- Computer
- Internet connection
Materials: Google Account
You have some other sharing options for your files, too, such as if you want to learn how to let others edit Google Doc files that you have created.
Making documents publicly accessible from your Google Account is one of the simplest ways to let other people view your work.
There are a couple of different ways that you can accomplish this, including an option to simply publish the document and generate a link that you can send to people.
If the document that you are trying to publish is a Google Sheets file, then you might be concerned about simply publishing it as a spreadsheet.
Fortunately, there are a couple of different file formats to which you can publish, including a PDF.
You can also use a Google Drive tool if you want to convert PDF to Google Doc files, too.
Our tutorial below will walk you through the process of publishing a PDF version of your Sheets file to the Web so that you can share it with others in that format.
The steps in this article were performed in the desktop version of the Google Chrome browser. This guide assumes that you have already created a Google Sheets file that you wish to publish, and that it’s accessible from your Google Account. Once the document is published you will get a link that you can send to others so that they can download it.
Our tutorial continues below with additional information on publish a Google spreadsheet to the Web.
Did you know that you can also upload Google Drive PDF files if you want to make them accessible in Google drive?
How to Publish a Google Sheets File to the Web
- Open your Sheets file.
- Click File.
- Choose Publish to Web.
- Select a file type.
- Click Publish and copy the link.
Do you need to embed your document into a Web page instead? Find out how to get a Google file embed code so that the file can be displayed as part of the content on your website.
Google Sheets has a bunch of options that let you convert your Google spreadsheets into other types of files. You can learn more with our Google Sheets to CSV article.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.