Download view-only Google Sheets

Posted on February 21, 2025  •  1 minutes  • 122 words

A typical Google Sheets link looks like this

https://docs.google.com/spreadsheets/d/<....>/edit?gid=0#gid=0

In this mode, Google Sheets stops us from doing anything from saving, printing, add script, etc.. But they do have another feature called htmlview.

In this mode, Google Sheets will renders the spreadsheet as a static HTML page & there is nothing to stop us from downloading the spreadsheet HTML file which is a lot easier to process into any other format that you want.

To do this, remove the from the edit? til the end and replace them with htmlview

https://docs.google.com/spreadsheets/d/<....>/htmlview

From there, you can just save the HTML page & use whatever tool to convert it to CSV or Markdown. I just throw them into any LLM and it should work.