Start with critical issues
Critical issues usually indicate rows that may fail import or match poorly, such as missing identifiers, missing conversion names, invalid conversion times, or broken user data values.
Upload and preview CSV risk
CSV only · up to 10MB · browser-local validation.
Use an explicit workflow when your headers include both click IDs and user-provided data, or when hashing requirements differ between scheduled/pre-hashed and manual unhashed review.
No Google Ads login required. Your file stays in your browser.
Download fresh sample CSV files
Generated with relative dates so examples stay useful over time.
Preview will appear after validation.
The first result card will show the selected or inferred workflow, critical issues, warning count, rows without detected critical issues, and the report download action.
Independent local CSV preflight checker
Google Ads Offline Conversion CSV Checker
Upload a CSV locally in your browser to check headers, conversion time formats, GCLID, GBRAID, WBRAID, user-data hash risks, consent fields, conversion value, currency, duplicate rows, and common Google Ads import risks before previewing the file.
Browser-local processing: your CSV is not uploaded to our server. This independent tool focuses on CSV-level checks and does not verify Google Ads account settings, conversion ownership, or final import results.
Missing headers and duplicated columns
Invalid, future, date-only, or old conversion times
Plain-text email, suspicious phone, address hash, and SHA-256 issues
Empty click ID or user identifiers
Consent field and user-data hashing risks
Invalid ISO currency and value formatting
Duplicate conversion and Order ID risks
CSV upload preflight guide
Check common Google Ads offline conversion CSV problems before upload
This free checker is designed for advertisers, PPC operators, agencies, and local service teams that prepare offline conversion imports. It focuses on CSV-level risks that are easier to catch before opening Google Ads: missing columns, malformed rows, invalid conversion timestamps, weak identifiers, duplicate conversion records, consent values, ISO currency issues, and user data formatting issues.
What it checks
The checker scans the structure and values in your CSV, then groups findings by severity so you can fix the riskiest rows first.
- Missing, blank, or duplicated headers
- Broken row structure caused by commas or quotes
- Missing conversion names or conversion times
- Future, old, date-only, timezone-less, invalid timezone-ID, or unparseable conversion times
- Missing click IDs or user identifiers
- GCLID, GBRAID, WBRAID, and mixed-identifier workflow risks
- Plain-text email, phone, name, and street address risks for user-data review
- Invalid SHA-256 hash-like values
- Invalid consent values and ISO 4217 currency risks
- Duplicate conversion and Order ID risks
For a deeper troubleshooting walkthrough, read the Google Ads offline conversion upload error guide.
Supported columns
The tool auto-detects common Google Ads offline conversion, click-ID upload, and user-data preflight fields. Column names do not have to be perfect, but recognizable headers make the report more useful.
Google Click ID, GBRAID, and WBRAIDConversion NameConversion TimeConversion ValueConversion CurrencyOrder IDEmail, phone, and address-style user dataAd User Data and Ad Personalization consent fieldsSHA-256 hash-like user data fields
Use the offline conversion CSV template checklist to review required identifiers, conversion names, timestamps, values, currency codes, and Order IDs before import.
Workflow first
Choose the right CSV review path
The same CSV column can mean different things depending on the upload workflow. Pick the closest path before interpreting critical issues and warnings.
Click-ID upload
Use this path when rows contain GCLID, GBRAID, or WBRAID values and the file is intended for a click-based offline conversion import.
Enhanced conversions user data
Use this path when rows contain email, phone, name, street address, consent fields, or SHA-256 hash-like values for user-provided data review.
Template and upload readiness
Use this path when you need a final checklist for headers, conversion names, timestamps, values, currencies, Order IDs, and duplicate rows.
Methodology at a glance
The checker is intentionally scoped to file-level preflight validation. It does not score campaigns, connect to Google Ads, or make final attribution decisions.
- Step 1
Parse CSV structure locally in the browser
- Step 2
Apply the selected workflow rules
- Step 3
Flag row-level risks by severity
- Step 4
Export a fix-oriented issue report
How to read the results
Review warnings before previewing in Google Ads
Warnings can still matter for match quality and reporting accuracy. Check old click IDs, timezone-less timestamps, suspicious phone values, duplicate Order IDs, and unusual value or currency fields.
Download the report for row-level fixes
The issue report contains the row number, field, message, current value, and suggested fix. Use it as a working checklist before you preview the corrected file in Google Ads.
What it cannot verify
This checker does not connect to Google Ads, does not use OAuth, and does not call the Google Ads API. It cannot verify conversion action ownership, account-level settings, click ownership, MCC permissions, customer data terms, Data Manager schema rules, import preview status, or final attribution. Treat it as a local CSV smoke test, then preview the corrected file in Google Ads before applying the upload.
Official sources used
These links support the page boundary and the local checks described here. They are not copied into the checker as a complete Google Ads validator, and the checker should not be described as official Google guidance.
- Google Ads Help: Import conversions from ad clicks using files
Used for file-level timezone parameters, supported conversion time formats, file import boundaries, and scheduled upload hashing notes.
- Google Ads Help: Guidelines for importing offline conversions
Used for upload timing windows, old conversion review signals, and final Google Ads validation boundaries.
- Google Ads API sample: Upload offline conversion
Used for the exactly-one click identifier boundary in API-style click conversion rows.
- Google Ads Help: About enhanced conversions for leads
Used for the enhanced conversions for leads and Data Manager boundary.
- Google Ads Help: Download templates for conversion bulk uploads
Used for the template and file-format boundary. This checker focuses on CSV preflight and does not support every Google Ads template format.
FAQ preview
Common questions about privacy, scope, and enhanced conversions support.
Does the checker upload my CSV?
No. CSV parsing and validation happen locally in your browser. The checker does not upload your file to a server or store row-level conversion data.
Can it guarantee that Google Ads will accept my upload?
No. This is a CSV-level preflight checker. Google Ads can still reject or ignore rows because of account settings, conversion action ownership, click ownership, customer data terms, or attribution eligibility.
Does it support enhanced conversions for leads?
It can flag CSV-level user-data risks such as plain-text emails, suspicious phone values, address hashing issues, missing identifiers, invalid consent values, and broken SHA-256 hash-like values. It does not replace Google Ads Data Manager or final Google Ads preview validation.