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.
Door:
Vermelding geüpdatet:11 november 2026
Werkt met:
Geen reviews
1
Overzicht
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.
Meer informatie
KostenKosteloos met betaalde functies
Ontwikkelaar
Support
Privacybeleid
Servicevoorwaarden
AppendFill: Combine & Consolidate for Sheets™ vraagt u om de onderstaande rechten. Meer informatie
AppendFill: Combine & Consolidate for Sheets™ heeft toegang nodig tot uw Google-account
Hiermee kan AppendFill: Combine & Consolidate for Sheets™ het volgende doen:
Spreadsheets waarin deze app is geïnstalleerd bekijken en beheren
Alleen de specifieke Google Drive-bestanden bekijken, bewerken, maken en verwijderen die je met deze app gebruikt
Verbinding maken met een externe service
Webcontent van derden weergeven in prompts en zijbalken in Google-apps
Het primaire e-mailadres van je Google-account bekijken
Uw persoonlijke info bekijken, met inbegrip van persoonlijke info die u openbaar heeft gemaakt
Reviews
Taal:
Sorteren op:
Google verifieert reviews en beoordelingen niet. Meer informatie over reviews
Geen opmerkingen
Zoeken
Zoekopdracht wissen
Zoekfunctie sluiten
Google-apps
Hoofdmenu