Remove duplicates from a reviewed copy, without deleting rows from your source. DedupeFill for Google Sheets™ helps you deduplicate rows by explicit key columns, exactly or by similar text, and creates two NEW tabs: retained rows and a discarded-row report.

CHOOSE, REVIEW, THEN CREATE
Select one range with headings in the current spreadsheet. Choose the columns that identify
a duplicate, whether to keep the first or last source row, and two new output names. You can
use your own data or explicitly Create sample tab for fictional practice rows.

Preview is free. Review the counts and the rows of both outputs, with exact cell types/values,
in the sidebar before confirming. Every selected data row belongs to one output, in source order.
The discarded report preserves all original columns and adds original/retained source-row
numbers, and with similar text each row's similarity, so conflicting values remain available for review. Nothing is merged into your source.

EXACT OR SIMILAR MATCHING
Exact: text, numbers and booleans are distinct. Case and spaces matter: text 00123 differs from
numeric 123 even if the number is displayed as 00123.
Similar text: "Acme Inc." and "ACME, inc", "Café Rouge" and "Cafe Rouge". The key cells are
compared as displayed, with case, accents, spacing and punctuation ignored, and word order and
company words such as Inc and Ltd if you choose. Numbers must be the same. Each row joins the
retained row it is most like at your chosen similarity, 50 to 100, and the discarded report
shows that score. Untick any row that is not a duplicate, and Preview again to keep it.
First/last means original source-row order, not newest date or best record. Rows are never
merged.

A row with any blank key requires explicit approval to remain separately. Date-valued keys,
merged cells, source errors and ambiguous error-looking text refuse. Date-valued non-key cells
remain snapshots. Selected hidden and filtered rows participate; review your chosen rectangle.

TWO REVIEWABLE SNAPSHOTS
Source cells and existing tabs are not overwritten. Outputs contain calculated values and
number formats; formulas become their results and literal text remains text. Fonts/layout,
embedded links, notes, validation, conditional rules, filters, protections and hidden states
are not copied. Google Sheets™ may detect plain URL text normally. Outputs inherit the spreadsheet's
existing sharing and do not update when the source changes.

TWO PAIRED JOBS FREE; $9 ONCE
Two paired jobs free in total, each over the first 50 source rows; a free Preview counts the
whole source and shows the first 25 rows of each side. Existing users keep their current free
allowance. One job means BOTH verified output tabs, not a charge per tab. Preview, sample
creation, refused or partial work and recognized retries use no free job. The $9 one-time
unlock permits more supported jobs for the displayed account, with no subscription or automatic
renewal. Refunds are available within 14 days. Technical and Google service limits apply to free
and paid use.

PROGRESS AND RECOVERY
Keep the sidebar open while a job runs. Stop pauses after the current request, which may still
finish. An uncertain reply does not prove failure: preserve both tabs and the source. Explicitly
resume the same reviewed pair, or select unchanged source/options and Preview again to recognize
the latest job. Missing, renamed, edited or ambiguous output refuses; there is no automatic
repair or deletion. Do not start another job merely because the reply was lost.

Only the latest retry receipt is retained, without automatic expiry. A different admitted job
replaces a completed receipt; unfinished work blocks different work. Forget latest retry receipt
removes only recognition, leaving every tab, usage count and purchase intact. Forgotten or
replaced jobs lose automatic recovery.

SUPPORTED BOUNDS
Select up to 5,000 data rows plus one heading row, up to 20 source columns and up to 10
key columns. The two outputs together must fit 100,000 cells, including both heading rows
and the discarded report's two added source-row reference columns (with similar text, also its
similarity column). These limits apply jointly;
not every maximum-width input fits the paired-output cap. Oversized jobs refuse rather than
silently dropping rows. Additional text safeguards and Google service limits apply to free
and paid jobs.

Jobs near these limits can take several minutes; DedupeFill works in steps and shows its progress.

DATA AND BILLING
Google's services process the current spreadsheet. Complete review
values reach your open browser sidebar; temporary preview settings/digests and metadata-only
recovery/accounting stay in your Google account's add-on storage. No broad Google Drive™ access, AI,
external spreadsheet processor or separate content database is used. Stripe receives billing
email for purchase checks, even before checkout, and payment information you enter directly;
it receives no spreadsheet contents, keys, tab names, previews or outputs. The developer can
access Stripe billing records and Google's operational error logs for support, not your
spreadsheets or add-on storage. See the privacy policy for retention and deletion.

Google Sheets™ and Google Drive™ are trademarks of Google LLC. DedupeFill is independently developed by Spyridon Pikoulas and is not affiliated with Google.