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

# Spreadsheet mapping

> Map your UAT spreadsheet to SimpleUAT suites, cases, runs, findings, and deliveries.

You don't need a new testing process. You need a place for each column you already maintain. The platform stores results so you do not rebuild the spreadsheet.

<Tip>
  Import the file if you have one: [Excel / CSV matrix](/imports/excel) or [Smart Import](/imports/smart-import). This page is the mental map.
</Tip>

## Sheet tab to project

The workbook named "Acme UAT" is a **project**. If you had one sheet per product (iOS vs web), that is still usually one project with a type (`web`, `ios`, `android`, and so on), not a new product record. Most freelancers only need **Projects**. [Project vs Application](/concepts/projects-products).

## Header rows you always typed

* **Staging URL** to **Environments** (`name`, `base_url`). [Environments](/concepts/environments).
* **Test as Admin / Guest** to **Personas**. [Personas](/concepts/personas).
* **Sprint / round / "UAT 3"** to **Test cycle**. [Cycles vs runs](/concepts/cycles-vs-runs).

## Checklist rows to cases

A row like "Guest checkout with Visa" is a **test case** inside a **suite** (the grouping tab or section heading).

Typical columns land like this:

* **ID / title** to case title
* **Steps** to case steps (`instruction`, `expected_result`, notes, evidence required)
* **Expected** to `expected_outcome` (and per-step expected result)
* **Preconditions / data** to `preconditions`
* **Priority** to `low` | `medium` | `high` | `critical`
* **Module / area** to `module`
* **Tags** to tags
* **Persona** to `required_persona_id`
* **Estimate** to `estimated_duration_minutes`

[What is a case](/tests/what-is-a-case).

## Result columns to a run (not the case)

`Pass / Fail / Blocked` on Tuesday is **this run**, not a rewrite of the master script. Case results: `passed` | `failed` | `blocked` | `skipped` | `in_progress`. Steps: Pass, Fail, Blocked, N/A (plus not run until you touch them). [Statuses](/concepts/statuses).

The master list stays reusable. That is the benefit versus coloring cells in the source sheet.

## Bug tab to Findings

Severity, status, screenshots, "link to Jira-123": that is **Findings**. URL path is `/defects`; the UI says Findings. Jira in SimpleUAT is **links only**. [Jira](/findings/jira). GitHub Issues can create issues from defects if you connect it.

## Status email to delivery + export

The recap is a **delivery snapshot** plus an export (PDF, HTML, Word, Excel, and more; plan-gated). You don't paste counts by hand. [Exports](/delivery/exports).

## Reusable checklist workbook to pack

The "checkout regression v4" file you copy for every storefront client is a **Test Suite Pack**. Install it into the project; then it's normal suites and cases. You cannot currently "save this project back as a pack" from the project. Build packs with **New pack**, JSON import, or Generate with AI (the last two are plan-gated). [Own pack](/playbook/own-pack).

<Columns cols={2}>
  <Card title="Import the file" icon="upload" href="/imports/bring-existing">
    Smart Matrix and unified Smart Import.
  </Card>

  <Card title="Write the first test by hand" icon="pen-line" href="/start-here/first-test">
    If the sheet isn't worth importing.
  </Card>
</Columns>