🟦Free

Free Google Ads Customer Match Formatter

Turn customer spreadsheets into a Google Ads Customer Match CSV. Phones in +91 E.164 format, the exact column names Google expects, duplicates removed, optional SHA-256 hashing done on your device.

📂

Drop your Excel, CSV or contacts (.vcf) files here, or choose files

Add as many files as you like. Title rows, missing headers, several numbers in one cell and 91… numbers are all handled.

🔒 Your files are read on your own device. Nothing is uploaded to us.

Settings

With Ora: Ora answers every visitor your ads send, day and night, collects their details and books them in, so more clicks become customers.

Start free

How to use the Google Ads Customer Match Formatter

  1. 1Drop your customer files.
  2. 2Choose the default country.
  3. 3Download the CSV.
  4. 4In Google Ads open Tools, Audience manager, Your data segments, Customer list, and upload it.

What this tool does

  • ✓Google’s column names: Email, Phone, First Name, Last Name, Country, Zip
  • ✓Phones in E.164 format (+919849012345)
  • ✓Country as a 2-letter code, only where a zip is present
  • ✓Merges files and removes duplicate people
  • ✓Optional SHA-256 hashing with Google’s Gmail rules

Questions people ask

What format does Google Customer Match need?+

A CSV with the headers Email, Phone, First Name, Last Name, Country and Zip. Phones must include the country code with a plus sign. Country and Zip are never hashed.

Do I need to hash the data?+

Google Ads hashes plain files in your browser when you upload them. Hash here only if you upload through the API or your rules require it.

Can I use Customer Match in India?+

Yes, if your Google Ads account meets Google’s Customer Match rules, such as a good payment and policy history.

More free tools

See all 57 tools →

Want this done for you, every month?

Prophecius checks every page of your site, connects your Google Search Console, tells you what to fix in plain words, and runs an AI assistant that answers your customers on your website and WhatsApp.