Every Salesforce administrator and developer faces the same critical question when managing data: should I use the Data Import Wizard or Data Loader? This decision impacts everything from import speed and data quality to workflow efficiency and long-term data management strategy. Making the wrong choice can lead to failed imports, data corruption, and countless wasted hours troubleshooting issues.
This comprehensive guide breaks down exactly when to use Data Import Wizard vs Data Loader, complete with practical examples, decision frameworks, and step-by-step instructions to help you master both tools and choose the right one for every scenario.
Before diving into the comparison, let’s establish exactly what these tools are and why Salesforce provides multiple options for data management.
If you’re still building your foundational understanding of how Salesforce stores and structures data, the Database and Objects in Salesforce guide is invaluable. It clarifies how records, fields, relationships, and metadata work—knowledge that directly impacts how successful your import operations will be.
What is the Salesforce Data Import Wizard?
The Salesforce Data Import Wizard is a browser-based tool built directly into Salesforce that simplifies importing data without requiring any software installation. Located in Setup under Data Import Wizard, it provides a guided, step-by-step interface that walks users through the entire import process.
Key characteristics:
- Web-based interface accessible from any browser
- No installation or configuration required
- Wizard-style guided process with clear instructions
- Built-in duplicate detection capabilities
- Automatic field mapping suggestions
- Real-time validation and error reporting
Access method:
Navigate to Setup → Data → Data Import Wizard
The Data Import Wizard is designed for Salesforce administrators and business users who need a straightforward way to import smaller datasets without technical complexity. Its intuitive interface makes data imports accessible to users regardless of their technical skill level.
What is the Salesforce Data Loader?
The Salesforce Data Loader is a client application that you download and install on your computer. It’s a more powerful tool designed for bulk operations, offering both a graphical user interface (GUI) and command-line interface (CLI) for advanced automation.
If you’re new to Data Loader and need help installing or configuring it correctly, The Ultimate Guide to Install Data Loader in Salesforce walks you through every step—from downloading the installer to configuring API settings. This ensures you avoid common setup issues and can start running bulk data operations quickly.
Key characteristics:
- Desktop application requiring installation
- Supports bulk operations up to 5 million records
- Command-line interface for automation and scheduling
- Advanced mapping capabilities
- Comprehensive logging and error tracking
- Export and delete functionality
The Data Loader is the tool of choice for Salesforce developers, administrators handling large datasets, and organizations requiring automated data integration workflows. Its power and flexibility come with increased complexity compared to the Data Import Wizard.
Developers who frequently work with Data Loader often also manipulate data through Apex. The How to Access Salesforce Data Model via Apex? guide shows how to programmatically query and interact with object schemas, making it easier to validate imports or automate data transformation.
Data Import Wizard vs Data Loader: Comprehensive Comparison
Let’s examine the critical differences between these two tools across multiple dimensions:
Feature Comparison Table
| Feature | Data Import Wizard | Data Loader |
|---|---|---|
| Maximum Records | 50,000 records per import | 5,000,000 records per operation |
| Installation Required | No (browser-based) | Yes (desktop application) |
| Supported Objects | Limited (Accounts, Contacts, Leads, Solutions, Campaign Members, Person Accounts, Custom Objects) | All standard and custom objects |
| Operations | Insert, Update, Upsert | Insert, Update, Upsert, Delete, Hard Delete, Export, Export All |
| Duplicate Detection | Built-in duplicate checking | Manual mapping required |
| Field Mapping | Automatic suggestions | Manual mapping with save capability |
| Scheduling | No | Yes (via command line) |
| API Required | No | Yes (Professional Edition requires API access add-on) |
| Relationship Handling | Limited (must use external IDs) | Advanced (supports relationship fields) |
| Error Handling | In-browser notification | CSV error logs |
| Learning Curve | Low (beginner-friendly) | Medium to High |
| Data Export | No | Yes |
| Automation Capability | No | Yes (batch files and scheduled jobs) |
| Multi-Step Operations | No | Yes |
| Hard Delete | No | Yes |
| Opportunity Import | No (except Essentials Edition) | Yes |
| Case Import | No | Yes |
Operation Support Comparison
Data Import Wizard Operations:
- Insert: Add new records to Salesforce
- Update: Modify existing records using record ID or external ID
- Upsert: Update existing records or insert new ones based on matching criteria
Data Loader Operations:
If you want a deeper understanding of how exports work and when to use tools like Data Loader versus Salesforce’s native export services, the Data Export in Salesforce guide gives a detailed breakdown. It’s especially useful for teams handling compliance, backups, or large-scale reporting needs.
- Insert: Add new records
- Update: Modify existing records
- Upsert: Combined insert and update
- Delete: Move records to Recycle Bin
- Hard Delete: Permanently remove records (bypass Recycle Bin)
- Export: Extract data from Salesforce to CSV
- Export All: Extract all records including those in Recycle Bin and archived data
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Record Volume Capabilities
If you’re preparing for a full-scale migration, the 4 Important Terms You Need to Remember During Data Migration in Salesforce guide breaks down crucial concepts like external IDs, upserts, batch processing, and data hierarchy—helping you avoid costly mistakes during high-volume imports.
Data Import Wizard:
- Maximum: 50,000 records per import
- Best for: Small to medium datasets
- Processing speed: Moderate (web-based processing)
- Multiple file handling: Must import separately
Data Loader:
- Maximum: 5,000,000 records per operation
- Best for: Large enterprise datasets
- Processing speed: Fast (local processing with batch API)
- Multiple file handling: Can process sequential batches
Object Support Differences
For admins and developers designing scalable data structures, understanding how objects and relationships impact imports is essential. The Data Modeling in Salesforce guide dives deep into lookup relationships, master-detail structure, and schema design—knowledge that helps prevent import failures caused by poor data architecture.
Data Import Wizard Supported Objects:
- Standard Objects: Accounts, Contacts, Leads, Solutions, Person Accounts (if enabled)
- Limited Standard Objects: Campaign Members
- Custom Objects: All custom objects
- NOT Supported: Opportunities (except Essentials Edition), Cases, most standard objects
Data Loader Supported Objects:
- All standard objects including Opportunities, Cases, Tasks, Events
- All custom objects
- Junction objects
- External objects (with limitations)
- Standard and custom metadata
When to Use Data Import Wizard: Practical Scenarios
The Data Import Wizard excels in specific situations. Here’s when you should choose it:
Scenario 1: Small Lead Imports from Marketing Campaigns
Situation: Your marketing team ran a webinar and collected 500 new leads that need to be imported into Salesforce.
Why Data Import Wizard:
- Under 50,000 record limit
- Simple lead data structure
- Built-in duplicate checking prevents duplicate leads
- Can assign lead source and owner rules during import
- Team members don’t need technical training
Step-by-step Process:
- Export lead data from webinar platform to CSV
- Navigate to Setup → Data Import Wizard
- Select “Leads”
- Choose “Add new records”
- Map fields (Email, First Name, Last Name, Company, Title)
- Enable duplicate checking on Email
- Select Lead Assignment Rules
- Specify Lead Source
- Review and start import
Scenario 2: Updating Contact Information
Situation: You need to update mailing addresses for 5,000 existing contacts after a company relocation.
If your integration needs go beyond simple scheduled imports, you may benefit from real-time synchronization using external objects. The Integrating External Application / External Data into Salesforce using Heroku External Objects and Heroku Postgres Add-on guide explains how to connect external databases directly to Salesforce, reducing the need for repetitive imports entirely.
Why Data Import Wizard:
- Straightforward update operation
- Moderate record count
- Simple field mapping
- Minimal risk of data corruption
- No complex relationships involved
Scenario 3: Campaign Member Management
Situation: You want to add 1,200 contacts to a specific marketing campaign.
Why Data Import Wizard:
- Direct Campaign Member import capability
- Can access directly from Campaign record page
- Simple mapping of Contact ID to Campaign
- Campaign-specific import wizard available
Scenario 4: Initial Custom Object Population
Situation: You’ve just created a custom object for tracking product warranties and need to import initial data.
Why Data Import Wizard:
- Custom objects fully supported
- First-time import requires careful validation
- Built-in error reporting helps identify data issues
- No need for complex field relationships
Scenario 5: Ad-Hoc Business User Imports
Situation: Sales managers occasionally need to import prospect lists without IT involvement.
Why Data Import Wizard:
- No technical skills required
- No software installation needed
- Accessible from any browser
- Clear guided process
- Immediate feedback on success/failure
When to Use Data Loader: Practical Scenarios
Data Loader becomes essential when you need power, flexibility, or automation. Here’s when to choose it:
Scenario 1: Large-Scale Data Migration
Situation: You’re migrating from a legacy CRM system with 500,000 accounts, 1.2 million contacts, and 3 million opportunities.
Why Data Loader:
- Handles millions of records per operation
- Supports all objects including Opportunities
- Can schedule sequential imports
- Command-line interface for automation
- Comprehensive error logging
Approach:
- Export data from legacy system
- Transform data to match Salesforce structure
- Import in sequence (Accounts → Contacts → Opportunities)
- Use external IDs for relationship mapping
- Validate and fix errors from logs
- Perform data quality checks
Scenario 2: Automated Daily Integration
Situation: Your ERP system needs to sync customer data to Salesforce every night.
Why Data Loader:
- Command-line interface enables automation
- Can schedule with Windows Task Scheduler or cron jobs
- Batch file processing
- Email notifications on completion
- Handles errors gracefully without manual intervention
Automation Setup:
@echo off
REM Data Loader Automation Script
cd C:\DataLoader\bin
REM Run Data Loader process
process.bat ..\conf\AccountUpdate.sdl
REM Check for errors and send email if needed
IF %ERRORLEVEL% NEQ 0 (
echo Data Loader failed | mailx -s "Data Loader Error" [email protected]
)
Scenario 3: Mass Record Deletion
Situation: You need to delete 100,000 old opportunity records that are no longer relevant.
Why Data Loader:
- Delete and Hard Delete operations not available in Data Import Wizard
- Can handle large deletion volumes
- Hard Delete bypasses Recycle Bin for permanent removal
- Logging captures which records were deleted
Scenario 4: Complex Data Export Requirements
Situation: You need to export all opportunity data including archived records for compliance reporting.
Why Data Loader:
- Export and Export All operations
- Can include archived and soft-deleted records
- SOQL query builder for complex filters
- Scheduled exports for regular reporting
- Can export relationship data
Scenario 5: Working with Cases and Opportunities
Situation: You need to import 25,000 support cases with related records.
Why Data Loader:
- Cases not supported by Data Import Wizard
- Can handle complex parent-child relationships
- Supports Case-specific fields and picklists
- Better error handling for complex structures
Scenario 6: Multi-Step Complex Imports
Situation: Importing accounts with related contacts, opportunities, and custom objects in a specific sequence.
Why Data Loader:
- Can save mapping files for reuse
- Sequential processing with external ID references
- Better control over relationship creation
- Detailed logging for multi-step validation
Step-by-Step Guide: Using Data Import Wizard
Let’s walk through a complete Data Import Wizard process for importing new leads.
Prerequisites
- CSV file prepared with lead data
- Column headers matching or close to Salesforce field names
- Clean data with consistent formatting
- Salesforce login with appropriate permissions
Step 1: Prepare Your Data File
First Name,Last Name,Company,Title,Email,Best practices for CSV preparation:
- Use consistent date formats (YYYY-MM-DD)
- Ensure picklist values match exactly (case-sensitive)
- Remove special characters that might cause encoding issues
- Validate email addresses
- Keep file under 50MB
Step 2: Access Data Import Wizard
- Log into Salesforce
- Click the Setup gear icon (top right)
- In Quick Find box, type “Data Import Wizard”
- Click Data Import Wizard under Data
Step 3: Choose Your Import Type
-
Select Leads (or your target object)
-
Choose the operation:
- Add new records: For new leads
- Update existing records: To modify existing leads
- Add new and update existing records: Upsert operation
-
Select matching criteria if using update or upsert:
- Salesforce ID
- External ID field
Step 4: Upload Your File
- Click Choose File and select your CSV
- Select character encoding (usually UTF-8)
- Click Next
Step 5: Map Your Fields
The wizard automatically suggests field mappings:
- Review each mapped field
- Manually map any unmapped fields by dragging and dropping
- Leave irrelevant fields unmapped
- Pay attention to required fields (marked with asterisk)
Common field mappings for Leads:
- First Name → First Name
- Last Name → Last Name
- Company → Company
- Email → Email
- Phone → Phone
- Lead Source → Lead Source
Step 6: Configure Import Settings
Duplicate checking:
- Check “Use matching to identify duplicate records”
- Select matching criteria (typically Email for leads)
- Choose whether to skip or update duplicates
Additional settings:
- Trigger workflow rules: Check if you want automation to run
- Lead assignment rules: Select if you want lead assignment
- Lead source: Set a default lead source if not in CSV
Step 7: Review and Start Import
-
Review the summary:
- Number of records to be imported
- Field mappings
- Import settings
-
Click Start Import
-
You’ll receive an email when the import completes
Step 8: Validate Import Results
-
Check the email notification for:
- Number of successful imports
- Number of failed records
- Link to error file (if any failures)
-
Download error file and fix issues
-
Re-import failed records after corrections
Troubleshooting Common Import Wizard Issues
Issue: Field mapping not saving
- Solution: Ensure field API names match; manually select unmapped fields
Issue: Duplicate records still being created
- Solution: Verify matching criteria selected; check data has matching values
Issue: Picklist values failing
- Solution: Ensure exact match including case; check picklist contains all values
Issue: Date format errors
- Solution: Use YYYY-MM-DD format; avoid locale-specific formats
Step-by-Step Guide: Using Data Loader
Now let’s walk through using Data Loader for a bulk account import.
Prerequisites
- Data Loader installed (download from Setup → Data Loader)
- API access enabled (check with administrator)
- Security token (received via email when password reset)
- CSV file prepared with clean data
Step 1: Install and Launch Data Loader
Windows Installation:
- Download installer from Salesforce
- Run .exe file
- Follow installation wizard
- Launch Data Loader from Start Menu
Mac Installation:
- Download .dmg file
- Drag application to Applications folder
- Launch Data Loader
Step 2: Log Into Salesforce
-
Click Settings in Data Loader
-
Configure:
- Server Host: login.salesforce.com (or test.salesforce.com for sandbox)
- Reset URL on login: Checked
- Remember password: Optional
-
Return to main screen
-
Click operation (e.g., Insert)
-
Enter credentials:
- Username:Â [email protected]
- Password: YourPasswordPlusSecurityToken
- Example: If password is “Pass123” and token is “ABC789”, enter “Pass123ABC789”
Step 3: Select Operation and Object
-
Choose operation:
- Insert for new records
- Update for existing records
- Upsert for both
-
Select object:Â Account
-
Click Next
Step 4: Choose Data File
- Click Browse and select your CSV file
- Verify the data preview
- Click Next
Step 5: Map Fields
For first-time imports:
- Click Create or Edit a Map
- Drag CSV columns to Salesforce fields
- Click OK
- Click Save Mapping to reuse later
For repeat imports:
- Click Choose Existing Map
- Select saved mapping file (.sdl)
Essential field mappings for Accounts:
- Account Name → Name (Required)
- Billing Street → BillingStreet
- Billing City → BillingCity
- Phone → Phone
- Website → Website
- Annual Revenue → AnnualRevenue
Step 6: Configure Settings and Start
-
Choose output directory for:
- Success file (successfully processed records)
- Error file (failed records)
-
Click Finish
-
Click Yes to start the operation
Step 7: Monitor Progress
- Progress bar shows completion status
- Success count increments in real-time
- Any errors are logged immediately
Step 8: Review Results
-
Check success file for:
- Salesforce IDs of created records
- Confirmation of all field values
-
Check error file for:
- Records that failed
- Error messages and codes
- Fields that caused errors
-
Fix errors and re-process failed records
Decision Framework: Which Tool Should You Use?
Use this decision tree to quickly determine the right tool for your needs:
Quick Decision Checklist
Use Data Import Wizard if:
- [ ] Importing fewer than 50,000 records
- [ ] Working with Accounts, Contacts, Leads, or Custom Objects
- [ ] You need duplicate checking during import
- [ ] User has limited technical experience
- [ ] No software installation allowed on your computer
- [ ] One-time or occasional import
- [ ] Don’t need to export data
Use Data Loader if:
- [ ] Importing more than 50,000 records
- [ ] Working with Opportunities, Cases, or most standard objects
- [ ] Need to delete or hard delete records
- [ ] Need to export data from Salesforce
- [ ] Require scheduled/automated imports
- [ ] Complex field mappings or relationships
- [ ] Need detailed error logging
- [ ] Multiple sequential operations required
Decision Matrix by Use Case
| Use Case | Recommended Tool | Reason |
|---|---|---|
| Import 500 leads from webinar | Data Import Wizard | Small volume, simple structure |
| Update 75,000 account addresses | Data Loader | Exceeds 50K limit |
| Import opportunities from migration | Data Loader | Opportunities not supported in Wizard |
| Daily automated contact sync | Data Loader | Requires scheduling |
| Add campaign members once | Data Import Wizard | Simple, one-time operation |
| Export all opportunity data | Data Loader | Export not available in Wizard |
| Delete old records | Data Loader | Delete not available in Wizard |
| Import custom object records | Either | Both support custom objects; choose by volume |
| Complex parent-child imports | Data Loader | Better relationship handling |
Best Practices for Data Import Success
Regardless of which tool you choose, follow these best practices to ensure successful data imports.
Since data imports interact directly with sensitive business information, it’s important to understand how Salesforce protects that data. The Data Security in Salesforce guide explains org-wide defaults, role hierarchies, field security, and sharing rules—critical knowledge that helps ensure your import process maintains compliance and data integrity.
Pre-Import Best Practices
1. Clean Your Data First
- Remove duplicates before importing
- Standardize formats (phone numbers, dates, addresses)
- Validate email addresses
- Ensure picklist values match exactly
- Remove special characters that cause encoding issues
2. Create a Data Dictionary
Field Name: Account Name
API Name: Name
Type: Text
Required: Yes
Max Length: 255
Format: Proper case
Example: "Acme Corporation"3. Prepare Test Data
- Import 10-20 test records first
- Validate in sandbox before production
- Test with edge cases (long names, special characters)
4. Back Up Existing Data
- Export current data before major imports
- Keep backup of import files
- Document data state before import
5. Plan Import Sequence Parent objects first, then children:
- Accounts
- Contacts (reference Accounts)
- Opportunities (reference Accounts and Contacts)
- Custom child objects
During Import Best Practices
1. Monitor Progress
- Stay logged in during import
- Don’t close browser/application
- Watch for error notifications
2. Batch Large Imports
- Split files over 100MB into smaller batches
- Allow time between batches for processing
- Validate each batch before continuing
3. Use Appropriate Batch Sizes
- Data Loader default: 200 records per batch
- Increase for simple imports: Up to 10,000
- Decrease for complex records with many fields
Post-Import Best Practices
1. Validate Data Quality
-- SOQL query to validate recent imports
SELECT Id, Name, CreatedDate, CreatedBy.Name
FROM Account
WHERE CreatedDate = TODAY
ORDER BY CreatedDate DESC2. Check Record Counts
- Compare imported count vs. source file count
- Investigate any discrepancies
- Review error logs for patterns
3. Spot Check Records
- Randomly sample 20-30 imported records
- Verify field values populated correctly
- Check relationships created properly
4. Document the Process Create an import log:
- Date and time
- Number of records imported
- Tool used (Wizard or Data Loader)
- Any errors encountered
- How errors were resolved
Common Issues and Solutions
Data Import Wizard Issues
Problem: “Unable to lock row” errors
Cause: Records locked by other processes (workflows, triggers, integrations)
Solutions:
- Wait and retry import
- Temporarily deactivate workflows
- Import during off-peak hours
- Contact administrator to identify locking process
Problem: Duplicate records despite duplicate checking
Cause: Matching criteria doesn’t capture all variations
Solutions:
- Use multiple matching criteria
- Standardize data before import (consistent casing, spacing)
- Pre-clean duplicates in source system
- Consider fuzzy matching tools
Problem: “Required field missing” errors
Cause: Required fields not mapped or empty in source data
Solutions:
- Review object field requirements (Setup → Object Manager)
- Fill required fields in CSV
- Set default values in field mapping
- Request field requirement changes if appropriate
Data Loader Issues
Problem: Login fails with “Invalid username, password, security token”
Cause: Incorrect credentials or expired security token
Solutions:
- Reset password to receive new security token via email
- Ensure password+token concatenated correctly (no spaces)
- Verify using correct instance (production vs. sandbox)
- Check login.salesforce.com vs. test.salesforce.com in settings
Problem: “UNABLE_TO_LOCK_ROW” errors during large imports
Cause: Records locked by concurrent processes
Solutions:
- Reduce batch size (Settings → Batch Size from 200 to 50)
- Schedule imports during off-peak hours
- Disable parallel processing temporarily
- Implement retry logic in automated processes
Problem: Mapping file won’t load
Cause: Corrupted or outdated mapping file
Solutions:
- Recreate mapping manually
- Ensure .sdl file not edited directly
- Verify field API names haven’t changed
- Check for recent object customizations
Problem: High memory consumption causing crashes
Cause: Processing very large files
Solutions:
- Increase Java heap size: Edit dataloader.bat
SET MAX_HEAP_SIZE=2048m - Split large files into smaller batches
- Close other applications during import
- Use 64-bit Java version
Â
Mastering Salesforce Data Management
Effective data import is a crucial skill for Salesforce professionals, but it’s just one aspect of comprehensive platform expertise. Understanding when to use Data Import Wizard vs Data Loader, knowing how to troubleshoot issues, and implementing best practices separates good Salesforce professionals from great ones.
If you’re looking to deepen your Salesforce development skills and master not just data import but all aspects of the platform, consider investing in comprehensive training. The Salesforce Certified Platform Developer I (LWC & Aura) Course at MyTutorialRack covers data manipulation through Apex DML operations, Bulk API integration, governor limits, and all other essential developer competencies. This hands-on course includes real-world projects, code examples, and complete certification exam preparation to help you become a certified Salesforce developer and build scalable data solutions.
Data Import Wizard vs Data Loader: Quick Reference Guide
Data Import Wizard: At a Glance
To expand your understanding of Salesforce import methods beyond the Wizard and Data Loader, the Data Import in Salesforce guide provides a full overview of import capabilities, limitations, and best practices. It’s a great companion resource for anyone managing recurring or large-scale data loads.
Perfect For:
- ≤ 50,000 records
- Accounts, Contacts, Leads, Custom Objects
- Business users without technical background
- One-time or occasional imports
- When duplicate checking is critical
Limitations:
- No export capability
- No delete operations
- Limited object support
- No automation/scheduling
- Maximum 50K records
Access: Setup → Data Import Wizard
Data Loader: At a Glance
Perfect For
- 50,000 records (up to 5 million).
- All standard and custom objects
- Technical users and developers
- Automated/scheduled imports
- Export requirements
- Delete operations
Limitations:
- Requires installation
- API access required
- Steeper learning curve
- No built-in duplicate checking
Access: Download from Setup → Data Loader
Conclusion: Making the Right Choice
The Data Import Wizard vs Data Loader decision isn’t about which tool is better—it’s about which tool is right for your specific situation. The Data Import Wizard provides simplicity and accessibility for smaller, straightforward imports, while Data Loader delivers power and flexibility for complex, large-scale data management.
Key decision factors:
- Record volume: < 50K = Wizard, > 50K = Loader
- Object type: Opportunities/Cases = Loader
- User technical skill: Beginner = Wizard, Advanced = Loader
- Frequency: One-time = Wizard, Recurring = Loader (automated)
- Operation needed: Insert/Update = Either, Delete/Export = Loader
Master both tools, understand their strengths and limitations, and you’ll be equipped to handle any data import challenge Salesforce throws your way. Remember: the right tool makes the difference between a smooth, successful import and hours of frustration troubleshooting errors.
If you’re preparing for Salesforce admin or developer roles, understanding tools like Data Import Wizard and Data Loader is only one part of the interview journey. The Salesforce Interview Questions – The Complete Preparation Guide for Every Salesforce Role provides targeted insights into real interview patterns across admin, developer, consultant, and architect tracks. Pairing this guide with your data management knowledge ensures you walk into interviews with confidence and practical understanding.
Ready to Level Up Your Salesforce Development Skills?
Understanding data import tools is essential, but true Salesforce mastery requires comprehensive development knowledge. Learn Apex DML operations, Bulk API integration, Lightning Web Components, and all the skills needed to build scalable Salesforce applications. Enroll in the Salesforce Certified Platform Developer I (LWC & Aura) Course at MyTutorialRack and transform from a Salesforce user to a certified developer. Get hands-on experience, real-world projects, and complete exam preparation. Start your developer journey today!
Frequently Asked Questions
Q: Can I use Data Import Wizard to import Opportunities? No, with one exception. The Data Import Wizard does not support Opportunity imports in most editions. However, Salesforce Essentials Edition does allow Opportunity imports through the Wizard. For all other editions, you must use Data Loader.
Q: What happens if my Data Loader operation fails midway through? Data Loader processes records in batches. Successfully processed batches are committed to Salesforce, while the batch that failed will not be committed. Check the error log to identify failed records, fix the issues, and re-import only the failed records.
Q: Can I schedule Data Import Wizard imports to run automatically? No, the Data Import Wizard does not support scheduling. You must use Data Loader with command-line interface and a scheduler (like Windows Task Scheduler or cron) for automated imports.
Q: How do I get my security token for Data Loader? Reset your Salesforce password (Setup → My Personal Information → Change Password → Reset My Security Token). You’ll receive an email with your new security token. Append this token to your password when logging into Data Loader.
Q: Can Data Loader export data that’s been deleted (in Recycle Bin)? Yes! Use the “Export All” operation instead of “Export.” Export All includes active records plus those in the Recycle Bin. Standard “Export” only retrieves active records.
Q: What’s the maximum file size I can import? Data Import Wizard: 100 MB maximum file size. Data Loader: No strict file size limit, but 5 million records per operation limit applies. For large files, split into multiple batches.
Q: Can I undo an import if I made a mistake? Not automatically. However, if you used Data Loader, you have a success file with all imported record IDs. You can use Data Loader’s delete operation with this file to remove the imported records. Always test in sandbox first!
Q: Do I need API access to use Data Loader? Yes. Data Loader uses the Salesforce API. Professional Edition and higher include API access. Professional Edition users may need to purchase an API access add-on. Check with your administrator.
Q: Can I import files and attachments using these tools? Not directly. Data Import Wizard and Data Loader work with record data, not file attachments. For file imports, consider using Apex, APIs, or third-party tools designed for content migration.
