Offline Conversion CSV Validator
Check required fields and common formats in a conversion CSV before you upload it.
CSV Format Requirements by Platform
These checks cover the CSV schemas shown below. Meta and TikTok API payloads are not CSV files: these examples need a compatible uploader or field mapping. Passing a local check cannot verify whether an identifier matches an ad interaction, whether an event is still eligible, or whether your account is configured correctly.
Google Ads
- Required:
Google Click ID(orEmail/Phonefor Enhanced Conversions),Conversion Name,Conversion Time,Conversion Value - Date format:
yyyy-MM-dd HH:mm:ss+zzzz(e.g.,2024-01-15 14:30:00-0500) - Enhanced Conversions: Email must be SHA-256 hashed, phone in E.164 + SHA-256
Meta (Facebook)
- Required:
event_name,event_time, at least one user identifier (em,ph) - Date format: Unix timestamp in seconds (not milliseconds)
- PII: All identifiers must be SHA-256 hashed
Microsoft Ads
- Required:
msclkid(oremail),conversion_name,conversion_time - Date format: ISO 8601 (e.g.,
2024-01-15T14:30:00-05:00)
TikTok
- Required:
event,timestamp, at least one identifier (ttclid,email,phone) - Date format: ISO 8601 or Unix timestamp
- PII: SHA-256 hashed
For ready-to-use templates with the columns already in place, see the offline conversion templates.
Frequently Asked Questions
This validator checks CSV files against the requirements for Google Ads offline conversions, Meta Conversions API (CAPI), Microsoft Ads offline conversions, and TikTok Events API. Each platform has specific required columns, date formats, and field validation rules.
No. Your CSV file is parsed entirely in your browser using the FileReader API. No data is sent to any server. The file never leaves your device.
This tool supports CSV files up to 5MB and 5,000 rows. For larger files, validate a representative sample — rows beyond that sample remain unchecked. For production uploads of any size, TUOCA validates and uploads automatically.
Google Ads requires dates in 'yyyy-MM-dd HH:mm:ss+zzzz' format (e.g., 2024-01-15 14:30:00-0500). Meta requires Unix timestamps in seconds (not milliseconds). Microsoft Ads uses ISO 8601. Check that your date format matches the selected platform's requirements.
Yes. The Upload Offline Conversions App validates every field before uploading — including date formats, click ID validity, PII hashing, and E.164 phone formatting. It also deduplicates records and filters expired click IDs automatically.