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 KOKOCAL_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.
Display language selected on the website
Menu display language
Language used for the Google app menu and dialog or panel.
Merge modes and target sheets selected after setup
Merge as values
Writes fixed values to the output sheet.
Merge with formulas
Creates formulas that refer to source sheets so changes can be reflected.
All or selected sheets
Merge every eligible sheet or choose specific sheets from the sidebar.
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.
Create KOKOCAL_Menu.gs and KOKOCAL_SheetMergePanel.gs
Create KOKOCAL_Menu.gs and KOKOCAL_SheetMergePanel.gs in Apps Script, then paste the generated content into each file. Back up existing code before editing it.
Create KOKOCAL_SheetMergePanel.html
Create an HTML file named KOKOCAL_SheetMergePanel and paste the generated KOKOCAL_SheetMergePanel.html content.
Run initial setup
Select KOKOCAL_SheetMergePanel_setup 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 menu, then choose the merge mode and target sheets.
Save the implementation guide
After generating the script, 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.
Post-setup review points
Menu appears
Reload the spreadsheet and confirm that the KOKOCAL 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 .gs files, HTML files, saving, first authorization, triggers, and other basics before setup.
Using multiple scripts
Learn how to organize KOKOCAL_Menu.gs, feature files, the shared menu, triggers, and permissions when combining generated scripts.