Free tool

Google Ads Offline Conversion Import Template

Paste rows from your CRM with the Google Click ID (GCLID), conversion name, date and time, value and currency: the tool checks each row and builds the import file in the Google Ads template format, with its Parameters:TimeZone row. Copy it or download it as CSV, and rejected rows stay listed with their reason.

In Google Ads, the file for importing conversions from clicks uses the headers Google Click ID, Conversion Name, Conversion Time, Conversion Value and Conversion Currency, with a “Parameters:TimeZone” row for the time zone. Google only keeps the GCLID for 90 days, and now recommends Google Ads Data Manager: file import is listed as a legacy process.

Fictitious example

Order of slash dates
A date such as 11/03/2026 reads two ways: pick your CRM’s order, the tool never guesses it. An ISO date (2026-11-03 14:30) reads without this choice.
Time zone in the file
Valid rows, in the file
Rejected rows
Show
Check of each pasted row
RowStatusGoogle Click IDConversion NameConversion TimeConversion ValueConversion CurrencyReason

Before you upload, wait 4 to 6 hours after creating the conversion action: an earlier upload can take up to 2 days to show. Processing then takes 24 to 48 hours. Google only keeps the GCLID for 90 days, so the tool rejects a conversion more than 90 days old. The action’s conversion window, from 1 to 90 days, counts from the click, which is not in the file: check it in your CRM. In Google Ads: Goals, Conversions, Uploads.

Google presents file import as a legacy process and recommends Google Ads Data Manager. Enhanced conversions for leads, which relies on hashed data such as email addresses, only supports Data Manager files. To hash a list: SHA-256 hash generator.

Sources read on November 6, 2026: Google Ads Help, import conversions using files, Google Ads Help, offline conversions using GCLID, Google Ads Help, import errors, Google Ads Help, conversion windows, Google Ads Help, enhanced conversions for leads and Google Ads API, upload click conversions.

Do Your Offline Sales Show Up In Google Ads?

With Google Tag Manager, I pass the GCLID from your forms to your CRM, then set up the import of your offline sales and check they land on the right clicks.

20 minutes · No commitment · 100% confidential

Step 1 Of 2 · Your Project

Step 2 Of 2 · Your Details

Who are these campaigns for? *
What are you looking for in our collaboration? * You can pick several
Where do your ad campaigns stand today? *
When would you ideally like to start? *

How the tool builds the file

11/03/2026 2:30 PM + Europe/Paris → 2026-11-03 14:30:00, or 2026-11-03 14:30:00+0100

The tool recognizes your CRM columns in English, French and Spanish, along with the Google template headers: Google Click ID, Conversion Name, Conversion Time, Conversion Value, Conversion Currency. A date and a time in separate columns are joined. A slash date reads in the order you pick, mm/dd/yyyy or dd/mm/yyyy; an ISO date, or a date that already carries its offset (+01:00), reads as is.

Example: your CRM logs “11/03/2026 2:30 PM” in Paris. With the Parameters:TimeZone=Europe/Paris row, the file writes 2026-11-03 14:30:00. In “in each date” mode, the same conversion becomes 2026-11-03 14:30:00+0100, and a conversion on 08/10/2026 at 9:00 AM becomes 2026-08-10 09:00:00+0200, daylight saving time included. The value “1,234.50” becomes 1234.50, and the currency “usd” becomes USD.

Every row goes through the same checks: click ID present with no spaces (the GCLID is case sensitive, so the tool copies it as is), conversion name present, readable date, neither in the future nor more than 90 days old, value in digits, currency as a 3-letter code. Two rows with the same ID, name and time make a duplicate: Google does not count duplicate conversions, and the tool keeps the first one. The file only takes valid rows; the others stay in the table with their reason.

What the template gives you

  • Measure sales closed offline: a quote signed over the phone or an in-store sale shows up in Google Ads, tied to the click that brought it in. You see which campaigns bring in customers, beyond form fills.
  • Build a clean file the first time: dates, time zones, decimals and duplicates are checked before the upload. You fix your CRM before Google’s 24 to 48 hours of processing.
  • Check an export before you send it: paste your CRM export, show the rejected rows and spot empty GCLIDs or out-of-range dates at once. You know which CRM records to complete.

Frequently asked questions

What format does Google Ads expect?

A first row that sets the time zone, Parameters:TimeZone=America/New_York or an offset such as -0500, with no quotes, then the headers Google Click ID, Conversion Name, Conversion Time, Conversion Value and Conversion Currency. Value and currency are optional: an empty value takes the one defined in the conversion action, and the currency follows the 3-letter ISO 4217 code. The conversion name matches the action in Google Ads exactly, spelling and capitalization included.

When should I upload my conversions?

Wait 4 to 6 hours after creating the conversion action before the first upload. A conversion uploaded within one day of its click may not be recorded yet: Google suggests adding an extra day of data to each upload. The GCLID is kept for 90 days, and the action’s conversion window, from 1 to 90 days, counts from the click: upload regularly to stay within these limits.

I have no GCLID: what can I do?

To store the GCLID, Google describes a hidden field added to each form, filled from the page URL thanks to auto-tagging, then saved in your CRM with the lead. Enhanced conversions for leads relies instead on user-provided data such as email addresses, hashed with SHA-256, and goes through Google Ads Data Manager. To hash a list in your browser: SHA-256 hash generator.

Are my conversions sent anywhere?

No. The checks and the file are built in your browser: nothing is sent or stored, and your rows are gone when you close the page. The downloaded file stays on your device.

Théo Maupilé

Growth partner

Positioning, acquisition, innovation: together we build a lasting growth system.

Théo MaupiléFreelance Paid Media

Google PartnerSuperMalter

◉ Certifications

Official Google Partner
& SuperMalter