Spreadsheet View shows a project's items as rows, so you can review and edit the same fields across many items without opening each one. To open it, hover over Display Options on the Products tab and click Spreadsheet View.
Edit a Cell
Click the cell you want to change.
Type the new value, or choose a date or option from the list.
Press Enter or click outside the cell to save.
A Color/Finish cell open for editing.
Clicking outside a cell saves it rather than cancelling. If you change a cell by mistake, click it again and put back the old value.
Select Items for a Bulk Action
Check the box at the start of each row you want, or the box in the heading row to select everything on the page.
To select every item that matches your filters, on all pages, check Select All in the toolbar.
Click Bulk Actions (the lightning-bolt icon) and choose an action.
Check the count in the action's window before you confirm. Some actions only use the rows on the current page. Click Clear All to deselect.
Change How Many Rows You See
At the bottom of the page, choose Rows per page (25, 50, 100 or 250), and use the arrows to move between pages.
Good to Know
Read-only cells: calculated prices, such as Unit Price and Ext. Price, can't be edited. Change the price, quantity, discount or markup instead.
Locked items: an item on a purchase order is locked and its cells can't be edited. Unlock it first.
Schedule and Type: the Type list only shows Types in the item's Schedule. Choosing a Type also sets its Schedule.
Pasting: pasting into several cells at once or filling down isn't supported. Edit one cell at a time.
Permissions: you can only edit fields your role allows.
Troubleshooting
Problem | What to check |
I can't edit a cell | The field may be calculated, the item may be locked, or your role may not allow editing that field. |
An error appeared after I edited a cell | The change may not have saved. Reload the page and check the value before trying again. |
The checkboxes in each row are greyed out | Select All in the toolbar is on. Click Clear All to select rows one by one. |
The Type I want isn't in the list | Choose the right Schedule first. |

