Differences between Data ImportWizard and Data Loader

Differences between Data ImportWizard and Data Loader

1. Data Import Wizard

   • 50K data records
   • No Export
   • Some Standard Objects
     • Accounts
     • Contacts
     • Leads
     • Solutions
     • Campaigns
     • Members
     • Person Account
   • Allows Custom Objects
   • From SF Setup
   • Prevent Duplicates
   • No save mapping file
   • Can avoid workflow rules & Process

2. Data Loader

   • All Standard & custom Objects
   • Export
   • Up to 5M records
   • Client Side Software
   • Save Mapping file
   • Command Line interface
   • Extra Operations
     • Hard Delete
     • Export All

3. Other Tools

   • Workbench
     • Export
     • Select Data
   • ETL Tools