Google sheets: publish some but not all worksheets

Question

I have a Google spreadsheet which compiles scheduling info for an event. The file has five worksheets. There are two worksheets which I want to publish to the web; the other three are for my use and to drive calculations.

I can see how to publish the entire file, and how to publish an individual worksheet. However, I cannot figure out how to publish say, sheet1 and sheet2 to a single document.

As a short-term workaround I have tried the following, which works after a fashion but I'm not a fan:

• Create a new file with two sheets
• Sheet1 uses an importrange call to grab the data from the original sheet1
• Sheet2 uses an importrange call to grab the data from the original sheet2
• I then publish the entirety of the new document

The finished product must be in Google Apps; that is a requirement I cannot dodge.

question from:https://stackoverflow.com/questions/66052138/google-sheets-publish-some-but-not-all-worksheets

Answer 1

Solution 1:

You can hide the sheets that you don't want to publish, and then publish the entire document:

Published sheet:

Solution 2:

You can publish selected sheets using the Published Content & Settings options on the Publish to the Web dialog box. In the dropdown menu you can select which sheets to include:

The published spreadsheet would look like this:

Note: It seems that the web page may not display all the selected sheets, only the first sheet. You can file a feature/bug request here: https://support.google.com/a/answer/6284762?hl=en