Google Workspace Marketplace
Split a Google Sheets™ tab into new tabs by column value. 2 splits free, then $9 once, no subscription. Preview every group first; the source stays unchanged.
Af:
Fortegnelse opdateret:6. november 2026
Fungerer sammen med:
Ingen anmeldelser
2
Oversigt
Split a sheet by column value with SplitFill for Google Sheets™. Create one new snapshot tab for each exact displayed group label.
inside the same Google spreadsheet.

Choose the source tab and an explicit range, select the grouping column and decide whether
the first row contains headings. Preview every group, row count and proposed output name
for free. Confirm to create NEW tabs after existing tabs. SplitFill leaves the source and
pre-existing tabs unchanged; it does not merge into or overwrite them.

EXACT DISPLAYED GROUPS
Labels are grouped exactly as displayed. Case, spaces and leading zeroes matter: North,
north and a label with surrounding spaces are different groups. Blank and formula-empty
displays share one group. Numeric and text cells with the same displayed label group together.
Output names are cleaned and made collision-safe without changing group membership.
Groups follow first occurrence; rows retain their source order.

Selected hidden and filtered rows ARE included, and output rows are visible. The sidebar
requires explicit acknowledgement before preview. All tabs share the spreadsheet's access;
splitting by person or team does not make their tabs private.

CALCULATED SNAPSHOTS, NOT LIVE FORMULAS
Outputs copy calculated scalar/date values, number formats and supported base cell styles:
fills, fonts, alignment and wrap, with column widths and an optional frozen heading row.
Formulas become their current results. Embedded source hyperlink targets, notes, mixed
rich-text styling, conditional rules, validation, filters, hidden states and protection are
omitted. Google Sheets™ may detect and style plain URL text in the output as it normally does.
This is not a full-fidelity copy, automatic refresh, separate-file export or sharing tool.

Merged cells, actual cell errors, unsupported values and wholly blank data rows refuse the
job. Formulas whose result begins with # are conservatively refused, including error-looking
text; ordinary literal error text is allowed. No rows are silently skipped to fit a limit.

Source values, displayed text and formulas are read afresh each generation request. Source
formatting and widths may use a short-lived cache, then receive a fresh full check before
completion. Style-only source edits can therefore be detected after partial tabs have been
written; completion is refused and those tabs remain. Missing, invalid or oversized cached
formatting requires a matching full source check before further writes.

Runtime output checks cover typed values, displayed text, no formulas, and tab IDs, names and
ownership. During progress, checks cover the active output and groups written in that request.
All output values and identities receive a whole-set check before completion. Changes to
earlier verified outputs may therefore be detected later, leaving preserved partials without
recording completion. Base styles and column
widths are copied when written; later cosmetic or annotation edits, including links, are not
separately audited or overwritten. Changes only to omitted source notes, links or rich-text
annotations are not tracked.

SUPPORTED LIMITS
Select up to 1,000 data rows plus an optional heading, 10 columns and 50 groups. The whole set
allows up to 10,500 output cells including repeated headings. Each displayed cell is at most
20,000 characters; source text is at most 100,000 characters. These are bounds, not a speed
promise or a guarantee for every maximum-size text input. Google service limits still apply.

STOP, INSPECT, RESUME
Requests process bounded chunks of the same job. Larger jobs can take several minutes; keep
the sidebar open while requests run. Closing it pauses further requests. Stop pauses between requests; the
current request may still finish. Pending tabs remain visibly INCOMPLETE until the complete
set has been checked. Reopen and preview the same unchanged source/options to recognize and
resume the latest job. A lost response may still leave output: retry explicitly, never by
starting a replacement set blindly. Changed output values, missing or unowned tabs and
ambiguous partials refuse safely and remain available for inspection; SplitFill does not
automatically repair or delete them. Cosmetic or link-only edits do not trigger that refusal.

TWO COMPLETE JOBS FREE, $9 ONCE
Previews are free. Two complete split jobs are free in total per Google account, across its
spreadsheets. One job is the whole set of group tabs, not one use per output tab. A job counts
only after all outputs are verified and recorded complete. $9 once unlocks further jobs within
supported limits, without a subscription or automatic renewal. Google service limits still apply.
The account used for source access, allowance and billing is shown in the sidebar.

Only the latest recognized job can reopen or resume without another free job. Retry metadata
has no automatic expiry. An unfinished job must be resumed or explicitly forgotten before a
different job can start. Forget latest retry receipt keeps all tabs, including INCOMPLETE tabs,
free usage and purchase, but removes their automatic recovery. See the privacy policy for the exact stored metadata and retention.
Grouping and snapshot creation use Google's Apps Script and Google Sheets™ services. No AI, broad
Google Drive™ access or outside data-processing service is used. Stripe receives billing email,
not spreadsheet contents.

Google Sheets™ and Google Drive™ are trademarks of Google LLC.
Yderligere oplysninger
PrisUden beregning med betalingsfunktioner
Udvikler
Support
Privatlivspolitik
Servicevilkår
SplitFill: Split Sheet by Column into Tabs anmoder om de tilladelser, der er angivet nedenfor. Få flere oplysninger
SplitFill: Split Sheet by Column into Tabs har brug for adgang til din Google-konto
Dette giver SplitFill: Split Sheet by Column into Tabs tilladelse til følgende:
Se og administrer regneark, som denne applikation er blevet installeret i
Opret forbindelse til en ekstern tjeneste
Vis og kør tredjepartswebindhold i meddelelser og sidebjælker i Google-apps
Se den primære mailadresse på din Google-konto
Se dine personlige oplysninger, heriblandt personlige oplysninger, som du har gjort offentligt tilgængelige
Anmeldelser
Sprog:
Sorter efter:
Google verificerer ikke anmeldelser eller bedømmelser.Få flere oplysninger om anmeldelser
Ingen kommentarer
Søgning
Ryd søgning
Luk søgning
Google-apps
Hovedmenu