Google Sheets is a popular and superior online spreadsheet app that allows you to create, edit, and share spreadsheets with anyone you want.
In Google Sheets, you can easily create multiple sheets (tabs/worksheets), and you can also easily download the entire Google Sheet in a variety of formats, including PDF, XLS, HTML, CSV, TSV, and ODDS, among others.
Table of Contents
If that's the case, you've come to the right place. Ourtechroom will guide you through this process of downloading single sheets.
Download Single Sheet from Google Sheet
There are no direct methods for downloading single sheets, but there are some tricky methods. Let's go over those tricky methods.
Method 1: Changing by Google Sheet Url Manually
Each sheet in Google Sheets has its own unique GID(Google Grid ID) identifier. These GIDs will assist you in identifying a particular sheet within the URL of the spreadsheet that you are using.
Your Sheet URL looks like this:
With GID in yellow color.
Now let's look at how to download the specific URL.
First Open Google sheet containing multiple sheets.
Click on the sheet you want to download.
Then your URL somethings look like this:
Here you just have to replace
/export?format=xlsx& in the URL as shown below.
Then press Enter.
Now, your that particular sheets get downloaded in excel format.
If you want to download in CSV then /edit should be replaced with the
If you want to download it in pdf then just replace
xlsx it with
For Excel :
This PDF can also be customized by appending additional parameters to the URL. We can include portrait, gridlines, and size in the pdf.
If you want to change the orientation of the pdf to
landscape then you do it as follows:
If you do not want
gridlinesthen you can do it as follows:
If you also want to set the size of the pdf page then you can do it as follows:
Here we are setting page size to B5 for PDF.
You can also combine all of those sizes, orientations, formats, and grids in one URL. But note that each of those parameters is separated by an ampersand(&) as shown below.
Method 2: Using Copy as Spreadsheet Option
In this case, what we will do is make each sheet into a separate spreadsheet, after which we will download it as we used to download the complete google sheet.
Let's do it.
Goto the bottom of google sheets, and click on the down arrow icon on the sheet.
Copy to >
New Spreadsheet Then from the dropdown, click on
Open spreadsheet the link from the popup. Click on
This will open current sheets in a new google spreadsheet.
Download > Then select your choice either pdf, CSV, docs,xlsx, etc. Then on this new google spreadsheet, click on
Method 3: Using Bookmark Techniques.
This method works as an automated process. You just have to run a bookmark to generate and download single sheets.
Click on the 3 dots at the top right corner.
Click on Bookmark manager.
Right-click on an empty area and Create a new bookmark with the name say: Download Specific spreadsheet.
In the value paste the below URL :
alert('Invalid GoogleSheet URL');
Then click on Ok .
In this way, we have created a bookmark.
Ans: This script is taking the current URL from the browser and if it found out
/edit#gid= then it converts them to /
export?format=xlsx&gid= and if it does not found
/edit#gid= then it displays an invalid google sheets URL because every google sheet URL has /edit#gid= in it.
Now let's look at how to download the sheet.
Click on the sheet you want to download.
. Click on the 3 dots at the top right corner.
Then click on Bookmark Manager. This will open a list of your bookmark.
Click on the bookmark "Download Specific Spreadsheet" which we have created recently.
Now that particular sheet which you have selected started to download.
Method 4: Using Chrome Extension
If you just want one click and download the sheet then you can use Chrome Extension. For downloading single sheets from google Sheets I will prefer the Download This Gsheet extension.
here. First download Download This Gsheet from
Then it shows in the toolbar.
Then open google sheets and then click on sheet and after that click on the Download This Gsheet icon.
Your sheet started to download.
In this way, you can download single specific sheets (worksheets) from the multiple sheets in Google Sheets.