How to Bulk Edit Records in Salesforce (2026 Guide)
Bulk editing in Salesforce ranges from “double-click a cell” to “run a 5-million-record update via the API.” Picking the right method saves hours and avoids the dreaded Excel-to-CSV-to-Salesforce dance. Lightning Experience offers four main paths, and which one to use depends on how many records, what conditions, and how often.
Here’s how each works.
1. Inline Editing in List Views
The fastest method for ad-hoc updates. Works on any list view of any object.
- Go to the object tab (e.g., Accounts, Leads, Opportunities) and open a List View.
- Make sure the columns you want to edit are visible. Click the gear icon > Select Fields to Display to add columns.
- Hover over a cell. If the field is editable, a pencil icon appears.
- Double-click the cell, type the new value, and press Tab or click outside the cell.
- Edited cells get a yellow corner indicator. Click Save at the bottom of the list to commit, or Cancel to discard.
You can edit many cells across many rows before saving, Salesforce batches the updates and shows you any errors per row.
Edit many records to the same value
- In the list view, select records by ticking the checkbox at the start of each row (or the header to select all visible).
- Right-click a column header and choose Update Selected Items.
- Enter the new value and click Apply.
- Click Save.
This is the in-Salesforce equivalent of “fill down” in a spreadsheet.
When inline edit doesn’t work
Cells appear locked (no pencil icon) when:
- The field is a formula or rollup summary
- The field has a validation rule the user can’t satisfy with the current value
- The record is locked by an approval process
- The user lacks Edit permission via FLS or sharing
- The list view filter includes records the user can read but not edit
2. Mass Update via the Edit Action
Salesforce’s list view edit dialog handles up to 200 records at a time and works well for clean, predictable updates.
- From a list view, tick the checkboxes for the records you want.
- Click the dropdown arrow next to the New button.
- Select Edit Selected (label varies, sometimes shown as a single Edit button after selection).
- In the Edit Selected Records dialog, pick a field from the dropdown and enter the new value.
- Click Apply, then Save.
Salesforce processes the records and reports back any failures (validation rule errors, FLS issues). Failed rows roll back individually, successes still commit.
3. Data Loader for Larger Updates
Past the 200-record list view ceiling, Data Loader is the standard tool. It handles up to 5 million records per job and runs the Bulk API behind the scenes.
Get the IDs you need to update
- Run a Salesforce report with at least the Record ID and the field(s) you want to change as columns.
- Export the report as Details Only > CSV.
- Open the CSV and adjust the values you want to change. Keep the Id column intact, it’s the key Salesforce uses to find each record.
Load the CSV with Data Loader
- Open Data Loader (download from Setup > Data Loader if you don’t have it).
- Click Update.
- Log in with your Salesforce credentials and select your environment.
- Choose the object (e.g., Account, Contact, custom object).
- Browse to your CSV.
- Map fields: the Id column maps to the Salesforce Id field; map every other column to the field you want to update. Unmapped columns are ignored.
- Click Next and Finish.
- Data Loader writes a success.csv and error.csv to the output folder. Review the error file, common errors include FLS, validation rules, and locked records.
Tips
- Tick Use Bulk API in Settings for jobs over 10,000 records, it’s much faster.
- Set Batch Size to 200 (default) for standard updates; reduce to 50 if you’re hitting governor limits from triggers.
- For upserts (insert if new, update if exists), use the Upsert operation with an external ID field as the matching key.
4. Flow for Conditional Bulk Updates
When updates need logic, “only update opportunities where stage hasn’t changed in 30 days”, Flow is the right tool. Scheduled-triggered flows run on a recurring basis without requiring a manual trigger.
- Go to Setup > Flows > New Flow > Scheduled-Triggered Flow.
- Set the Schedule (frequency: once, daily, weekly; start date and time).
- Choose the Object the flow runs on and add filters (e.g.,
Stage Equals Negotiation/ReviewANDLastModifiedDate < 30 DAYS AGO). - Click Done.
- On the canvas, add an Update Records element. Connect it to the start node.
- Configure the update: which field, what new value (a literal, a formula, or another field).
- Click Save, give the flow a name, and Activate.
The flow runs on schedule, evaluates matching records in batches, and applies the updates. For real-time updates triggered by record changes (e.g., “set Status to ‘Stale’ whenever last activity > 60 days”), use a Record-Triggered Flow with a scheduled path instead.
When Bulk Edit Is Grayed Out
The most common reasons a bulk edit option doesn’t appear or won’t save:
| Reason | Fix |
|---|---|
| Locked record (approval process, deployed package) | Wait for approval to complete or recall the submission |
| Formula or rollup summary field | Edit the underlying input fields instead |
| Validation rule fires | Fix the value to meet the rule, or update the rule |
| Field-level security blocks edit | Ask an admin to grant FLS Edit on the field |
| List view spans multiple record types | Switch to a list view filtered to one record type |
| Field is encrypted with Shield | Need View Encrypted Data permission |
| Record is owned by inactive user | Reassign ownership first |
| Record is in a queue with restricted access | Add the user to the queue |
Quick Reference: Bulk Edit Methods
| Method | Max records | Conditional logic? | Edition gating |
|---|---|---|---|
| Inline list view edit | ~200 visible | No | All editions |
| Mass Update from list view | 200 per batch | No | All editions |
| Data Loader | 5 million per job | Via CSV filtering | All editions (admin install) |
| Scheduled Flow | Unlimited (governor limits apply) | Yes: full filter logic | All editions; advanced features in Enterprise+ |
Which Method Should You Use?
- Five records to fix right now? Inline edit in a list view.
- A couple hundred with the same new value? Mass Update from a list view.
- Thousands of records or a one-time migration? Data Loader with a CSV.
- A rule that should run every week (e.g., mark stale leads)? Scheduled Flow.
- Real-time on every save (e.g., set a field whenever stage changes)? Record-Triggered Flow.
Let an AI Handle the Repetitive Updates
Bulk editing is a one-time fix for a recurring problem. The actual work, keeping ownership current, marking stale leads, syncing fields between systems, repeats every week. Carly is an AI assistant that connects to 200+ apps including Salesforce and handles the repetitive work for you.
More on Salesforce: How to merge leads in Salesforce · How to import contacts into Salesforce · How to export data from Salesforce · How to connect Salesforce to an AI agent
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
Get Carly Today →Or try our Free Group Scheduling Tool or Free Booking Page