Salesforce Leads Export Sample CSV (Dirty + Clean)
A production-realistic Salesforce lead export (6,200 rows) engineered to expose validation errors that crash Data Loader bulk imports. The Salesforce quirk: strict validation on restricted picklists like LeadSource means even a single invisible character triggers INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST errors. The 'dirty' version includes LeadSource values with zero-width spaces (U+200B) invisible in Excel, malformed 15-character Lead IDs missing the checksum suffix (causing upsert failures), and embedded commas in company names breaking CSV parsing. Perfect for testing API integrations, Data Loader workflows, and Marketing Automation migrations. Process everything locally — your lead data never touches a server.
Live Interactive Preview
Live Data Preview
See how this messy salesforce data looks before downloading. All processing happens locally in your browser.
💡 Pro Tip: Data Loader batch failed with INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST? The cause is a zero-width space you can't see in Excel. Strip invisible Unicode characters locally with Format Cleaner in 3 seconds.
⚡ Next Step: Not sure if your Lead IDs are 15-char or 18-char? Validate the entire file with CSV Schema Validator to catch malformed IDs before corrupting your Salesforce instance.
Data Schema Definition
| Column | Type | Description |
|---|---|---|
| Id | string | ⚠️ CRITICAL: 15-char case-sensitive OR 18-char case-safe ID. Upsert fails if length inconsistent. Convert all to 18-char before import. |
| FirstName | string | Lead first name. Optional but recommended for personalization; max 40 chars enforced by SFDC. |
| LastName | string | Required field. Cannot be null or empty string; Data Loader rejects entire batch if violated. |
| Company | string | ⚠️ TRAP: Often contains embedded commas ('Apple, Inc.') requiring RFC 4180 quoting. Unquoted = split into two columns. |
| string | Standard email. SFDC enforces uniqueness per org; duplicates cause PARTIAL_SUCCESS in bulk API. | |
| LeadSource | string | ⚠️ TRAP: Restricted picklist. Zero-width spaces (U+200B) and trailing whitespace cause INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST. Invisible in Excel. |
| Industry | string | Standard picklist. Values must match org metadata exactly; API names differ from labels. |
| Phone | string | Free-format phone. SFDC does not enforce E.164; normalize before CTI/dialer integration. |
| Rating | string | Picklist: Hot | Warm | Cold. Legacy values from imports may exist outside current picklist definition. |
| AnnualRevenue | decimal | Currency field. Stored as decimal without currency code; assumes org default currency for multi-currency orgs. |
⚠️ Highlighted rows contain known data traps. Review descriptions before building ETL pipelines.