> ## Documentation Index
> Fetch the complete documentation index at: https://docs.arya.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Spreadsheet view

> Inline table editor with Excel-like shortcuts for fast bulk edits.

Arya's table view is **fully inline-editable**, like a spreadsheet. Edit many records in sequence without opening the detail.

<Frame>
  <img src="https://mintcdn.com/agevole/cM9eEPJE8FVhTNOb/images/liste/en/spreadsheet-view.svg?fit=max&auto=format&n=cM9eEPJE8FVhTNOb&q=85&s=5255130980ee3d6295bfe436a6e051b2" alt="Spreadsheet view with editable cells and selected row" width="1200" height="720" data-path="images/liste/en/spreadsheet-view.svg" />
</Frame>

## Cell editing

* **Single click** cell → edit mode
* **Double click** → advanced editor (for long text, links, etc.)
* **Tab** → commit and move right
* **Shift+Tab** → move left
* **Enter** → commit and move down
* **Escape** → cancel edit

## Shortcuts

| Action              | Shortcut                                                       |
| ------------------- | -------------------------------------------------------------- |
| Copy cell           | `Cmd+C` / `Ctrl+C`                                             |
| Paste               | `Cmd+V` / `Ctrl+V`                                             |
| Select whole column | Click on header                                                |
| Select range        | Click first cell → Shift+Click last                            |
| Select individual   | Cmd/Ctrl+Click                                                 |
| Fill down           | `Cmd+D` / `Ctrl+D` (copies first cell value to selected below) |
| Undo                | `Cmd+Z` / `Ctrl+Z`                                             |
| Redo                | `Cmd+Shift+Z` / `Ctrl+Shift+Z`                                 |

## Column bulk edit

<Steps>
  <Step title="Select range">
    Click → Shift+Click for range, or Cmd+Click for non-contiguous cells.
  </Step>

  <Step title="Edit in bulk">
    Write in the first cell → **Cmd+Enter** to apply to all selected.
  </Step>

  <Step title="Apply action">
    Top bulk menu: change stage/status, assign, apply tags.
  </Step>
</Steps>

## Customise columns

<AccordionGroup>
  <Accordion title="Show / hide">
    Click the column icon top right → tick/untick.
  </Accordion>

  <Accordion title="Reorder">
    Drag-and-drop headers.
  </Accordion>

  <Accordion title="Resize">
    Drag the header border. Size is saved per user.
  </Accordion>

  <Accordion title="Pin column">
    Right-click header → **Pin left / right**. Stays visible during horizontal scroll.
  </Accordion>

  <Accordion title="Sort">
    Click header to sort. Click again for descending. Hold Shift for multi-column sort.
  </Accordion>
</AccordionGroup>

## Live presence

If a colleague is editing the same list, you see their avatar on cells they're editing. Avoid collisions and conflicts.

## Spreadsheet import/export

<Steps>
  <Step title="Export">
    **Actions → Export** → Excel (.xlsx) or CSV. Respects active filters and visible columns.
  </Step>

  <Step title="Import (bulk update)">
    **Actions → Import updates** → upload Excel/CSV with first column = Arya record ID + other columns = values to update. Arya previews before commit.
  </Step>
</Steps>

## Limits

<Warning>
  The spreadsheet view loads in 100-row pages. For bulk edit on a large list use **Actions → Edit all filtered records** which doesn't require manual selection.
</Warning>

## Frequently asked questions

<AccordionGroup>
  <Accordion title="Can I use inline cell formulas like Excel (e.g. =SUM(A1:A10))?">
    Not inline. Formulas are defined as computed columns (see [Filters and formulas](/en/lists/filters-and-formulas)).
  </Accordion>

  <Accordion title="Are changes auto-saved?">
    Yes, every cell commit saves immediately. You can always undo with Cmd+Z.
  </Accordion>

  <Accordion title="Can I paste from Excel?">
    Yes. Copy a range from Excel/Google Sheets → click the starting cell in Arya → Cmd+V. Row/column structure is preserved.
  </Accordion>
</AccordionGroup>