Download one specific sheet from Google Sheets


👤 Diwas Poudel    🕒 Jul 16 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.

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 lets look how to download the specific url.

1 First Open Googlesheet containing multiple sheets.

Mutliple Worksheet google sheets
fig. Mutliple Worksheet 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 pdf then just replace xlsx with pdf and your url looks like this.

export?format=pdf

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

export?format=csv

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 complete google sheet.

Lets do it.

1 Goto the bottom of googlesheets, click on 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 new spreadsheet for one sheet

3 Click on Open spreadsheet link from the popup.

Open Spreadsheet
fig. Click on Open Spreadsheet Link

This will open current sheets in 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 methods works as automated process. You just have to run bookmark to generate and download single sheets.

1 Click on 3 dots at top right corner.

2 Click on Bookmark manager.

Bookmark Manager Chrome
fig. Bookmark Manager Chrome

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

add new bookmark
fig. add new bookmark

4 In the value paste 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 create 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 doesnot found /edit#gid= then it display invalid googlesheet url because every google sheet url has /edit#gid= in it.

Now lets look how to download the sheet .

6 Click on the sheet you want to download. 

7. Click on 3 dot at top right corner .

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

9 Click on 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 the googlesheets I will prefer 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 top right corner

4 Your sheet started to download.

Conclusion:

In this way you can download single specific sheets (worksheet) from the multiple sheets in Google Sheet.

 

👊 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