← All examples

Sheets: copy all tab names

Collects the names of every sheet tab in the current spreadsheet and copies them to the clipboard, one per line.

Code to copy

// Copy the names of all sheet tabs in this spreadsheet
const tabs = [...document.querySelectorAll('.docs-sheet-tab-name')]
  .map(t => t.textContent.trim())
  .filter(Boolean);
navigator.clipboard.writeText(tabs.join('\n'))
  .then(() => alert(tabs.length + ' sheet names copied.'));

How to use this example

1. Copy the code with the button above.
2. Install JustZix (2 minutes) and open the extension on the target page.
3. Add a new rule matching that page.
4. Paste the code into the rule's JavaScript panel and save — it runs on every page visit.