Google Workspace Marketplace
Combine sheets with AppendFill for Google Sheets™. Review mappings, approve blanks and exclusions, then create one new snapshot. Two free trial jobs; $9 once.
开发者:
应用详情更新日期:2026年11月9日
适用于:
没有评价
1
概览
Combine sheets with AppendFill for Google Sheets™: bring rows from several tabs into one new snapshot tab.
Choose the order and ranges, review the columns, then confirm the complete output.
Your source cells and existing tabs stay unchanged.

REVIEW HOW EACH COLUMN FITS
Inspect selected ranges for free. Each range starts with one heading row. Choose the
output headings, then map each output field to a source column by its position and exact
heading. "Map exact headings" is an explicit convenience for equal headings only: it
does not infer aliases or decide that Item means ID. Renamed headings can be mapped manually.

No data yet? Create sample tabs adds two tabs of fictional orders, chosen as the sources with
their headings mapped, so you can preview and create a snapshot right away. If a range's first
row holds numbers, dates or checkboxes, AppendFill says so and offers Add heading row above,
which inserts one row of headings after you confirm.

Missing a field in one source? Choose a real blank and approve it separately. Want to omit
a source column? Approve that exclusion explicitly. No source column is silently dropped,
reused for two output fields or guessed into a different field.

ONE NEW TAB, IN YOUR CHOSEN ORDER
Preview every source range, mapping, approved blank or exclusion, output heading and row
count. Rows follow your chosen source order and retain their order within each source.
Duplicate rows and identifiers stay. Numeric zero stays zero; a missing field is a blank,
not an invented value. A generated provenance column identifies each row's source tab.

Selected hidden and filtered rows ARE included visibly, after explicit acknowledgement.
All tabs share the spreadsheet's access. This does not create private files per source,
merge on a key, deduplicate, join records, or refresh automatically when sources change.

CALCULATED VALUES, NOT A FULL-FIDELITY COPY
Output contains calculated scalar/date values and mapped number formats. Formulas become
their current results; literal text remains text, including leading zeros and text beginning
with an equals sign. Font/layout, embedded hyperlink targets, notes, validation, conditional
rules, source hidden state and protections are not copied. Google Sheets™ may detect plain
URL text as a link in its normal way.

Choose explicit bounded ranges with unique, nonblank source headings. Merged cells,
wholly blank selected data rows, unsupported values and error-looking formula results
refuse the whole job. Nothing is silently skipped to fit a limit. The sidebar shows the
current supported limits before preview.

Joint limits: up to 5,000 OUTPUT rows including one heading, 20 source tabs, 20 selected
columns per source, and 19 mapped output fields plus the generated source-tab column. The
whole output is capped at 100,000 cells. These limits apply together, not separately per
source; repeated source headings are not appended as data.

SAFE PARTIAL RECOVERY
Larger jobs can take several minutes. Keep the sidebar open while bounded requests advance
progress; runtime varies with the spreadsheet and Google services. Stop pauses after the
current request, so it may still
finish. The output is marked INCOMPLETE until the whole snapshot verifies. A source change,
changed reviewed mapping, missing output or inconsistent partial refuses further writes;
existing output is preserved instead of overwritten, repaired or deleted.

If a reply is lost, the outcome is unconfirmed. Check the latest job before an explicit
same-job retry. After reopening, select the same sources and settings, Inspect and Preview
again to recognize the latest partial or completed job. An unchanged completed latest job
reopens its existing tab without creating another output or using another free job.

TWO FREE JOBS, THEN $9 ONCE
Preview is always free. Two jobs are free in total per Google account, each over the first
50 rows of every source. One job is one whole verified output tab, not one row, request or
preview. Sample tabs, heading rows and a paused or refused partial use no free job. $9 once
unlocks whole jobs and more within the supported limits; no subscription or automatic
renewal. Google service limits still apply.

The actual Google account used for sources, allowance, recovery and billing is displayed.
Forget latest retry receipt removes only the latest recovery metadata; all tabs, free usage
and purchase stay. An unfinished output then loses automatic recovery. Clear review removes
the loaded review from the open sidebar, without deleting that receipt or any spreadsheet.

Combining uses Google's spreadsheet services. There is no AI, broad Google Drive™ access, external
content-processing service or marketing email. Stripe receives billing email, not sheet data.

Google Sheets™ and Google Drive™ are trademarks of Google LLC.
其他信息
定价付费功能可免费使用
开发者
支持
隐私权政策
服务条款
“AppendFill: Combine Tabs for Google Sheets™”将请求获得以下权限。了解详情
“AppendFill: Combine Tabs for Google Sheets™”将需要访问您的 Google 账号
这样可让AppendFill: Combine Tabs for Google Sheets™:
查看和管理其中已安装此应用的电子表格
连接到外部服务
在 Google 应用的提示和边栏中显示和运行第三方网页内容
查看您的 Google 账号的主电子邮件地址
查看您的个人信息,包括您已公开的任何个人信息
评价
语言:
排序依据:
Google 不会核实评价或评分。 详细了解评价
没有评论
搜索
清除搜索内容
关闭搜索框
Google 应用
主菜单