---
title: "Salesforce Data Loader vs Import Wizard vs dataloader.io"
description: "When to use the Data Import Wizard, Data Loader or dataloader.io to import data into Salesforce, their record limits, and when a done-for-you migration fits."
url: "https://flitstack.ai/guides/salesforce-data-loader"
---

# Salesforce Data Loader vs Data Import Wizard vs dataloader.io

Short answer

Use the Data Import Wizard for under 50,000 records on supported objects. Use Data Loader for up to 150 million records, any object or scheduled loads. dataloader.io is the browser option with monthly record caps. For a full move from another CRM with history and relationships, FlitStack AI maps, validates and loads it for you.

![](https://flitstack.ai/images/authors/aditya-kumar.webp)By [Aditya Kumar](https://flitstack.ai/about/aditya-kumar) Updated November 5, 2026

[Have it done for you ](https://flitstack.ai/contact) [Back to the hub →](https://flitstack.ai/migrations/crm/salesforce-sales-cloud)

******What we handle 5

- Import under 50,000 accounts, contacts, leads or custom object records
- Load opportunities or objects the wizard doesn't support
- Load millions of records
- Keep original created dates and owners
- Bring activity history (emails, calls, tasks, notes)

## What the native tool does, and where it stops

| Task                                                                   | Native tool                                                                                                                 | With FlitStack AI                                                                                    |
| ---------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------- |
| Import under 50,000 accounts, contacts, leads or custom object records | Data Import Wizard handles it in the browser, with duplicate matching on account name and site or email.                    | Not needed for a small one-off file. FlitStack AI is for full migrations from another system.        |
| Load opportunities or objects the wizard doesn't support               | Data Loader loads any object, including custom objects, from CSV.                                                           | Loads every object in dependency order so lookups resolve, with no manual ID matching between files. |
| Load millions of records                                               | Data Loader supports CSV files up to 150 million records with Bulk API 2.0. Above that, Salesforce points you to a partner. | Runs large loads with rate-limit handling and a sample run first.                                    |
| Keep original created dates and owners                                 | Possible only after an admin enables Create Audit Fields; owners need user IDs in the file.                                 | Preserves timestamps and matches owners by email, flagging any user it can't match.                  |
| Bring activity history (emails, calls, tasks, notes)                   | Each activity type is a separate file keyed to Salesforce IDs you must look up first.                                       | Moves activities with original timestamps and user attribution, attached to the right records.       |
| Check the load and undo it                                             | Success and error CSV logs. Undoing a load means a separate delete job.                                                     | Field-level validation and hash checks on every record, plus one-click rollback.                     |

Salesforce gives you two free import tools, and MuleSoft sells a third. They overlap, but each has a clear job. The short version: the **Data Import Wizard** is for small, simple files, **Data Loader** is for volume and for any object, and **dataloader.io** is Data Loader’s browser-based cousin with monthly caps. None of them is a migration tool. They load rows you have already exported, cleaned and keyed. Everything else is your work.

## Which Salesforce import tool should I use?

Salesforce’s own guidance splits the tools by volume, object and how often you load. Here is the decision in one table.

| If you need to…                                                                                                                | Use                                        | Why                                                            |
| ------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------ | -------------------------------------------------------------- |
| Load fewer than 50,000 records into accounts, contacts, leads, solutions, person accounts, campaign members or a custom object | Data Import Wizard                         | Runs in Setup, no install, built-in duplicate matching         |
| Load opportunities, cases, activities or any object the wizard doesn’t list                                                    | Data Loader                                | Supports all objects, including custom objects                 |
| Load 50,000 to 150 million records                                                                                             | Data Loader                                | Supports CSV files up to 150 million records with Bulk API 2.0 |
| Run a nightly or scheduled load                                                                                                | Data Loader (Windows CLI) or dataloader.io | Command-line config files, or scheduled tasks in the browser   |
| Work from a browser on a locked-down laptop                                                                                    | dataloader.io                              | Nothing to install. Monthly record caps apply                  |
| Move a whole CRM, with history and relationships                                                                               | A migration tool or service                | The loaders don’t extract, map or sequence across objects      |

Above 150 million records, Salesforce’s docs recommend working with a Salesforce partner or an AppExchange product.

## What does the Data Import Wizard do, and where does it stop?

The wizard lives in Setup (search “Data Import Wizard” in Quick Find). Trailhead describes it as able to import up to 50,000 records at a time into standard objects (accounts, contacts, leads, solutions, person accounts, campaign members) and custom objects. You can add new records, update existing ones, or both, and it can prevent duplicates by matching on account name and site, contact email or lead email.

Where it stops:

- **No opportunities, cases or activities.** If the object isn’t on its list, you need Data Loader.
- **Validation rules run.** Records that fail are skipped, so a strict org can quietly drop rows.
- **Simple mappings only.** Salesforce’s guidance is to use it when the target object has fewer than 50 fields and the data has no complex mappings.

## What does Data Loader do, and where does it stop?

Data Loader is a client application you install. Salesforce describes it as a tool to insert, update, delete or export records, reading from CSV or a database connection. Key facts from the current documentation:

- **Volume:** CSV files up to 150 million records when used with Bulk API 2.0. Older versions of the docs said 5 million, so check the version you are reading.
- **Objects:** all objects, including custom objects.
- **Platforms:** the interface runs on macOS and Windows and needs Java 17 or later. Salesforce no longer bundles Java with the Windows installer.
- **Automation:** the command-line interface, which you use for scheduled jobs, is supported on Windows only.
- **Editions and permissions:** available in Enterprise, Performance, Unlimited and Developer editions. Users need API Enabled, the object permission for the operation, and Bulk API Hard Delete if they hard-delete through the Bulk API.
- **Logs:** success and error files in CSV for every run.

Where it stops is the part most teams find out mid-project:

- **It loads one object per job.** To link contacts to accounts, you first load accounts, export the new Salesforce IDs, VLOOKUP them into the contact file, then load contacts. Repeat for opportunities, then for every activity type.
- **Created dates and owners need setup.** To keep original Created Date and Created By, an admin must enable the Create Audit Fields feature, which lets API tools such as Data Loader set those system fields on insert.
- **No undo.** Reversing a bad load means building and running a delete job from the success file.
- **It doesn’t export attachments.** Salesforce’s export docs say to use the weekly export for those.

## What is dataloader.io and how is it priced?

dataloader.io is a browser-based loader that shows a Salesforce copyright and is “Powered by” MuleSoft’s Anypoint Platform. It does import, export and delete, connects to Box, Dropbox and FTP, and schedules tasks. Published plans as of November 2026:

| Plan         | Price                   | Records per month | Max file size | Scheduled tasks |
| ------------ | ----------------------- | ----------------- | ------------- | --------------- |
| Free         | $0 per user per month   | 10,000            | 10 MB         | 1               |
| Professional | $99 per user per month  | 100,000           | 50 MB         | 50              |
| Enterprise   | $299 per user per month | Unlimited         | 100 MB        | Unlimited       |

It counts production and sandbox users separately. The same limits apply as with Data Loader: one object per task, and you supply the IDs that link records.

## How do I import data into Salesforce with Data Loader?

This is the procedure Salesforce’s Trailhead module describes, with the steps that bite in practice added.

1. **Export from the old system.** Get one CSV per object: companies, people, deals, activities, notes.
2. **Clean the files.** Remove duplicates and unneeded rows, fix errors, and standardise picklist values to match Salesforce exactly.
3. **Compare fields and map.** List each source field against a Salesforce field. Create missing custom fields and picklist values first.
4. **Prepare the org.** Enable Create Audit Fields if you need original dates. Temporarily deactivate validation rules, duplicate rules and automations that would fire on insert.
5. **Load parents first.** Insert users (or map owners to existing user IDs), then accounts.
6. **Carry IDs forward.** From the account success file, map old IDs to new Salesforce IDs, add them to the contact file, then insert contacts. Repeat for opportunities, contact roles, cases and activities.
7. **Test with a small file.** Load a few hundred rows of each object, check them in the UI, then run the full set.
8. **Reconcile.** Compare row counts and spot-check records against the source. Reactivate the rules and automations you turned off.

Steps 5 and 6 are where most of the hours go. A CRM with five related objects and four activity types is nine dependent loads, each needing the previous load’s IDs.

## When is a done-for-you migration better than a loader?

The loaders are the right tool when you already have clean, Salesforce-shaped files. They are the wrong tool when the hard part is everything before the file: extracting from another CRM’s API, deciding how its objects map to Salesforce’s, keeping activity history and owners, and proving nothing went missing.

Choose a service when:

- the source is another CRM (HubSpot, Zoho, Pipedrive, Dynamics), not a spreadsheet;
- you need emails, calls, tasks and notes on the right records with original dates;
- there are custom objects or record types to map;
- you can’t freeze the old system for days during cutover;
- someone will ask you to prove every record arrived.

## When to bring in FlitStack AI

FlitStack AI is a data-migration platform sold as software plus a done-for-you service. It connects to the source and to Salesforce, proposes field-level mappings with AI for you to review, runs a sample, then migrates every object in order with validation on each record and one-click rollback. A delta migration picks up records changed during cutover, and the [Salesforce implementation service](https://flitstack.ai/services/salesforce-implementation) sets up pipelines and automation in the new org.

Moving from HubSpot? See the [HubSpot to Salesforce migration](https://flitstack.ai/migrations/crm/hubspot/to/salesforce-sales-cloud) page, or start from the [Salesforce migration hub](https://flitstack.ai/migrations/crm/salesforce-sales-cloud). For a scoped quote, [book a free scoping call](https://flitstack.ai/contact).

![Aditya Kumar](https://flitstack.ai/images/authors/aditya-kumar.webp)

About the author

[Aditya Kumar](https://flitstack.ai/about/aditya-kumar)

Founder, FlitStack AI

Aditya Kumar is the founder of FlitStack AI and Jetstack AI, both built at Ambrstack. FlitStack AI migrates CRM and business data between platforms; Jetstack AI is the AI platform HubSpot partners and RevOps teams use to audit portals, build implementations and reuse their best setups across portals. He writes about CRM data, migrations, HubSpot architecture and automation from the work of building them.

[More from Aditya](https://flitstack.ai/about/aditya-kumar) [LinkedIn](https://www.linkedin.com/in/aditya-ambrstack/)

On this page

Questions, answered

## A few useful answers.

Is Salesforce Data Loader free?

Yes. Data Loader is a free client application from Salesforce. Its documentation lists it for Enterprise, Performance, Unlimited and Developer editions, and it needs the API Enabled permission plus the object permissions for each operation.

What is the record limit for the Data Import Wizard?

The Data Import Wizard imports up to 50,000 records at a time. Salesforce recommends Data Loader for larger loads, for objects the wizard doesn't support, and for scheduled imports.

Is dataloader.io the same as Data Loader?

No. dataloader.io is a separate browser-based product from MuleSoft (a Salesforce company). It has a free plan capped at 10,000 records a month and paid per-user plans. The desktop Data Loader is a different, installed application.

Does Data Loader work on a Mac?

Yes, the Data Loader interface runs on macOS and Windows and needs Java 17 or later. The command-line interface for automated jobs is supported on Windows only.

## Related

### [Migrate to Salesforce](https://flitstack.ai/migrations/crm/salesforce-sales-cloud)

[Read →](https://flitstack.ai/migrations/crm/salesforce-sales-cloud)

### [How do I export data from Salesforce?](https://flitstack.ai/guides/export-data-from-salesforce)

[Read →](https://flitstack.ai/guides/export-data-from-salesforce)

### [CRM migration checklist: what to do before, during and after the move](https://flitstack.ai/guides/crm-migration-checklist)

[Read →](https://flitstack.ai/guides/crm-migration-checklist)

### [HubSpot to Salesforce migration](https://flitstack.ai/migrations/crm/hubspot/to/salesforce-sales-cloud)

[Read →](https://flitstack.ai/migrations/crm/hubspot/to/salesforce-sales-cloud)

### [Salesforce implementation and data migration](https://flitstack.ai/services/salesforce-implementation)

[Read →](https://flitstack.ai/services/salesforce-implementation)

## Sources

1. [Salesforce Developers: When to Use Data Loader](https://developer.salesforce.com/docs/platform/data-loader-impl/guide/when-to-use-the-data-loader.html)
2. [Salesforce Developers: Data Loader overview](https://developer.salesforce.com/docs/platform/data-loader-impl/guide/data-loader-intro.html)
3. [Salesforce Developers: Considerations for Installing Data Loader](https://developer.salesforce.com/docs/platform/data-loader-impl/guide/installing-the-data-loader.html)
4. [Trailhead: Import Data (Data Import Wizard and Data Loader)](https://trailhead.salesforce.com/content/learn/modules/lex_implementation_data_management/lex_implementation_data_import)
5. [Salesforce Help: Enable the Create Audit Fields permission](https://help.salesforce.com/s/articleView?id=000386699\&type=1)
6. [dataloader.io pricing](https://dataloader.io/pricing)

Get a quote

## Rather have it done for you?

FlitStack AI maps, validates and migrates your data, sets up the process in the new system, and keeps a one-click rollback.

[Get a quote](https://flitstack.ai/contact)
