Brought to you by:

Hi Reader,

Welcome to the Google Sheets Tips newsletter #333, your Monday morning espresso, in spreadsheet form!

This might be one of the most useful newsletters I've written. And I can't believe I've waited this long (7+ years!) to cover this topic.

I'm sharing 10 incredibly useful modifications you can make to your Google Sheets URLs to change how they behave. You can share your Sheet as a template, in a minimal editor, or save as a PDF, and more. Find it all below in tip #333.

Brought to you by: Nautilus Get Smarter with Nautilus You know that "aha" moment when your spreadsheet clicks into place—every formula, reference, and macro working in perfect harmony? Nautilus brings that same sense of clarity to the world around us. This award-winning science magazine explores the hidden connections between nature, culture, and everyday life, delivering thought-provoking stories in its free newsletter. Join 600,000+ curious minds exploring how our universe works. Subscribe for free today. Unsubscribe anytime. Sign up for free

➜ News

I.
​Gemini in the sidebar of your Google Sheets is getting more capable. It can now analyze your data and generate static charts to go into your Sheets. Available to users on paid Workspace tiers.

​Read more here >>​

➜ Sheets Tip #333: Incredibly Useful URL Tricks for Sheets

Take a look at any Google Sheets URL in the address bar of your browser.

It will take the following form:

https://docs.google.com/spreadsheets/d/ + file ID + / extension

Did you know that by changing the extension we can make our Sheet behave differently?

We can share a link that exports it directly as a PDF for example. Or share a template ready for copying.

Feel free to click on any of the links below to see how they work.

Standard Link

/edit?usp=sharing

​https://docs.google.com/spreadsheets/d/1h8kgPdJx8myJP_C_8WRfs4x6Uqqg2E7s5YdTpJDbcUM/edit?usp=sharing​

Preview

/preview

​https://docs.google.com/spreadsheets/d/1h8kgPdJx8myJP_C_8WRfs4x6Uqqg2E7s5YdTpJDbcUM/preview​

Template

/template/preview

​https://docs.google.com/spreadsheets/d/1h8kgPdJx8myJP_C_8WRfs4x6Uqqg2E7s5YdTpJDbcUM/template/preview​

Make a Copy

/copy

​https://docs.google.com/spreadsheets/d/1h8kgPdJx8myJP_C_8WRfs4x6Uqqg2E7s5YdTpJDbcUM/copy​

Export as a PDF

/export?format=pdf

​https://docs.google.com/spreadsheets/d/1h8kgPdJx8myJP_C_8WRfs4x6Uqqg2E7s5YdTpJDbcUM/export?format=pdf​

Export as a CSV

/export?format=csv

​https://docs.google.com/spreadsheets/d/1h8kgPdJx8myJP_C_8WRfs4x6Uqqg2E7s5YdTpJDbcUM/export?format=csv​

Export as an Excel Document

/export?format=xlsx

​https://docs.google.com/spreadsheets/d/1h8kgPdJx8myJP_C_8WRfs4x6Uqqg2E7s5YdTpJDbcUM/export?format=xlsx​

Distraction Free Editor

/view?rm=minimal

​https://docs.google.com/spreadsheets/d/1h8kgPdJx8myJP_C_8WRfs4x6Uqqg2E7s5YdTpJDbcUM/view?rm=minimal​

(Because I shared a view-only copy, you won't be able to do any editing. Share with editor rights if you want to use this feature.)

Basic Controls Editor

/view?rm=demo

​https://docs.google.com/spreadsheets/d/1h8kgPdJx8myJP_C_8WRfs4x6Uqqg2E7s5YdTpJDbcUM/view?rm=demo​

Embed in Iframe

/view?rm=embedded

​https://docs.google.com/spreadsheets/d/1h8kgPdJx8myJP_C_8WRfs4x6Uqqg2E7s5YdTpJDbcUM/view?rm=embedded​

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. The most dangerous type of canoes...​