How it works

The essential journey: Upload → Choose Columns → Clean & Transform → Review → Download. The simple keep-columns-only path is fast; the advanced workspace gives direct access to every tool. Both modes share the same transformation plan.

Step 1

Upload

Bring a CSV, TSV, or XLSX lead export. We validate the file type and show row count, columns, detected delimiter/encoding, and any warnings — without altering your original.

Step 2

Choose columns

Every detected header appears in a searchable panel with samples, blank counts, and a keep checkbox. Rename, reorder by drag-and-drop, and pick derived column destinations.

Step 3

Clean & transform

Split names, trim whitespace, standardize phones and states, filter rows, match an exclusion list, and remove exact duplicates. Or hit “Skip cleanup and download” for a fast keep-columns-only export.

Step 4

Review & download

Preview before/after, see changed-cell and excluded counts, then download a clean CSV or XLSX with exactly your output headers in order.

See it on real (synthetic) data

Toggle the tabs to compare a raw provider export with the cleaned output.

CompanyContact NameEmailPhoneCityStateZipCategory
Acme Plumbing LLCjane smithjane@acmeplumbing.com4155551234san franciscoCA94102plumber
Bright Solar Inc. Carlos ramirez carlos@brightsolar.com, carlos.r@brightsolar.com(415) 555-9876 ext 22OaklandCalifornia94601Solar
Delgado RoofingSmith, Mariamaria@delgadoroofing.com+14155554444San Joseca95112-3400roofing
Northwind CafePrince— blank —415-555-7777BerkeleyCA— blank —restaurant
Acme Plumbing LLCjane smithjane@acmeplumbing.com4155551234san franciscoCA94102plumber

What changed

  • Kept 8 of 8 columns, split Full Name → First / Last
  • Trimmed whitespace, title-cased names and cities
  • Standardized State to 2-letter codes
  • Parsed phones to E.164, separated extension
  • Flagged multi-address email for review
  • Removed 1 exact duplicate (by Email)

Cleanup tools included at launch

  • Split Full Name → First / Last (with review flags)
  • Trim whitespace, change case, format phones to E.164
  • Check email syntax (not deliverability), flag role inboxes
  • Extract website hostnames, standardize states
  • Remove empty rows, filter with AND/OR conditions
  • Exact deduplication by Email, Phone, or compound keys
  • Exclusion-list matching against your own lists
  • Combine or split columns, add constant Source/Tags

What formatting is not

  • Formatting an email does not establish deliverability or prove the address exists.
  • A standardized name does not confirm a person's identity or permission to contact them.
  • A clean row is not guaranteed CRM acceptance — verify import requirements for your destination.
  • Email verification, fuzzy matching, and direct CRM sync are later capabilities, not launch features.