Download multiple but not all sheets from google spreadsheet to excel

[omcsarayar]

Hi everyone,

I'm working with a Google Spreadsheet that contains three sheets:

• Sheet A has all my combined data
• Sheets B and C contain report formats with filtered data.

I need to download only Sheets B and C together in an excel format, but I can only find a way to download individual sheets using their GID. Is there an efficient way to download both Sheets B and C at once without including Sheet A? Any advice or scripts would be greatly appreciated!

 

[Kaper]

So let's start from simple but not efficient way: Select both sheets B and C (click on first sheet tab first, press Ctrl and click on second tab). Then rightclick on one of tabs and select copy to and to new spreadsheet. Then click Open in the dialog window and from file select download as xlsx.

The other way round - download whole file from google and use VBA to delete from it unneeded sheets (code could be stored in personal.xlsb, so can be available immediately after opening downloaded file in excel).

None of these 2 are really satisfying, but until there is a better answer ...