Contact database cleanup · CSV export from Excel / Google Sheets

Clean and deduplicate a contact database without silently deleting uncertain matches.

Send one business-contact CSV exported from Excel or Google Sheets, up to 5,000 rows and 20 columns. You receive a cleaned CSV, a review file for uncertain matches and a short audit summary.

CAD 49 fixed

Secure Stripe checkout.

See the cleanup decisions before you buy

Download a fictional before-and-after workbook showing exact duplicate removal, normalization, uncertain-match review flags and the audit summary delivered with a completed cleanup.

Download the fictional workbook

Email up to 20 fictional or redacted rows plus the duplicate rule you want checked. I will return one private screenshot showing exact-match counts, uncertain-match flags and the proposed decision rule. The free proof does not include a cleaned CSV, merged records or reusable automation.

Request a scope quote online Email the free 20-row proof

The downloadable workbook and free proof use fictional or redacted data only. Remove personal, medical, payment-card, password and government-ID data. Full cleaned files are delivered only after the fixed-price order is confirmed.

Included

  • CSV exports from Excel or Google Sheets
  • Exact-duplicate removal using agreed key fields
  • Near-duplicate candidates separated for review
  • Consistent capitalization, whitespace and email casing
  • Phone normalization only when the country rule is known
  • Flags for missing company/location and clearly invalid email syntax
  • Cleaned CSV, review CSV and written before/after counts
  • One clarification round; delivery within 48 hours after complete files and rules arrive

Boundaries

  • One CSV, maximum 5,000 rows and 20 columns
  • No scraping, enrichment, account access or guessed identity matching
  • No medical, payment-card, password or government-ID data
  • Ambiguous matches are flagged, not merged automatically
  • Source file is preserved; delivered files use the agreed rules

Email first for multiple files, more rows, joins, dashboards or repeat automation.

A checkable workflow

Fictional examples—this is the decision method, not client work.

Input patternActionEvidence returned
Same normalized email, duplicate rowKeep one approved record and record the removed row number.Exact-match count and retained key
“Acme Ltd” and “ACME Limited” with different emailsFlag as a possible match; do not merge without a rule.Review CSV with both source rows
Phone value without a confirmed countryPreserve the digits and flag the missing country rule.No invented country code

Questions before ordering

Can you clean an Excel or Google Sheets file?

Yes. Export one worksheet as CSV, or send one ordinary XLSX worksheet after scope confirmation. The fixed price covers one table, not a multi-sheet model or dashboard.

Will near-duplicates be merged automatically?

No. Exact duplicates follow the agreed key. Similar names, companies or addresses are placed in a review file unless you approve a deterministic merge rule.

What files will I receive?

A cleaned CSV, a separate review CSV for uncertain records and a short audit summary reconciling input rows, removed exact duplicates and output rows.

Should I send sensitive data?

No. Remove passwords, payment-card details, medical information and government identifiers. Send only the business-contact fields needed for the agreed cleanup.

Before purchase

Remove unnecessary sensitive fields and email a small anonymized sample to maxiaofeng@foxmail.com if you are unsure about scope. Direct checkout is intended for Canada/US customers and international business buyers; EU/UK consumers should email before paying.