Data Import Wizard versus Data Loader for manufacturing data loads
Key Takeaway
Use the Data Import Wizard for simple imports of fewer than 50,000 records into objects it supports. Use Data Loader for objects the wizard doesn't support, scheduled or repeat loads, and exports for backup.
The Data Import Wizard and Data Loader are two Salesforce tools for loading records into an org. The Data Import Wizard is a simple in-browser tool for smaller, straightforward imports. Data Loader is a separate application for bulk loads, exports, and repeat jobs. Agentforce Manufacturing also includes CSV Data Management for bringing manufacturing data in from CSV files. Each tool has its own limits on record volume, objects, and operations, so the right choice depends on the load.
Data Import Wizard versus Data Loader
The two tools differ in where they run, how many records they handle, what they do, and which objects they support.
| Data Import Wizard | Data Loader | |
|---|---|---|
| Where it runs | In the browser, inside Salesforce | Client application you install on MacOS or Windows, outside Salesforce |
| Record limit | Up to 50,000 records | Up to 150 million records when used with Bulk API 2.0 |
| What it does | Imports only; can't export data out of the org | Inserts, updates, deletes, and exports records |
| Objects | Accounts, contacts, leads, solutions, campaign member status, and custom objects, depending on the edition | All objects, including custom objects |
| Editions | All editions except Personal and Database.com Editions | Enterprise, Performance, Unlimited, and Developer editions |
For accounts, the Data Import Wizard imports both business accounts and person accounts. Import wizards for other records aren't available.
Data Loader reads the data to load from CSV files or a database connection.
If you must load more than 150 million records, Data Loader is not the answer. Salesforce recommends working with a Salesforce partner or finding a suitable partner product on AppExchange.