Enhanced Conversions for Leads: CSV Formatter
Turn a CRM export into a hashed enhanced conversions for leads upload file, in your browser.
- Free to use
- Runs in your browser
- No sign-up
Your data never leaves your browser. The file is read on this page, and emails and phone numbers are normalised and hashed with SHA-256 before you download anything. Nothing is sent to DigitalSnot or anyone else.
Embed this tool on your websiteFree. Paste one code; it runs in your visitors' browsers.
Copy this code into a page of your site. The tool sets no cookies and sends nothing your visitors type to us. Change height="760" if it needs more room.
About the Enhanced Conversions for Leads CSV Formatter
Upload a lead or deal export from your CRM and get a file ready for Google Ads: emails and phone numbers normalised to Google's rules, +91 added to Indian numbers, everything hashed with SHA-256, and times in the format Google expects. A validation report shows the rows that would fail, from bad numbers to conversions older than Google's import window. Your file never leaves your browser.
How it works
-
Step 1
Drop in a CSV or tab-separated export from your CRM, or press "Try an example" to see how it works.
-
Step 2
Check the matched columns, type the conversion action name, and choose the time zone and the Data Manager or upload template layout.
-
Step 3
Fix what the validation report flags, check the masked preview, then download the hashed upload file.
How the data is prepared
Following Google's formatting rules, emails are trimmed and lowercased, and Gmail addresses lose the dots and any +tag before the @. Phone numbers become E.164, such as +919822012345. Each value is then hashed with SHA-256 in your browser, using its built-in Web Crypto API, so the download holds hashes rather than contact details.
Data Manager or the upload template
Google moved enhanced conversions for leads files to Google Ads Data Manager, and from 15 June 2026 new API integrations for offline conversions must use the Data Manager API. Choose the Data Manager layout for a file with one header row that you map when uploading, or the upload template layout, which adds the Parameters:TimeZone row used in Goals > Uploads.
What it does not do
It does not upload anything to Google Ads, check that your conversion action exists, or know which leads clicked an ad, so match rates depend on Google. It cannot recover phone numbers that Excel has already turned into scientific notation. Google imports these conversions only within 63 days of the click (90 days with a GCLID), so upload often.
Frequently asked questions
What are enhanced conversions for leads?
A way to count leads that turn into sales offline. Your website tag sends a hashed email or phone number when someone fills in a form; later you upload the same hashed details for the leads that became customers, and Google matches them to ad clicks. Google recommends it as the upgrade from offline imports that rely on the GCLID.
Do I need to hash the data before uploading?
For scheduled uploads, yes: Google requires emails and phone numbers to be normalised and hashed with SHA-256. For a one-off manual upload Google can hash unhashed data for you, but hashing first means readable contact details never leave your computer. This tool hashes everything in your browser before you download the file.
How should phone numbers be formatted for Google Ads?
In E.164 format: a plus sign, the country code and the number, with no spaces, dashes or brackets. An Indian mobile written as 098220 12345 or 98220-12345 becomes +919822012345. The tool adds +91 to 10-digit numbers and drops a leading 0, and flags numbers with missing digits or ones that Excel turned into scientific notation.
How old can conversions be when I upload them?
Google does not import enhanced conversions for leads uploaded more than 63 days after the ad click, or click (GCLID) conversions after 90 days. Because the click came before the lead converted, a 50-day-old conversion may already be close to the limit. Upload at least weekly: the tool skips rows past the window and warns about rows near it.
Is it safe to put customer data into this tool?
The file is read and hashed by JavaScript on this page, and nothing is sent to DigitalSnot or any other server. The preview masks emails and phone numbers, and the download holds only SHA-256 hashes plus the conversion details. Treat the original CRM export with the same care as before, and follow your own data protection policy.
Related reading
Want help with your Google Ads?
Tell us about your account and what your ads should bring in. We reply within one business day.
Talk to us Our service: Google Ads managementMore Google Ads tools
All Google Ads tools- Google Ads Tag and Consent Checker Check the Google tag, Tag Manager, conversion events and Consent Mode v2 on any page.
- Merchant Center Feed Checker Check a product feed for missing attributes, wrong formats, bad GTINs and duplicates before you upload it.
- Google Ads Link Checker Check the final URLs in your ads, sitelinks and keywords for 404s, bad redirects and slow pages.
- Offline Conversion Import Builder Turn leads that became sales into a Google Ads offline conversion file, with checks on every row.
Want us to fix what the tool found?
Tell us about your business and what you want to grow. We reply within one business day with next steps, not a sales script.
- A reply within one business day
- A quick look at your site and search visibility before we talk
- Your details are only used to answer your enquiry