Data Import Wizard
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.
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.
In plain English
“Here's a simple way to think about it: Data Import Wizard is the friendly CSV importer for everyday admin work. Upload a file, map columns to fields, choose how to handle duplicates, run the import. For under 50,000 records into a standard or custom object, this is almost always the right tool.”
Worked 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 the Data Import Wizard is still the best tool for everyday admin imports
For one-off imports of a few thousand records into a standard or custom object - a list of new accounts from an event, a batch of cases from a vendor, an updated contact roster - the Data Import Wizard is almost always the right answer. It's in Setup, no install required. It handles duplicates with built-in matching rules. It can choose to fire workflow rules and processes, or skip them entirely. It tells you exactly what worked and what didn't with downloadable success and error files.
The reason admins still reach past it for Data Loader is volume and operations: anything over 50,000 records, anything that needs to run on a schedule, anything that needs the command line. Inside that boundary the wizard is faster, safer, and closer to the records being imported. Default to it, and reach for the heavier tools only when the wizard's limits actually pinch.
How to set up Data Import Wizard
Data Import Wizard is Salesforce's in-app, browser-based bulk data tool — for loads up to 50,000 rows. Simpler than Data Loader, no installation, friendly column-mapping UI. The right tool when you don't need the full power (or risk) of Data Loader.
- Open Setup → Data Import Wizard
Setup gear → Quick Find: Data Import Wizard → Data Import Wizard. Click Launch Wizard.
- Pick the Object Type
Standard Objects (Accounts/Contacts/Leads, Solutions, Person Accounts, Campaign Members) or Custom Objects (any custom object you have access to). Note: Opportunities and several other standards are NOT supported — use Data Loader.
- Pick the Action
Add new records / Update existing records / Add new and update existing records. Update and Upsert require a match field (Salesforce ID, External ID, Email, or Name).
- Drop the CSV file
Drag-and-drop or click to browse. Wizard parses it and shows the column list.
- Map columns
Wizard auto-suggests mappings based on header names. Review each row and hand-correct mismatches. Skip columns you don't want.
- Tick Trigger Workflow Rules / Trigger Assignment Rules
When ticked, your active workflow rules and assignment rules fire on each imported row. Often what you want — but can be slow on big imports.
- Click Start Import
Wizard kicks off the import job. You'll get an email when it finishes with a results CSV showing successes and errors.
Account/Contact/Lead/Solution/Custom — limited to a specific list. No Opportunity or Order via this wizard.
Add new / Update existing / Upsert. Upsert needs a match field.
Salesforce ID / External ID / Email / Name. External ID is the most reliable.
When ticked, Workflows fire on imported rows. Disable for clean bulk loads.
When ticked, Lead/Case Assignment Rules fire. Useful when importing fresh leads.
When ticked, Lead/Case Auto-Response Rules fire emails.
- 50,000 record limit per import. Beyond that you need Data Loader (for Bulk API) or a custom integration. Splitting a 100k load into two 50k jobs works but doubles admin time.
- Doesn't support Opportunities, Orders, Contracts, and several other standard objects. For those, use Data Loader or REST API.
- Trigger toggles are off by default. If your import skips workflow that should fire on each new record, the wizard didn't run them — re-import with the toggle on or run a separate Flow afterward.
How organizations use Data Import Wizard
Marketing imports trade-show contacts from event-vendor CSVs each week - the wizard's duplicate matching catches existing leads automatically.
Customer-success teams update Account renewal dates from quarterly CSV exports without involving developer time.
Patient-engagement coordinators import call-list segments using the wizard; the workflow is documented well enough that operations runs it without admin help.
Trust & references
Straight from the source - Salesforce's reference material on Data Import Wizard.
- Data Import WizardSalesforce Help
- Import Data with the Data Import WizardSalesforce Help
Test your knowledge
Q1. Why is understanding Data Import Wizard important for Salesforce admins?
Q2. Can a Salesforce admin configure Data Import Wizard without writing code?
Q3. What is the primary benefit of Data Import Wizard for Salesforce administrators?
Discussion
Loading discussion…