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.
开发者:
应用详情更新日期:2026年11月6日
适用于:
没有评价
2
概览
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.
其他信息
定价付费功能可免费使用
开发者
支持
隐私权政策
服务条款
“SplitFill: Split Sheet by Column into Tabs”将请求获得以下权限。了解详情
“SplitFill: Split Sheet by Column into Tabs”将需要访问您的 Google 账号
这样可让SplitFill: Split Sheet by Column into Tabs:
查看和管理其中已安装此应用的电子表格
连接到外部服务
在 Google 应用的提示和边栏中显示和运行第三方网页内容
查看您的 Google 账号的主电子邮件地址
查看您的个人信息,包括您已公开的任何个人信息
评价
语言:
排序依据:
Google 不会核实评价或评分。 详细了解评价
没有评论
搜索
清除搜索内容
关闭搜索框
Google 应用
主菜单