# Baserow Grid View - Rows, Columns, and Bulk Data Editing

> Bulk-edit rows, drag to reorder, freeze columns, and sum a field in seconds - the spreadsheet-style grid view is the default for every Baserow table.

Source: https://opennix.org/en/docs/baserow/view-types/guide-to-grid-view/


Grid view is Baserow's spreadsheet-style interface: rows and columns with inline cell editing and bulk operations across many records at once. It's the default view for every new table. This article covers creating an additional grid view, selecting multiple rows, reordering rows by drag and drop, and adjusting column width.

## What is grid view

Grid view displays table data as rows and columns - the familiar layout of Excel or Google Sheets. It's the strongest fit for bulk data entry, editing several records at the same time, detailed data analysis, working with formulas, and exporting filtered data.

Every new table starts out with grid view - the other [view types](/docs/baserow/views/overview-of-baserow-views/) get added to it later, for specific tasks.

## Grid view compared to other types

| Feature | Grid | Gallery | Form |
|---|---|---|---|
| Best for | Detailed data work | Visual browsing | Data collection |
| Data density | High | Medium | N/A |
| Multi-row selection | Yes | No | No |
| Manual drag reordering | Yes | Yes (cards) | No |
| Field summaries in the footer | Yes | No | No |
| Bulk editing | Yes | Limited | No |
| Export | Yes | No | No |

## Create a grid view

Every new table already ships with a default grid view. To add another one:

1. Click the **view dropdown** in the table's upper-left corner.
2. Choose **Grid** from the view type options.
3. Enter a **name** for the new view.
4. Click **Create view**.

![Creating a grid view in Baserow](/images/baserow/view-types/baserow-grid-view-create-dialog.webp)

The new grid view starts out showing every row in the table. [Customize it](/docs/baserow/views/view-customization/) with filters, sorts, and field visibility to build a view focused on one task.

## Select multiple rows

Multi-row selection lets you run bulk operations across many records at once - a capability unique to grid view.

### With checkboxes

1. Hover over the **row number** on the left of any row.
2. A checkbox appears - click it to select the row.
3. Repeat for any additional rows you want to add to the selection.
4. Selected rows highlight with a blue background.

### With keyboard shortcuts

1. Click a row to select it.
2. Hold **Shift** and click another row to select every row in between.
3. Use **Cmd/Ctrl + click** to select non-contiguous rows.

### Bulk actions

Once rows are selected, a toolbar appears at the top of the grid with the available actions:

- **Delete rows** - permanently remove every selected row;
- **Duplicate rows** - create copies of the selected rows;
- **Export table** - download the selected rows or the whole view.

## Reorder rows by dragging

Grid view lets you set a manual row order by dragging, which comes in handy whenever automatic sorting doesn't match what you need.

Click and hold the **drag handle** (⋮⋮) on the left of any row, then drag it up or down to its new position.

![Manually reordering rows with the drag handle](/images/baserow/view-types/baserow-grid-view-drag-handle-reorder.webp)

> Manual reordering only works when no automatic sort conditions are active. If sorts are already applied to the view, remove them first to enable dragging.

A manual order persists until you apply an automatic sort. That makes it a good fit for priority lists, custom workflows, and any case where your own judgment matters more than sorting by a field's value.

## Column width and freezing columns

Column width controls how much horizontal space each field takes up. Width settings save per view, so different grid views of the same table can use different column widths.

Wide tables with dozens of fields make it easy to lose track of which row you're looking at while scrolling horizontally. Baserow lets you freeze up to four columns on the left side of a grid view - they stay in place while you scroll through the rest of the data.

To resize a single column:

1. Hover over the **divider line** between two field headers.
2. The cursor switches to a resize indicator.
3. **Click and drag** left or right to change the width.
4. Release to set the new width.

## Field summaries in the footer

Field summaries calculate a statistic for each field and show up at the bottom of the grid - a capability unique to grid view. Which summaries are available depends on the field type, and the calculation only considers visible rows: filter a table down to 100 of 1,000 rows and the summary is based on just those 100.

For the full set of available summary functions and how to configure them, see [Footer aggregation in Baserow](/docs/baserow/fields/footer-aggregation/).

## Grid view toolbar

The toolbar at the top of grid view gives quick access to common operations:

- **Filter** - show only records matching a condition;
- **Sort** - order rows automatically by a field's value;
- **Group** - roll rows up into collapsible sections;
- **Hide fields** - control which columns are shown;
- **Row height** - adjust row size (short, medium, tall, extra tall).

For more on filtering, see [Filters in Baserow](/docs/baserow/views/filters-in-baserow/); for grouping rows, see [Group rows by a field](/docs/baserow/views/group-rows-in-baserow/).

## Managing a grid view

The three-dot menu (⋮) next to the view name opens:

- **Export view** - download filtered data as CSV, Excel, JSON, or XML;
- **Duplicate view** - copy the configuration into a new view;
- **Import file** - add data from CSV, JSON, or XML;
- **Rename view**;
- **Delete view**.

For more on exporting, see [Export a view](/docs/baserow/views/export-a-view/).

## Why use grid view

Grid view is the most capable view type for detailed data work - it gives full access to every field with maximum flexibility.

**Full access to your data:** every field shows up without switching between specialized views, from plain text to complex formulas.

**Bulk operations:** select and change several rows at once - delete, duplicate, or export dozens or hundreds of records in a single action.

**Spreadsheet familiarity:** anyone used to Excel or Google Sheets can start working right away - cell selection, keyboard shortcuts, and inline editing all behave as expected.

**Advanced capabilities:** only grid view supports footer field summaries, manual row reordering, multi-row selection, and detailed column-width control.

## Frequently asked questions

**Why can't I manually reorder rows?** Manual reordering is disabled whenever an automatic sort condition is active. Click **Sort** in the toolbar and remove every condition by clicking the X next to it. The drag handle (⋮⋮) starts working again once the sorts are gone.

**How many rows can grid view handle comfortably?** Grid view performs well with tables in the tens of thousands of rows. For very large tables (100,000+ rows), use filters to cut down the number of visible rows.

**Do field summaries respect active filters?** Yes. Summaries are calculated only from currently visible rows. Filter 500 rows down to 50 and the sum, average, or count reflect just those 50.

**Can I paste multiple cells from Excel into grid view?** Yes. Copy cells from Excel or Google Sheets, click a cell in grid view, and paste (Ctrl/Cmd + V). Baserow creates or updates rows and fields as needed.

**How many columns can I freeze?** Up to four per view - the limit keeps enough screen space free to scroll through the rest of the unpinned data.

## What's next

Grid view is a solid starting point for working with data. To see the same data as visual cards, read [Gallery view](/docs/baserow/view-types/guide-to-gallery-view/); to collect data from outside contributors, read [Creating forms in Baserow](/docs/baserow/view-types/guide-to-creating-forms-in-baserow/). For the full set of options any view supports, see [View customization](/docs/baserow/views/view-customization/).