Offline Conversion Import Builder

1. Add your leads that became sales

Drop your CRM or sheet export here, or choose a file CSV or TSV with the GCLID each lead came with, the sale date and time, and the value if you have it.

Or paste rows from a spreadsheet

Copy the rows with their header row from Excel or Google Sheets.

Runs in your browser. Your file is not uploaded, and we never sign in to Google Ads.

2. Your conversion action

Conversion action name

Exactly as in Google Ads, same capitals. Used for every row without one.

File layout

Data Manager Upload template (legacy)

Time zone of the times in your file

Dates like 04/10/2026 mean

Click-through conversion window (days)

From the action's settings; Google allows 1 to 90. Checked when you map a click time.

Value for rows without one

Optional. Leave blank to send no value.

Currency

ISO code, used where a row has none.

3. Check the columns

We matched your column names. Change any that are wrong.

GCLID (Google Click ID)

The click ID your form saved with the lead.

GBRAID

Optional. iOS app click ID. Data Manager layout only.

WBRAID

Optional. iOS web click ID. Data Manager layout only.

Conversion time

When the sale or booking happened.

Click or enquiry time

Optional. Checks sales dated before the click.

Conversion value

Optional. ₹2,50,000 or 2.5 lakh are fine.

Currency

Optional. Otherwise the default in step 2.

Order ID

Optional. A booking or invoice number, one per sale.

Conversion action name

Optional. Otherwise the name in step 2.

Lead name

For the preview only, never exported.

Only include rows where

is one of

Choose a column to upload only some rows, such as leads marked Won or Booking done.

Your upload file appears here

Add an export or try the example: bookings for Sunrise Nest Homes, a made-up developer in Wakad, Pune, with a few broken rows.

Free Offline Conversion Import Builder. Runs in your browser, no sign-up. Open the full tool on DigitalSnot →