> ## 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.

# Connect Live Data to a Sheet

> Choose a CoachIQ data source, select records, and understand live columns, refresh, replacement, and unlinking.

Connect a sheet when the information already exists in CoachIQ. The connection supplies the source records; you can add custom columns for your own notes and tracking.

## Choose a source

1. Create or open a sheet in **Tools → Sheets**.
2. Select **Connect data**.
3. Choose the type of CoachIQ record you want to work with.
4. Review the preview and record selection.
5. Read the confirmation before connecting, especially if the sheet already contains data.

<Frame caption="Choose one source for the sheet. This example already contains manual data, so the confirmation is a replacement action.">
  <img src="https://mintcdn.com/coachiq/WBldhXepnUfWNDfK/images/sheets/live-sources.png?fit=max&auto=format&n=WBldhXepnUfWNDfK&q=85&s=f8e099e3b44b022e16bfa636e640114d" alt="Connect CoachIQ data dialog showing the ten available source types" width="1920" height="936" data-path="images/sheets/live-sources.png" />
</Frame>

The source picker offers **People, Staff, Products, Schedulers, Programs, Forms, Subscriptions, Payments, Coupons, and Bookings**. Access to a source still depends on your permissions. Choose the source that represents the rows you want: a scheduler defines a schedule, while bookings represent participation in sessions.

<Note>
  **Forms** means form records. It does not import submitted answers automatically. Review answers in [Forms → Responses](/tools/forms/responses-and-automations).
</Note>

## Choose which records belong in the sheet

| Selection            | Use it when                                                                      |
| -------------------- | -------------------------------------------------------------------------------- |
| All matching records | You want the sheet's membership to follow the connected source selection.        |
| Specific records     | You want a fixed set of records while their connected values continue to update. |

A fixed selection is still live data. It fixes which records are included; it is not a frozen export of their values. Check the selected records before connecting, including selections made across searches.

If the preview is empty, check the group, permissions, source, and any filters. An empty preview does not prove that your entire business has no records.

## Understand live and custom columns

Live headers have a link indicator. Their values come from CoachIQ and cannot be edited directly in the sheet. Use a linked row's **Open in CoachIQ** action to reach the original record.

Your custom columns hold information you add yourself, such as a follow-up status or internal note. Keep that distinction in mind: typing a status in a custom column does not change a product, session, tag, or client profile.

Use the refresh control when you need current values and check the displayed update status. If a refresh fails, resolve the error before treating the sheet as current. An exported file is a snapshot from the time you downloaded it.

## Replacing a source or existing sheet data

Connecting data to a populated manual sheet, or using **Replace live source**, is a replacement workflow. Read the warning and review what will be replaced before confirming. Export existing work first if you need to keep it.

To keep both your current sheet and a new connected view, create a separate sheet and connect it there.

## Unlink live data

Use **Unlink live data** from the connected sheet's actions menu when you want to stop updates. The confirmation explains that rows and custom values remain, while live values stop updating. Review that message before proceeding.

Unlinking affects the sheet's connection; it does not delete the original CoachIQ records. Once unlinked, the retained values should be treated as a snapshot.

## Troubleshooting

<AccordionGroup>
  <Accordion title="I can see a record in CoachIQ but not in my sheet">
    Check the connected source, group, filters, and whether you chose a fixed set of records. Refresh after checking those settings. A record outside a fixed selection will not be included just because it exists in CoachIQ.
  </Accordion>

  <Accordion title="I cannot edit a cell">
    Check whether its column is live. Live values are edited in the original CoachIQ area; custom values are edited in Sheets.
  </Accordion>

  <Accordion title="Connecting data asks me to replace something">
    The sheet already has data or a live source. Cancel and create a separate sheet if you want to preserve the existing view. Otherwise export what you need and review the replacement confirmation carefully.
  </Accordion>
</AccordionGroup>

[Next: filter, export, and act on your sheet](/tools/sheets/use-your-sheet).