How to Download a Specific Tab from Google Sheets
When a Google Sheet has multiple tabs, downloading the whole file gives you all worksheets — but sometimes you only need one specific tab. This guide explains exactly how to download a specific worksheet tab from Google Sheets, how the gid= URL parameter works, and how to export all tabs at once.
⚡ Quick Answer
Click the tab you want in Google Sheets → copy the URL from your browser (it will include gid=XXXXXXX) → paste it into SheetsBox.com → choose your format → click Download. Only that specific tab will be downloaded.
What is the gid= Parameter?
Every worksheet tab in Google Sheets has a unique identifier called a Sheet ID, stored in the URL as the gid= parameter. When you click a different tab in Google Sheets, the URL in your browser address bar updates to include that tab's gid number.
For example, a two-tab Google Sheet might have URLs like:
https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit#gid=0
// Tab 2 — "Q4 Report"
https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit#gid=1234567890
SheetsBox reads the gid= value from your URL and passes it to Google's export API so only that specific worksheet is downloaded.
Method 1 — Download a Specific Tab via SheetsBox
Click the specific tab you want
Open the Google Sheet. At the bottom of the screen, click the exact worksheet tab you want to download. The tab name will be highlighted and the URL in your browser will update automatically.
Copy the full URL from your browser
Click your browser's address bar and copy the complete URL. Make sure you copy it after clicking your desired tab — the URL should now include gid= followed by a number.
Paste into SheetsBox and download
Go to sheetsbox.com, paste the URL, choose your format (XLSX, CSV, PDF, or ODS), and click Download. SheetsBox will export only the tab identified by the gid= parameter in your URL.
gid=0. Additional tabs have randomly assigned numerical IDs. If you see no gid= in your URL, you're on the first tab — the download will still work correctly and will export that first tab.Method 2 — Download All Tabs as XLSX
When you download a Google Sheet as XLSX (Excel format), Google automatically includes all worksheet tabs in a single Excel workbook — each tab becomes a separate worksheet in the file. You don't need to do anything special.
Just paste the main Google Sheets URL (from any tab) into SheetsBox, select XLSX, and download. The resulting Excel file will contain every tab as a separate worksheet.
This is the easiest way to get all tabs in a single download. See our full Excel download guide for more detail.
Method 3 — Export All Tabs as CSV (One File Per Tab)
CSV format only supports a single worksheet per file. There is no way to export all tabs into one CSV file — this is a limitation of the CSV format itself, not of SheetsBox.
To download each tab as a separate CSV file, repeat this process for each tab: click the tab → copy the URL → paste into SheetsBox → select CSV → download. Each download will create a separate CSV file for that tab.
Which Format Should I Use?
📊 XLSX — All tabs in one file
Best for editing. All tabs are included automatically as separate worksheets. gid= is ignored for XLSX.
📄 CSV — One tab at a time
Raw data only. Uses gid= to determine which tab. One CSV file per tab.
📕 PDF — Current tab only
Uses gid= to export just that tab as a fixed-layout PDF for printing or sharing.
🗂️ ODS — All tabs in one file
Like XLSX, includes all tabs. Best for LibreOffice users.
Method 4 — Download via Google Sheets Built-In Export
If you're signed in with edit access, you can also export directly from Google Sheets:
Click the tab you want to download
Make sure the correct worksheet tab is active (highlighted) at the bottom of the screen.
Go to File → Download
Click File in the top menu bar, then hover over Download to see the format options.
Select your format
Choose Microsoft Excel (.xlsx) to get all tabs, or Comma-separated values (.csv) to get only the current tab. The file downloads immediately.
Frequently Asked Questions
How do I know which gid= number belongs to which tab?
Simply click the tab in Google Sheets and look at the URL in your browser address bar. The number after gid= is that tab's unique ID. The first tab is always gid=0.
Can I download all tabs as separate CSV files automatically?
Not with SheetsBox — it downloads one file at a time. To export each tab as a separate CSV, repeat the process for each tab. If you need to automate this for many tabs, the Google Sheets API or Google Apps Script would be more suitable.
Why is my downloaded file showing the wrong tab?
You probably copied the URL while a different tab was active. Go back to Google Sheets, click the correct tab, then copy the URL again from the browser address bar. The gid= value in the URL will change when you switch tabs.
Does the gid= parameter work for all export formats?
For CSV and PDF, yes — the gid= parameter controls which tab is exported. For XLSX and ODS, the gid= parameter is effectively ignored — all tabs are always included in the workbook regardless of which tab was active.
What if the Google Sheet only has one tab?
If the spreadsheet only has one tab, you don't need to worry about the gid= parameter at all. Just paste the URL and download — the single tab will be exported automatically.
Can I export all tabs to separate Excel files?
Not directly. XLSX format puts all tabs in one workbook. To get separate Excel files per tab, you would need to open the downloaded XLSX in Excel and manually move each worksheet to a new workbook, or use a macro.
Download any Google Sheets tab now
Click your tab, copy the URL, paste into SheetsBox. Free and instant.
Open SheetsBox →