Definition
Import Wizard is a purpose-built Salesforce wizard designed to streamline the creation and management of particular features or processes. It combines an intuitive interface with powerful configuration options to help both technical and non-technical users accomplish their goals.
Real-World Example
At their company, the system admin at BrightEdge Solutions leverages Import Wizard to control how users interact with Salesforce data and features. After configuring Import Wizard in the sandbox and validating it with key stakeholders, they roll it out to production. User adoption improves because the interface now matches how teams actually work.
Why Import Wizard Matters
Import Wizard is Salesforce's built-in, point-and-click tool for importing records from CSV files into standard and custom objects. Accessible through Setup, it provides a guided, step-by-step interface that walks administrators through selecting the object, uploading the CSV file, mapping CSV columns to Salesforce fields, choosing duplicate matching rules, and executing the import. Import Wizard supports Accounts, Contacts, Leads, Solutions, and Custom Objects with imports up to 50,000 records at a time. Unlike Data Loader, which requires installation and technical knowledge, Import Wizard runs entirely in the browser and is designed for non-technical administrators who need a straightforward way to bring data into Salesforce.
As organizations grow, data import becomes a recurring operation for tasks like loading new leads from events, updating account information from third-party sources, and migrating data from other systems. Import Wizard's 50,000-record limit and browser-based interface make it ideal for small-to-medium imports, but larger operations require Data Loader, which handles millions of records. Organizations that skip Import Wizard's duplicate matching step often create thousands of duplicate records that pollute their database and require costly cleanup. Best practice includes always enabling duplicate matching during import, reviewing the first 100 records after import for accuracy, and using the Import Wizard's field mapping preview to verify that data lands in the correct fields before committing the full import.
How Organizations Use Import Wizard
- BrightEdge Solutions — BrightEdge Solutions uses Import Wizard to load 5,000 new leads after each quarterly trade show. The marketing coordinator uploads the CSV from the event scanning app, maps the fields, enables duplicate matching on email, and imports in under 15 minutes. Before Import Wizard, this process took 3 days of manual data entry with frequent errors.
- GreenField Agriculture — GreenField Agriculture's admin uses Import Wizard to quarterly update account records with crop yield data from their field management system. The CSV contains account names and updated yield figures, and Import Wizard's matching feature uses Account Name and external ID to update existing records rather than creating duplicates.
- StartUp Academy — StartUp Academy imports 2,000 student contact records at the start of each semester using Import Wizard. The admin maps CSV columns for Student Name, Email, Program, and Start Date to Salesforce Contact fields. The guided interface allows the admin, who has no technical background, to complete the import independently without developer assistance.