Menu
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?
735
Making a New File With One Sheet Instead, you'll have to actually create a workbook that only has a single sheet in it. An expedient way to share a single sheet is to first create a copy of your file. Once you've created a copy of the file, delete the other pages, and then share the sheet with the given person.
If you want to link someone to a specific sheet you can copy and paste the URL so it will open on your chosen sheet. You can use these URLs in an email or chat message to a colleague to send them exactly where you want, creating a customised view for different users.
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//export?format=xlsx&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
155
when you see every Google spreadsheet url looks like this
https://docs.google.com/spreadsheets/d/1D5vzPaOJOx402RAEF41235qQTOs28_M51ee5glzPzj0/edit#gid=1078561300
In every spreadsheet URL we can see: /edit#gid=
this is generally the default mode.
/edit#gid= just replace it with:
/export?format=xlsx&gid= it will download the single spreadsheet from the workbook
42
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
