How to Bulk-Edit Multiple Rows in a Notion Database

Editing one row at a time in a Notion database is slow when you need to update dozens of records. You might need to change a status field, update a date, or reassign a team member across many items. Notion provides several methods to apply the same change to multiple rows at once without clicking into each page individually. This article covers the three main ways to bulk-edit rows: using the table view, mass-editing properties, and applying formulas or rollups across multiple rows.

What You Can Bulk-Edit in a Notion Database

Notion databases support bulk editing for most property types: text, select, multi-select, date, checkbox, email, phone, URL, number, formula, relation, and rollup. You cannot bulk-edit file and media properties or the page title directly through the row selection method. The bulk-edit feature works in any database view (table, board, list, calendar, gallery) as long as you select multiple rows. The changes apply instantly to all selected rows, and you can undo the action by pressing Ctrl+Z (Windows) or Cmd+Z (Mac) immediately after editing.

Before bulk-editing, ensure you have edit permissions on the database. If you are working in a shared workspace, other collaborators will see the changes in real time. Bulk-editing does not create a version history for individual rows, but the database page itself can be restored from the page history if needed.

Method 1: Bulk-Edit Using Row Selection in a Table View

This is the most direct method for editing multiple rows at once. It works in any database view that displays rows as selectable items.

1. Open your database in a table view
   Navigate to the Notion page that contains your database. If you are not already in a table view, click the view name at the top left of the database and select “Table” from the dropdown. The table view shows rows as horizontal lines with checkboxes on the left side.
2. Select the rows you want to edit
   Click the checkbox to the left of the first row. Hold the Shift key and click the checkbox of the last row to select a contiguous range. To select non-adjacent rows, hold the Ctrl key (Windows) or Cmd key (Mac) and click each checkbox individually. A blue bar appears at the bottom of the database showing the number of selected rows.
3. Open the bulk-edit menu
   With rows selected, click anywhere inside the blue bar that says “X rows selected.” A pop-up menu appears with options: Edit Properties, Move To, Copy, Delete, and more. Click “Edit Properties.”
4. Choose the property to edit
   In the Edit Properties panel, click the dropdown labeled “Select a property.” Choose the property you want to change from the list. Only properties that exist in the database appear here.
5. Set the new value
   Depending on the property type, a field appears where you can type a value, select an option, pick a date, toggle a checkbox, or enter a number. For multi-select properties, you can add or remove options. For relation properties, you can link or unlink related pages. After setting the value, click “Apply Changes” at the bottom of the panel.

The change is applied instantly to all selected rows. You can repeat the process to edit a different property on the same set of rows. To deselect rows, click any empty space on the page or press Escape.

Method 2: Bulk-Edit by Changing a Property Column

If you need to change the property type or its options for all rows, editing the column header is the fastest method. This is useful when you want to convert a text property to a select property or add new select options that apply to every row.

1. Click the property column header
   Hover over the column header of the property you want to edit. Click the dropdown arrow that appears on the right side of the header.
2. Select Edit property
   From the dropdown menu, click “Edit property.” A panel opens showing the property name, type, and options (if applicable).
3. Change the property type or options
   To change the property type, click the current type name and select a new type from the list. Notion warns you if data might be lost during conversion. To add or remove select or multi-select options, type new options into the “Options” field or click the X next to an existing option to remove it. Removing an option clears that value from all rows where it was set.
4. Click Save
   After making changes, click “Save” at the bottom of the panel. The change applies to every row in the database.

Method 3: Bulk-Edit Using Formulas and Rollups

Formulas and rollups are read-only property types that automatically compute or display data from other properties. You can use them to apply a transformation across all rows without manual editing. For example, you can create a formula that converts a date into a quarter label or a rollup that pulls the status from a related database.

1. Add a new formula or rollup column
   Click the + button to the right of the last column in your database. Select “Formula” or “Rollup” from the list of property types.
2. Write the formula or configure the rollup
   For a formula, type the expression using Notion’s formula syntax. For example, formatDate(prop("Date"), "MMMM YYYY") converts a date property to a month-year string. For a rollup, select the related database, the property to aggregate, and the aggregation function (e.g., Count, Sum, Average).
3. The result appears in every row
   Once saved, the formula or rollup value populates automatically for all rows. You do not need to select rows or apply changes individually. To update the values, edit the source properties — the formula or rollup recalculates immediately.

If Bulk-Edit Does Not Work as Expected

Rows are not selectable

If you cannot see checkboxes next to rows, you may be in a view that hides them. Switch to a table view by clicking the view name and selecting “Table.” In board, calendar, list, or gallery views, you can still select rows by clicking the checkbox that appears when you hover over the card or item. If checkboxes are still missing, check that you have edit permissions on the database.

Edit Properties option is grayed out

This happens when you select rows in a view that does not support bulk property editing, such as a board view that is grouped by a property. Switch to a table view or ungroup the board view by clicking the group dropdown and selecting “No grouping.” Then select the rows again.

Property value does not change after applying

If the property you are editing is a formula or rollup, you cannot change its value directly — it is read-only. Edit the source properties that the formula or rollup references instead. For other property types, ensure you clicked “Apply Changes” in the Edit Properties panel. If the value still does not change, refresh the page by pressing F5 or Ctrl+R.

Notion Bulk-Edit Methods Compared

Method	Best For	Limitations
Row selection + Edit Properties	Changing specific property values on a subset of rows	Cannot edit title or file properties; requires selecting rows manually
Edit property column header	Changing property type, name, or options for all rows	May cause data loss when converting types; affects every row
Formulas and rollups	Automatically computing or pulling data across all rows	Read-only; cannot be edited directly; requires formula knowledge

Each method serves a different purpose. Use row selection for targeted changes, column editing for structural updates, and formulas for dynamic calculations. You can combine methods — for example, use a formula to generate a value and then convert the formula column to a text column to make the values editable.

With these methods, you can edit multiple rows in a Notion database in seconds instead of minutes. Start by selecting the rows you want to update and use the Edit Properties menu for most changes. For structural updates, edit the column header directly. To automate repetitive transformations, set up a formula or rollup column. As an advanced tip, you can use the Move To option in the bulk-edit menu to move selected rows to a different database or group in a single action.