Stop dealing with "Format Error" rejections. Drop your raw CRM export below, and we'll automatically clean, lowercase, strip spaces, and output a perfect Customer Match CSV.
or click anywhere to browse from your computer.
Awaiting file upload...
Successfully parsed 0 records.
| Phone | First Name | Last Name |
|---|
Google recommends pre-hashing data. Upgrade to PRO to hash your CSV client-side securely.
Uploading custom audiences to Google Ads (Customer Match) is one of the most powerful ways to run retargeting campaigns, lookalike audiences, and ROAS-optimized searches. However, marketers constantly struggle with the dreaded "Formatting Error" because Google's ingestion engine is incredibly strict.
When you export data from a CRM like Salesforce, HubSpot, or Shopify, the raw data is rarely ready for Google Ads. Here are the mandatory formatting rules our tool automatically applies:
John.Doe@Example.com. It must be converted to john.doe@example.com.
Our script strips trailing spaces and forces lowercase instantly.+ followed by the country code. Furthermore, all spaces, dashes,
and parentheses must be stripped. Our Regex engine cleans (555) 123-4567 into
standard formats.Email,
Phone, First Name, and Last Name.You are dealing with Personally Identifiable Information (PII). Our tool uses the HTML5 FileReader API to process your CSV entirely within your local browser. Data never touches our servers.
By pre-cleaning your data, you avoid Google's internal ingestion errors, increasing your overall customer match rate from the standard 30% to upwards of 60%.
While Google Ads will automatically hash unhashed data upon upload, enterprise compliance teams often require that PII is hashed before it leaves the local network. Hashing must be done using the SHA256 algorithm.
If you require client-side hashing before generating the CSV, consider upgrading to DataPrep Pro. The Pro version instantly converts all emails and phone numbers into irreversible SHA256 strings while maintaining the exact CSV structure Google requires.