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

# Create and Edit a Sheet

> Create a manual sheet, choose column types, edit cells, and maintain your saved tracking information.

Start with a manual sheet when you want to track information you enter yourself. For live records from CoachIQ, use [Connect live data](/tools/sheets/connect-live-data).

## Create your sheet

1. Open **Tools → Sheets** as an organization Admin.
2. Select **Create sheet**.
3. Enter a descriptive name, such as **Fall camp equipment** or **Client follow-ups**.
4. Select **Create sheet** to open the grid.

<Frame caption="Name the sheet before opening its grid.">
  <img src="https://mintcdn.com/coachiq/WBldhXepnUfWNDfK/images/sheets/create-sheet.png?fit=max&auto=format&n=WBldhXepnUfWNDfK&q=85&s=3cabceed0e8da154ad57266be52f152f" alt="Create a sheet dialog with a Sheet name field" width="1920" height="936" data-path="images/sheets/create-sheet.png" />
</Frame>

## Add columns

Choose **Add column**, enter the column name, select its type, and save. Pick a type that matches the information you want to enter:

| Type            | Example                                        |
| --------------- | ---------------------------------------------- |
| Text            | Equipment name or a follow-up note             |
| Number          | Quantity or a score                            |
| Date            | A target follow-up date                        |
| Single select   | One status: Not started, In progress, Complete |
| Multiple select | Several relevant categories                    |

For select columns, enter the available options in the column setup. A new column is available across the sheet's rows.

<Frame caption="Choose the column's type before entering values.">
  <img src="https://mintcdn.com/coachiq/WBldhXepnUfWNDfK/images/sheets/add-column.png?fit=max&auto=format&n=WBldhXepnUfWNDfK&q=85&s=e83d7eae6486a0205d02d8eb6aca119e" alt="Add a column dialog with name and type controls" width="1920" height="936" data-path="images/sheets/add-column.png" />
</Frame>

<Note>
  Changing an existing column's type is not currently available. If you chose the wrong type, add a new column with the correct type and move the information you need before removing the old column.
</Note>

## Add rows and edit cells

Use **Add row** in a manual sheet. Double-click a custom cell to edit it, then use **Save** or **Cancel** in the editor. Enter values that match the column type; for example, a Number column expects a number.

A simple equipment checklist might contain **Item** (Text), **Quantity** (Number), **Needed by** (Date), and **Status** (Single select). Each row is one item. Start with a few rows so you can check the structure before adding the rest.

Custom columns can also sit beside connected data. Live source values are read-only; edit them through the source record rather than trying to overwrite them in the grid.

## Rename, sort, and hide columns

Open the column's menu to rename it, sort, filter, hide it, or delete a custom column. Hiding a column changes the view; deleting it removes that column's saved values. Live columns have different controls because the source owns them.

Use the sheet's column visibility controls to show a hidden column again. For filters and totals, see [Use your sheet](/tools/sheets/use-your-sheet).

## Keyboard controls

Open **Shortcuts** in the sheet to see the available keys. The grid supports arrow-key navigation, **Enter** or **F2** to edit, **Escape** to cancel, and **Cmd/Ctrl+F** for search. Follow the editor's Save/Cancel controls when entering values.

## Manage the sheet

The sheet actions menu includes rename, export, duplicate, column visibility, shortcuts, and delete. Give duplicated sheets a name that makes their purpose clear.

Deleting a sheet is irreversible. It removes the sheet's tracking information, while connected CoachIQ source records remain. Export any information you need before confirming deletion.

<Card title="Bring CoachIQ records into a sheet" icon="link" href="/tools/sheets/connect-live-data">
  Learn the difference between all matching records, selected records, and your custom columns.
</Card>
