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 freeHow to use the Google Ads Customer Match Formatter
- 1Drop your customer files.
- 2Choose the default country.
- 3Download the CSV.
- 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
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.