Guide
Spreadsheet Sheet Split Panel Guide
A guide for splitting one Google Sheets source sheet into multiple output sheets by key column values from a sidebar with Apps Script.
Choose the source sheet, key column, and split method after installing the generated Apps Script.
Create fixed-value output sheets or formula-based views that follow source changes.
Choose how blank key rows and existing output sheet names are handled.
What this generator is for
This generator creates an Apps Script and SheetSplitPanel.html file that add a sheet split sidebar to Google Sheets.
Value split writes fixed results. Formula split writes FILTER formulas so existing classifications can follow source sheet edits.
Sheets for new key values added later are not created automatically, so rerun the split when classifications increase.
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 split a sheet, 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 SheetSplitPanel.html
Create an HTML file named SheetSplitPanel and paste the generated SheetSplitPanel.html content.
Run initial setup
Select setupSheetSplitPanel from the function dropdown and run it manually. Reload the spreadsheet after it finishes.
Open the sheet split panel
Open the panel from the KOKOCAL Sheet Split menu, then choose the source sheet, key column, and split method.
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 Split menu appears.
Split as fixed values
Specify a key column and confirm that rows are written as fixed values to separate sheets for each key value.
Split with formulas
Select formula split and confirm that output sheets contain FILTER formulas that update when the source sheet changes.
Blank key handling
Confirm that blank key rows are ignored or written to the uncategorized sheet according to the selected setting.
Existing sheet handling
Confirm that overwrite, skip, and numbered sheet creation work as expected for existing output sheet names.
Backup check
Before business use, test with a copied file and confirm sanitized sheet names, header rows, and formula reference behavior.
Notes
Output sheets may be overwritten
When overwrite is enabled, existing output sheets with the same names are cleared and recreated. Check that they do not contain needed data.
Formula split dependency
Formula split can break if the source sheet is renamed, deleted, structurally changed, or if the key column changes. Choose value split when you need fixed results.
New key values require rerun
Even with formula split, sheets for new key values added later are not created automatically. Rerun the split when classifications increase.
Sheet names are sanitized
Characters that cannot be used in Google Sheets sheet names are replaced or shortened for output sheet names.
Back up before use
Before changing order or temporarily hiding objects, make a copy of important slides.
Ready to generate the script
Split one source sheet into multiple sheets by key column values from a sidebar, either as fixed values or formula-based views.
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.