We will see how to share your Google Sheets file as a PDF.
Why share your Google Sheets file as a PDF
Nowadays, many people prefer sharing in PDF format because they’re easy to download, print and transfer. Sometimes people convert their google sheets using third party converters or exporting in pdf.
Get a link to share your File
- Click on share on the top right
- In the “Get Link” section, give the correct rights and access
- Click on “Copy link”
Send your file as a PDF by changing the end of the URL
In the previous section, you saw how to get the link to share your file. To share your file as pdf you need to follow these steps:
- Get the normal link to share your Sheet file
- Change the end of the copied URL before sending it.
- Before:
docs.google.com/spreadsheets/d/<doc_id>/edit?usp=sharing
- After:
docs.google.com/spreadsheets/d/<doc_id>/export?format=pdf
- For example, if your URL is https://docs.google.com/spreadsheets/d/1sNjNRJkm8izv6BTLerI44iHmval6WvtbR6uUewa9k7Y/edit?usp=sharing, you can change it to https://docs.google.com/spreadsheets/d/1sNjNRJkm8izv6BTLerI44iHmval6WvtbR6uUewa9k7Y/export?format=pdf
- Accessing the link this way would show the file as PDF and auto-download it as well. However, if your file is large, it might take some time to download.
Benefits of sharing your Google Sheets file as a PDF
- You don’t need to reshare your PDF if there is any change in the original file, it will automatically be reflected in the PDF when you download it.
- It saves your email storage and saves attachment space. Also, it can bypass attachment limits.
- All the versions (PDF and source files) are saved in a single file, you don’t need to save them separately.
Conclusion
We learned how to get the link to share your Google Sheets file. We also saw how to share your Google Sheets file as a PDF.
See Also
Want to know more formulas and functions in Google Sheets? Look at our definitive guide on Google Sheets which covers hundreds of such topics here. Enjoy reading!
IMPORTHTML in Google Sheets: We will have a look at IMPORTHTML in Google Sheets using which, we can pull data for tables and lists from a given webpage.
How to Import a CSV File into Google Sheets: Learn how to import a CSV file into Google Sheets