Definition
Data Import Wizard is a built-in Salesforce Setup tool that provides a guided, step-by-step interface for importing data from CSV files into standard objects like Accounts, Contacts, Leads, and Solutions, as well as custom objects. It includes duplicate checking, field mapping, and the ability to trigger workflow rules and processes during import.
Real-World Example
A sales operations analyst at Summit Retail uses Data Import Wizard to import 5,000 new Lead records from a recently purchased contact list. The wizard walks her through uploading the CSV, mapping columns like "Company Name" to the Lead's Company field, selecting a duplicate matching rule, and choosing whether to insert new records or update existing ones.
Why Data Import Wizard Matters
Data Import Wizard is a built-in Salesforce tool accessible from Setup that provides a guided, step-by-step interface for importing records from CSV files. It supports standard objects (Accounts, Contacts, Leads, Solutions, Campaign Members) and custom objects. The wizard walks users through uploading a CSV file, mapping CSV columns to Salesforce fields, selecting duplicate matching rules, and choosing whether to insert new records, update existing records, or upsert (insert and update simultaneously). It also offers options to trigger workflow rules and processes during import and can handle up to 50,000 records per import operation.
Data Import Wizard is the recommended tool for small-to-medium data loads that don't require the complexity of Data Loader or third-party ETL tools. It is particularly valuable because of its built-in duplicate checking: before importing, administrators can select a matching rule (based on email, name, or custom criteria) to prevent creating duplicate records. This is critical during lead list imports, data migration from other CRMs, and periodic data enrichment activities. Without duplicate checking, imports can pollute the database with thousands of duplicate Accounts and Contacts that erode data quality and confuse sales reps. For imports exceeding 50,000 records or requiring complex field transformations, Data Loader is the better choice. But for everyday import tasks, the wizard's guided interface and built-in safeguards make it the go-to tool.
How Organizations Use Data Import Wizard
- Summit Retail — Summit Retail's sales operations analyst uses Data Import Wizard to import 5,000 new Lead records from a purchased contact list. The wizard maps the CSV's "Company Name" column to the Lead Company field, "Email" to Lead Email, and enables the Standard Lead Duplicate Rule to prevent importing contacts already in the system. The import finishes in 15 minutes with 4,850 new records created and 150 duplicates flagged.
- Cascade Consulting — Cascade Consulting's admin uses Data Import Wizard monthly to import campaign response data. After each webinar, marketing exports the attendee list as a CSV and the admin imports it as Campaign Members, mapping the email field for matching against existing Contacts. The wizard's upsert capability updates existing Contacts with the latest webinar attendance while creating new Contact records for first-time attendees.
- Riverstone Education — Riverstone Education migrated 8,000 student records from a legacy Access database to their custom Student__c object using Data Import Wizard. The admin exported the Access data as CSV, mapped the columns to custom fields, and used the wizard's insert mode. The guided interface made it possible for a non-technical admin to complete the migration without developer involvement.