Google Sheets Bulk Tab Renamer

WHAT IT DOES

Google Sheets Bulk Tab Renamer lets you rename multiple sheets in a single operation. Instead of double-clicking each tab, typing a new name, and pressing Enter — repeating this for every single sheet — this tool provides a unified checklist of all sheets in your spreadsheet. You can filter sheets by name to quickly find the ones you want to rename. Select any number of sheets using checkboxes, choose your rename pattern (Add prefix, Add suffix, or Replace), enter the pattern text, and click Rename. The tool then automatically processes each selected sheet — triggering the rename action, applying the name pattern, and confirming the change. This turns what could be dozens of manual operations into a single batch action, making spreadsheet organization and tab management significantly faster and more consistent.

WHERE IT RUNS

This script runs exclusively on the Google Sheets web application in your browser. It activates on any open spreadsheet where sheets are visible in the bottom tab bar. It requires the BotGentz extension to inject and execute the script. The tool does not work on the Google Sheets mobile app, the API, or any third-party spreadsheet clients — only the web-based Google Sheets interface accessed through a Chromium-based or Firefox browser. It specifically targets pages under *.google.com/sheets/*, including the Google Sheets document editing view.

HOW TO USE

After installing the script via BotGentz, open any Google Sheet. The tool automatically detects the sheet tabs and displays a floating panel on the right side. The panel shows all sheets in the spreadsheet, with checkboxes next to each sheet entry. Each sheet displays its name, position, and a "Active" indicator if it's the currently selected sheet. Use the search box to filter by sheet name to narrow down your selection. Check the boxes for every sheet you want to rename. Below the sheet list, select your rename pattern — "Add prefix" to add text before the existing name, "Add suffix" to add text after the existing name, or "Replace" to replace part of the name (use the format "old|new"). Enter the pattern text in the input field. Click "Rename Sheets" and confirm the action. The tool will process each selected sheet one by one — double-clicking the tab or using the right-click menu to access the rename option, applying the name pattern, and confirming. A status message appears when the operation completes, showing how many sheets were successfully renamed.

THE ACTUAL MECHANISM — WHY IT WORKS

Google Sheets' web interface is built with React and uses a component-based rendering system for its sheet management. Sheet tabs are rendered as interactive elements in the bottom tab bar, each with its own set of event handlers. This tool scans the DOM for sheet tab elements using multiple selector patterns that Google Sheets consistently uses across versions. For each sheet, it extracts the name and position from the visible text content and data attributes. Each sheet is assigned a unique identifier from data attributes. When renaming, the tool uses two primary methods: double-clicking the sheet tab to trigger the built-in rename input, or using the right-click menu's rename option. The tool then sets the new name value using React-friendly event dispatching — setting the value via the native setter and dispatching both "input" and "change" events to ensure React registers the update. The tool then dispatches an Enter key event to confirm the rename. This approach works without making direct API calls, which would require authentication credentials and knowledge of Google Sheets' internal API structure. By using the existing UI, the tool works within Google Sheets' own permission and validation system, and continues to function even if the underlying API changes.

THE PANEL

The floating panel is fully draggable — click and drag the header to reposition it anywhere on the page. The panel's position is saved per site in localStorage, so it reappears exactly where you left it when you return to the spreadsheet. Double-click the header to snap the panel to the nearest edge (left or right). A collapse button minimizes the panel to a small tab showing a grid emoji badge, keeping it out of the way while still accessible. The sheet list inside the panel is scrollable and resizes vertically based on the number of sheets. Pressing Escape while the panel is focused closes it completely; reopening is done via a small button injected near the spreadsheet toolbar. All panel interactions are non-blocking — Google Sheets' main UI remains fully responsive while the panel is open, and the panel updates automatically when you navigate between sheets.

PLEASE NOTE

This script requires the BotGentz extension (free) to run user scripts on Google Sheets. Google Sheets frequently updates its web interface and sheet tab structures; if the tool stops working, check for an updated version within BotGentz's script repository. This tool does not store, transmit, or log any sheet data, names, or content — all operations occur locally in your browser with no external network requests except those made by Google Sheets itself. Sheet rename operations are applied through Google Sheets' own UI event system, so all changes respect your document permissions and sharing settings. The tool does not bypass Google Sheets' security or permission system; it simply automates the clicks you would otherwise perform manually. For spreadsheets with a large number of sheets, the tool may take several minutes to complete the operation, as each sheet is processed sequentially with delays to avoid overwhelming the UI. A progress indicator shows which sheet is currently being processed. The tool only detects sheets currently loaded in the DOM; all sheets in the spreadsheet should be visible in the tab bar. Always double-check your selections and pattern before applying changes, as bulk renames can affect formulas and references that rely on sheet names. The replace pattern uses the format "old|new" where "old" is the text to find and "new" is the replacement text (case-insensitive). The active sheet indicator helps you identify which sheet is currently selected.