Salesforce Data Loader: the complete guide (and when a spreadsheet is faster)

Salesforce Data Loader is Salesforce’s own free desktop application for importing, exporting, updating, and deleting records in bulk. It is a genuinely capable tool, and for a lot of admin work it is the right one. But if you are a sales rep or an operations person who just needs to update a few hundred records before a forecast call, it can feel heavier than the job deserves.

This guide covers what Data Loader actually is, what it does well, where it gets in the way, and the alternatives, including the simplest one: editing your data in a spreadsheet and syncing it back.

What Salesforce Data Loader is

Data Loader is a free, official client application from Salesforce. In short:

• It reads and writes CSV files, and supports insert, update, upsert, delete, hard delete, and export operations.
• It talks to your org through Salesforce’s SOAP and Bulk APIs, so it can handle very large volumes (into the millions of records).
• It runs on Windows and macOS, and requires a Java runtime (Salesforce ships it with Zulu OpenJDK).
• It has a command-line mode for scheduled or automated jobs, alongside the point-and-click UI.

It is installed per machine and authenticates with your Salesforce login, so it can only ever do what your user is already permitted to do.

What Data Loader does well

Credit where it is due. Data Loader is the right tool when you need:

• Scale. Through the Bulk API it comfortably processes hundreds of thousands or millions of records.
• Automation. The command-line interface plus saved configurations let you schedule recurring jobs (a nightly sync, a weekly cleanup).
• Full coverage. It works across standard and custom objects, supports external IDs, and handles upserts cleanly.
• Price and support. It is free and maintained by Salesforce.

If you are an admin running large or repeating data jobs, Data Loader is a sensible default and this guide is not trying to talk you out of it.

Where Data Loader gets in the way

The friction shows up on the occasional, human-scale edit: update the stage on 200 opportunities, fix the industry on a list of accounts, log a week of calls. For that kind of task, several things slow you down:

• Setup. You install the app and a Java runtime before you can touch a record.
• The CSV round-trip. You export to CSV, open it in Excel, make your edits, then re-map the columns on the way back in. The field mapping is a step you repeat on most imports.
• No preview of what will change. Data Loader does not show you a field-by-field comparison of old value versus new value before it writes. You learn what happened from the success and error files after the job runs.
• No picklist validation as you work. If a cell says closed won instead of Closed Won, nothing flags it while you type; it either imports the wrong value or fails on load.
• Date and locale pitfalls. Spreadsheets store dates in ways that can be ambiguous (DD/MM versus MM/DD), and a mismatched format can silently shift dates on import.
• It is an admin tool. The interface, the API access, and the mental model all assume a fairly technical user.

None of these are flaws exactly. They are the trade-offs of a powerful, general-purpose data utility. They just make it a lot of tool for a small, in-the-moment edit.

The main ways to work with Salesforce data in bulk

There are four common options. They suit different people and different jobs.

When to use which

• Salesforce Data Loader for large or recurring, automatable jobs, run by someone comfortable with CSV files and APIs.
• Data Import Wizard for simple in-browser imports of standard objects, up to 50,000 records, when you do not want to install anything. It cannot export or delete, so it is import-only.
• Workbench for ad-hoc SOQL queries and quick data operations by technical users. It is not meant for non-technical bulk editing.
• A spreadsheet tool when the person doing the work lives in Excel, Numbers, or Google Sheets and wants a safety net: see exactly what will change, pick valid values from dropdowns, and avoid the CSV mapping dance.

The spreadsheet alternative, in practice

If the friction above sounds familiar, the simplest fix is to work where salespeople already work: a spreadsheet. Upcells is a desktop app (macOS and Windows) built around that idea.

The round-trip is short:

1. Export. Pick an object and the fields you want, and Upcells pulls them into Excel or CSV, with restricted picklist fields exported as real Excel dropdowns so only valid values go back in. (More in query and export.)
2. Edit. Change the data in whatever spreadsheet app you prefer.
3. Preview and sync. Drop the file back in and Upcells shows a field-by-field diff: old value, new value, and any picklist warnings, before anything is written. Nothing changes in Salesforce until you click Apply. (More in edit and sync.)

Because it is local-first, your records flow directly between your machine and your Salesforce org. It connects with OAuth, so it can only do what your user already can. On the higher tiers it also adds a private, on-device AI that can enrich fields and answer questions about your data without that data leaving your machine. You can compare the tiers on the pricing page.

The point is not that Data Loader is bad. It is that for a rep updating a few hundred records, a spreadsheet with a preview is usually faster and safer than a CSV job with no net.

Related guides

• Salesforce Data Loader alternatives: the five main options and who each one suits.
• Data Loader vs Data Import Wizard: record limits, exports, deletes, and which to pick.
• How to install and use Data Loader: step by step on Windows and macOS.
• How to export Salesforce to Excel: every export route, and how to sync edits back.
• Upcells vs Salesforce Data Loader: a side-by-side comparison.

Frequently asked questions

Is Salesforce Data Loader free? Yes. It is a free, official tool from Salesforce.

Does Data Loader work on a Mac? Yes. There are Windows and macOS versions. Both need a Java runtime, which Salesforce bundles (Zulu OpenJDK).

What is the difference between Data Loader and the Data Import Wizard? The Data Import Wizard runs in the browser with no install and handles simple imports of up to 50,000 records, but it cannot export or delete. Data Loader is a desktop app that exports, imports, updates, and deletes, and scales to millions of records through the Bulk API.

How many records can Data Loader handle? Into the millions, using the Bulk API. For smaller, one-off edits the limit is rarely the issue; the friction is the workflow.

Can I edit Salesforce data in Excel instead? Yes. You can export to CSV and re-import, or use a tool like Upcells that makes it a proper round-trip, exporting to a spreadsheet, then syncing your edits back with a diff preview and picklist validation so you can see exactly what will change first.