As I’ve discussed previously (e.g. in this post) f you want to make a Google Sheets spreadsheet available for a large audience to see, you can publish the spreadsheet as a web page.
When the file is published, the publisher obtains a URL that can be sent to whomever they choose, or embedded into a website.
Google has just added five additional file formats in which your spreadsheet can be published:
- Comma-separated values (.csv)
- Tab-separated values (.tsv)
- PDF document (.pdf)
- Microsoft Excel® spreadsheet (.xlsx)
- OpenDocument spreadsheet (.ods)
To select your preferred format, use File > Publish to the web… :
Next, click on the selection field that’s currently set to Web page, and select from the list of alternatives:
The generated URL will, when opened in a browser, force a download of the spreadsheet in the selected format (spreadsheets in these additional formats can not be embedded).