Spreadsheet editing
Type into a cell and the value changes. Move with the arrow keys, paste a block from Excel, fill a value down, undo a mistake, add a new record at the top — and save, in batches that let your org’s own validation rules, triggers and flows run as usual.
Why it matters
The usual way to fix fifty records in Salesforce is to export them, fix them in a spreadsheet, and import them back — or to ask the people who own them to retype the changes. Rowhouse puts the spreadsheet where the records already are: the same keys, the same paste, the same undo, with Salesforce’s own security and your org’s own rules applied to every save.
How it compares
Type-to-edit and F2 are the two keys we could not find documented in any other Salesforce grid. Conga Grid publishes a limit of 100 rows per paste; Rowhouse takes up to 10,000 cells, and refuses a larger paste whole rather than cutting it short. Mashmatrix Sheet goes further than Rowhouse on paste, with tiling and discontiguous ranges, and the comparison says so.
See it as your users will
The keyboard, as a spreadsheet has it
Arrow keys move. Type to replace a value, or press F2 to edit it; Enter keeps the change and the cell turns yellow until you save. Home, End, Page Up and Page Down work as they do in Excel.
→ → ↓ to reach Amount, type 98000, Enter: the cell turns yellow, waiting for Save.
New records, where you are working
The New button sits above the grid beside Export, where a list view has its own. On an account’s page it adds a contact row at the top with the account already set; fill in its cells and Save creates it with your other changes.
The life of an edit
An edit waits on the Save bar until you save. Then it goes to Salesforce in batches of 200, your validation rules, triggers and flows run as usual, and the rows are read back so formulas show their real results.
Who can edit a cell
Four things decide it: the grid allows inline edit, the column is marked editable, you may edit the object and the field, and the field can be edited at all. A blue pencil marks a cell you can edit, a grey lock one you cannot.
Large saves, in batches
Each batch of 200 is its own transaction, so a validation rule that refuses one record never holds up the others. A record Salesforce refuses keeps your value and says why.
In detail
Type to edit
On a focused cell, just type — the first character replaces the value — or press Enter or F2, or double-click. Enter or Tab keeps the change; Esc leaves the cell as it was. A blue pencil marks a cell you can edit and a grey lock one you cannot.
Ten cell editors
Ten editors cover every editable field type: text, numbers, dates with a calendar, date and time, time, long text, checkboxes, picklists including dependent ones, multi-select picklists, and lookups including owner (user or queue). Salesforce’s own data table has no editable type for lookup, owner, dependent or multi-select picklist, time or long text; Rowhouse edits all of them. Rich text stays read-only.
The Save bar
An edited cell turns yellow and a Save bar counts the unsaved changes. Save sends them in batches of 200, each its own transaction, then reads the rows back so formula fields and your automation’s results show at once. A record Salesforce refuses keeps your value and says why; the rest still save.
New records, added in the grid
When the admin allows it, a New button sits above the grid, where a list view has its own. It adds a row at the top with Salesforce’s defaults already in it — you as the owner, picklist and checkbox defaults — and, in a child table or on a record page, the link to that record already set. Fill in its cells and Save: new records are created first, then your other changes. When a row can’t hold the record, such as a required field that isn’t a column or a choice of record type, New opens Salesforce’s own New form, and the record saved there joins the grid.
Undo and redo
Up to 100 steps, where one step is one action: one typed cell, one paste of 500 cells, one fill-down, one new row. The Undo and Redo buttons say what they will undo. Cancel throws every unsaved change away, new rows included.
Ranges, copy, paste and fill down
Shift and the arrows select a range. Copy writes cells that Excel and Google Sheets paste as cells; paste reads them back, including currency symbols, accounting negatives and dates in your locale. Ctrl+D fills down. Values a spreadsheet would run as a formula are made safe both ways.
The keyboard model
One Tab into the grid and one out; inside, the arrow keys move and never wrap. Home, End, Page Up and Page Down work as they do in a spreadsheet, and focus follows the record, so a sort never sends your next keystroke to the wrong row.
Row numbers, as a list view has them
Rows are numbered down the left edge at a list view’s own widths, so people can say “row 14” to each other on a call. An admin can hide them.
Where it stops
Each limit is there for a reason you can see: how much a browser draws smoothly, or how much Salesforce lets one transaction do. Every limit, and the benchmark →
- Records in one save10,000, in batches of 200 (fewer in a logging grid when many fields change)
- New rows in one save200
- Cells in one paste10,000; larger pastes refused, not cut short
- Undo steps100 (unsaved edits only)
- Browser wait for a save120 seconds, then a "still running" message
- No undo after saving. Undo covers unsaved edits; once saved, the audit trail is the record of what changed.
- Last save wins. Records are not locked while someone edits them, as with list view inline edit.
- Rich text is read-only in the grid.
Against the paid grids
Spreadsheet editing: questions
Why can’t I edit this column?
A cell is editable only when four things hold: the grid allows inline edit, the column is set as editable, you may edit the object and the field, and the field can be edited at all — not a formula, roll-up summary, auto-number, system or rich text field.
Can I add records from the grid?
Yes, when the admin allows it and you may create the object’s records: New adds a row at the top, and Save creates it with your other changes, up to 200 new rows a save. Undo takes a new row away; Cancel takes away every new row. When Salesforce needs more than the grid shows, New opens Salesforce’s own New form instead.
What happens to a record a validation rule rejects?
That record is marked, keeps the value you typed, and shows the rule’s message when you move to the cell. Every other record in the save still saves.
What happens if two people edit the same record?
The last save wins. Rowhouse does not lock records, which is how Salesforce list view inline editing behaves too.
Can I paste a lookup by name?
Yes, if a record of that name is already shown in the grid; otherwise paste its record Id. A name shared by two records is refused and asks for the Id.
Three things you can verify without asking us
Free. Not freemium, not a trial, not a tier.
Install it, assign the permission sets, build your first grid on the Grid Admin tab. Everything else is in the Grid Guide inside the app.