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.
Nhà phát triển:
Đã cập nhật trang thông tin:6 tháng 11, 2026
Hoạt động với:
Chưa có bài đánh giá
2
Tổng quan
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.
Thông tin bổ sung
GiáKhông mất phí khi dùng các tính năng có tính phí
Nhà phát triển
Hỗ trợ
Chính sách quyền riêng tư
Điều khoản dịch vụ
SplitFill: Split Sheet by Column into Tabs sẽ yêu cầu các quyền như trình bày bên dưới. Tìm hiểu thêm
SplitFill: Split Sheet by Column into Tabs sẽ cần có quyền truy cập vào Tài khoản Google của bạn
Điều này sẽ cho phép SplitFill: Split Sheet by Column into Tabs:
Xem và quản lý bảng tính mà ứng dụng này đã được cài đặt bên trong
Kết nối với dịch vụ bên ngoài
Hiển thị và chạy nội dung web bên thứ ba trong lời nhắc và thanh bên ở trong các ứng dụng của Google
Xem địa chỉ email chính cho Tài khoản Google của bạn
Xem thông tin cá nhân của bạn, bao gồm mọi thông tin cá nhân mà bạn đã đăng công khai
Bài đánh giá
Ngôn ngữ:
Sắp xếp theo:
Google không xác minh bài đánh giá hoặc điểm xếp hạng. Tìm hiểu thêm về bài đánh giá
Không có nhận xét nào
Tìm kiếm
Xóa nội dung tìm kiếm
Đóng tìm kiếm
Các ứng dụng của Google
Trình đơn chính