Guide
Spreadsheet Sheet Merge Panel Guide
A guide for merging multiple Google Sheets tabs into one output sheet from a sidebar with Apps Script.
Choose merge options from a sidebar after installing the generated Apps Script.
Create a fixed-value output sheet or a formula-based combined view.
Merge every eligible sheet or fetch sheet names and merge only checked sheets.
What this generator is for
This generator creates an Apps Script and SheetMergePanel.html file that add a sheet merge sidebar to Google Sheets.
It is useful when several sheets with the same column structure should be combined into one output sheet.
The output sheet is automatically excluded from merge targets. Test with a copied file before using it in business work.
Form input fields
Menu display language
Language used for the Google app menu and dialog or panel.
Setup steps
Open Apps Script from Google Sheets
Open the Google Sheets file where you want to merge sheets, then open Apps Script from Extensions.
Paste Code.gs
Paste the generated Code.gs into Apps Script. Back up existing code before replacing it.
Create SheetMergePanel.html
Create an HTML file named SheetMergePanel and paste the generated SheetMergePanel.html content.
Run initial setup
Select setupSheetMergePanel from the function dropdown and run it manually. Reload the spreadsheet after it finishes.
Open the sheet merge panel
Open the panel from the KOKOCAL Sheet Merge menu, then choose the merge mode and target sheets.
Save the implementation guide
After generation, use Download setup guide at the top right of the generated result column to save the information needed for setup. Generated results disappear when you leave the page, so saving the guide before setup is recommended.
What the guide includes
The setup method, post-setup review points, generated script, settings JSON, and config hash are collected in one document. The setup method starts with a note that the generated script appears later in the guide.
Available formats
Choose Markdown (.md), Word (.docx), or the PDF save view.
Post-setup review points
Menu appears
Reload the spreadsheet and confirm that the KOKOCAL Sheet Merge menu appears.
Merge as fixed values
Merge all sheets as values and confirm that fixed results are written to the output sheet.
Merge selected sheets
Fetch sheet names and confirm that only checked sheets are merged.
Merge with formulas
Select formula merge and confirm that the output sheet contains references that update when source sheets change.
Output sheet is excluded
Confirm that the output sheet is automatically excluded from merge targets.
Backup check
Before business use, test with a copied file and confirm header rows, empty sheets, and hidden sheet behavior.
Notes
Review before use
Review this point before using the generated script in production.
Review before use
Review this point before using the generated script in production.
Important note
Review this point before using the generated script in production.
Back up before use
Before changing order or temporarily hiding objects, make a copy of important slides.
Ready to generate the script
Merge multiple sheets into one output sheet from a sidebar, either as fixed values or as a formula-based combined view.
Guide
Related guides
Review these guides together with this page to make setup and operation smoother.
Getting started
Review the input column, generated result column, code, setup steps, review points, and JSON menu.
Apps Script basics
Review Code.gs, HTML files, saving, first authorization, triggers, and other basics before setup.
Using multiple scripts
Learn how to organize shared functions such as onOpen, menu names, triggers, and permissions when combining generated scripts.