Customer Match List Formatter

Drop your CRM or sheet export here, or choose a file CSV or TSV with emails, mobile numbers, or names with PIN codes.

Or paste rows from a spreadsheet

Copy the rows with their header row from Excel or Google Sheets.

Runs in your browser. Your customer list is not uploaded, and we never sign in to Google Ads.

Upload as

Hashed here (SHA-256) Plain text

Match customers by

Email Phone Mailing address

Address matching needs first name, last name, country and PIN code together.

Default country

Written on addresses with no country. Google asks for it on every address.

Phone country code

Added to 10-digit numbers and numbers starting with 0.

Consent column rule

We matched your column names. Change any that are wrong.

Lower-cased; dots removed from Gmail addresses.

Phone

Turned into +91… (E.164).

Full name

Split into first and last name if there are no separate columns.

First name

Optional. Titles such as Mr. or Smt. are removed.

Last name

Optional, with the first name column.

Country

Optional. Otherwise the default in step 2.

PIN or ZIP code

Needed for address matching.

Marketing consent

Your upload file appears here

Add a list or try the example: members of FitZone Gym, a made-up gym in Baner, Pune, with a few broken rows.

Free Customer Match List Formatter. Runs in your browser, no sign-up. Open the full tool on DigitalSnot →