Google spreadsheet direct download link for only ONE sheet as excel

Question

I was wondering if its possible to download say only sheet 1 of a google spreadsheet as excel? I have seen few SO posts that show the method to export the WHOLE sheet as excel, but I need to just export one sheet. Is it at all possible? and if yes, how?

Answer 1

You can download a specific sheet using the 'GID'.

Each sheet has a GID, you can find GID of specific sheet in the URL of spreadsheet. Then you can use this link to download specific sheet -

https://docs.google.com/spreadsheets/d/<KEY>/export?format=xlsx&gid=<GID>

ex: https://docs.google.com/spreadsheets/d/1D5vzPaOJOx402RAEF41235qQTOs28_M51ee5glzPzj0/export?format=xlsx&gid=1990092150

KEY is the unique ID of the spreadsheet.

source: https://www.quora.com/How-do-I-download-just-one-sheet-from-google-spreadsheet/answer/Ranjith-Kumar-339?srid=2YCg