Skip to content
GlobalProjects

Working in the spreadsheet

The requirements spreadsheet, explained for someone who knows Excel — typing, moving around, adding rows, changing where a row sits, and what is different.

Updated 19 October 2026

Who this is for: business analysts.

If you have kept requirements in Excel, the spreadsheet will feel familiar. Each row is a requirement, each column is a field, and you type straight into the cells. The difference is that the rows form a tree: a story sits inside a feature, which sits inside an epic.

Open your project, choose Requirements in the left navigation, then choose Spreadsheet at the top of the page.

Type into the grid

  1. Click a cell, or move to it with the arrow keys.
  2. Start typing, double-click, or press Enter to edit the cell.
  3. Press Enter or Tab to keep your change. Press Esc to cancel it.
  4. For MoSCoW, Status, Priority and Owner, click the cell and pick from the list. The Status list only offers the moves your project allows.
  5. To fill a long field, use Acceptance Criteria one criterion per line. Press Shift+Enter for a new line inside the cell.
The requirements spreadsheet with epics and features expanded, a Title cell being edited, and the toolbar with Expand all, Collapse all and Export CSV.
Fictional demonstration project. All names and details are invented and do not represent any real organisation, including any that shares a name with it.

Add rows

  1. Click + at the start of a row. On a group (an epic or a feature) it adds a row inside it. On a requirement it adds a row directly below, with the same parent.
  2. Or go to the last row and press Enter. The new row keeps the parent of the row you were working in.
  3. Press Ctrl+Enter (⌘+Enter on a Mac) to add a row beside the current one, at the same level.
  4. The new row's title reads New requirement. Double-click it and type the real title.

Change where a row sits

  1. Click a cell in the ID or Title column. The strip under the grid says Hierarchy mode.
  2. Press Tab to make the row a child of the row above it.
  3. Press Shift+Tab to move it out one level.
  4. To see and change any row's parent directly, choose Show parent in the toolbar and use the Parent column.
  • The requirements hierarchy

    How requirements sit inside each other, how to add, move and delete them in the Hierarchy view, and the five ways to look at the same requirements.

  • Paste requirements from Excel

    Copy a range from Excel, map its columns, check a preview and create the requirements in one go — nothing is created until you confirm.

  • Export to Word and Excel

    Download your requirements as a CSV that Excel opens, or as a Word document, and see who your project lets export.