Download one specific sheet from Google Sheets


👤 Diwas Poudel    🕒 Oct 4 2022    📁 TECH

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.

Google Sheets Import Data - Import ...
Google Sheets Import Data - Import from multiple spreadsheets to one range
However, you may have difficulty downloading a specific sheet from Google Sheets or you may have difficulty downloading any sheet from Google Sheets.

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:

https://docs.google.com/spreadsheets/d/10LRv-C1AEHbSi-8JOvdwcpbgbHwYl8vtLaDNJsnVaH8/edit#gid=1812404870

With GID in yellow color.

Now let's look at how to download the specific URL.

1 First Open Google sheet containing multiple sheets.

Mutliple Worksheet google sheets
fig. Multiple Worksheets in Google Sheets

2 Click on the sheet you want to download.

select-one-sheet
fig. Select one sheet from Google Sheets

3 Then your URL somethings look like this:

https://docs.google.com/spreadsheets/d/10LRv-C1AEHbSi-8JOvdwcpbgbHwYl8vtLaDNJsnVaH8/edit#gid=1812404870

Here you just have to replace /edit#  with /export?format=xlsx& in the URL as shown below.

https://docs.google.com/spreadsheets/d/10LRv-C1AEHbSi-8JOvdwcpbgbHwYl8vtLaDNJsnVaH8/export?format=xlsx&gid=1812404870
change-url-to-url-containing-export
fig. Convert /edit# to export?format=xlsx& in the URL

4 Then press Enter.

Now, your that particular sheets get downloaded in excel format.

Also read: How to use if a cell contains in google sheets?

If you want to download in CSV then /edit should be replaced with the export?format=csv

export?format=csv

If you want to download it in pdf then just replace xlsx it with pdf and your URL looks like this.

For Excel : 

export?format=xlsx

For PDF:

export?format=pdf

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:

export?format=pdf&portrait=false

If you do not want gridlinesthen you can do it as follows:

export?format=pdf&gridlines=false

If you also want to set the size of the pdf page then you can do it as follows:

export?format=pdf&size=b5

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.

export?format=pdf&portrait=false&size=b5&gridlines=false

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.

1 Goto the bottom of google sheets, and click on the down arrow icon on the sheet.

2 Then from the dropdown, click on Copy to > New Spreadsheet

copy to new spreadsheet for one sheet
fig. copy to a new spreadsheet for one sheet

3 Click on Open spreadsheet the link from the popup.

Open Spreadsheet
fig. Click on Open Spreadsheet Link

This will open current sheets in a new google spreadsheet.

4 Then on this new google spreadsheet, click on File > Download > Then select your choice either pdf, CSV, docs,xlsx, etc. 

file-download-as-xlsx
fig. Click on File > Download > Microsoft Excel (.xlsx)
Also read: List all Google Drive links of Files / folder to Google Sheet

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.

1 Click on the 3 dots at the top right corner.

2 Click on Bookmark manager.

Bookmark Manager Chrome
fig. Bookmark Manager Chrome

3 Right-click on an empty area and Create a new bookmark with the name say: Download Specific spreadsheet

add new bookmark
fig. add a new bookmark

4 In the value paste the below URL :

script-bookmark-googlesheet
fig. Create new Javascript
javascript:var webURL = window.location.href;
if(webURL.indexOf('/edit#gid='))
   window.location.assign(webURL.replace('/edit#gid=','/export?format=xlsx&gid='));
else
alert('Invalid GoogleSheet URL');

5 Then click on Ok .

In this way, we have created a bookmark.

What this script is doing?

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.

6 Click on the sheet you want to download. 

7. Click on the 3 dots at the top right corner.

8 Then click on Bookmark Manager. This will open a list of your bookmark.

9 Click on the bookmark "Download Specific Spreadsheet" which we have created recently.

Download-Specific-spreadsheet
fig. Download specific spreadsheet by running bookmark script

10 Now that particular sheet which you have selected started to download.

Also read: How to Set Default value for cell in Google Sheets?

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.

1 First download Download This Gsheet from here.

download-this-gsheet
fig. click on download button

2 Then it shows in the toolbar.

3 Then open google sheets and then click on sheet and after that click on the Download This Gsheet icon.

new extension
fig. Click on this extension at the top right corner

4 Your sheet started to download.

Conclusion:

In this way, you can download single specific sheets (worksheets) from the multiple sheets in Google Sheets.

 

👊 MORE FROM OURTECHROOM 👊



Ourtechroom Main Logo
Hello and thank you for visiting Ourtechroom.com! We'll talk about everything from how to troubleshoot tech issues, to emerging technology, games, gadgets, and fun facts about technology.
Contact : ourtechroom777@gmail.com