More Publishing Formats for Google Sheets

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…   :

Click image to enlarge

Click image to enlarge

Next, click on the selection field that’s currently set to Web page, and select from the list of alternatives:

Click image to enlarge

Click image to enlarge

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).