Google Workspace Marketplace
For Google Sheets™: combine tabs and other spreadsheets you pick in Google Drive™ into one new tab. Map columns by heading, then append rows or sum by a key column. Your source files stay unchanged.
Nhà phát triển:
Đã cập nhật trang thông tin:11 tháng 11, 2026
Hoạt động với:
Chưa có bài đánh giá
1
Tổng quan
AppendFill for Google Sheets™ combines rows from several tabs into one new tab of a spreadsheet: tabs of the spreadsheet you are in, and tabs of other spreadsheets you pick in Google Drive™. Append every row, or sum them by a key column. Your source files and existing tabs stay unchanged.

OTHER SPREADSHEETS
Click Add another spreadsheet and pick a file in Google Drive™. Its tabs then show beside this spreadsheet's in each source list. AppendFill can open only the spreadsheets you pick for it, and it only reads them. The first time, Google asks you to allow this. A picked spreadsheet's values, dates and number formats are copied as they are there; a cell holding an error refuses the job and names the cell.

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 in this spreadsheet 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.

APPEND EVERY ROW
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, with the file's name for another spreadsheet.

SUM BY A KEY COLUMN
Or choose a key column, such as a customer or product ID, and the fields to sum. The new tab has one row per key, in the order the keys first appear: the key, each sum, how many rows it had and the source tabs they came from. Fields to sum take numbers and blanks only; text in one refuses the job and names the row. Other fields are left out.

Selected hidden and filtered rows ARE included, after explicit acknowledgement. The new tab shares the spreadsheet's access. AppendFill does not create files, join records on several columns, deduplicate, 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 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 from any of your spreadsheets, 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 spreadsheets and Google services. Stop pauses after the current request, so it may still finish. The output is marked INCOMPLETE until the whole result 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, appended or summed, 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 is not affiliated with Google.
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ụ
AppendFill: Combine & Consolidate for Sheets™ sẽ yêu cầu các quyền như trình bày bên dưới. Tìm hiểu thêm
AppendFill: Combine & Consolidate for Sheets™ 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 AppendFill: Combine & Consolidate for Sheets™:
Xem và quản lý bảng tính mà ứng dụng này đã được cài đặt bên trong
Chỉ xem, chỉnh sửa, tạo và xóa các tệp Google Drive bạn sử dụng với ứng dụng này
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