# Open a run in Excel or pandas

# Open a run in Excel or pandas

Save one run to a folder, then open its data in a spreadsheet or a notebook.

## Before you start

- Phloem Computer, with a recorded run. See [Runs](https://phloem.ai/docs/review/runs/).
- Excel, or Python with pandas (and pyarrow for Parquet).

## Steps

1. Open **Replay** and the **runs** tab on the left.
2. Find the run. Type part of its name in **Filter runs**.
3. Open the run's menu and choose **Download…**. The **Download data** sheet
   opens on that run.
4. **When** already holds the run. Press **Next**.
5. Under **What**, pick **Everything**, or **Choose** and tick channels. Press
   **Next**.
6. Under **How**, pick **Save as**:
   - **Spreadsheet** for Excel. Under **Details**, **Table** offers
     **a file per rate**, **one wide file** or **a row per sample**.
   - **Notebook** for pandas.
7. Press **Review**. Check the folder's file list.
8. Press **Download**, then **Show in folder**.

## Open it

In Excel, open a file from `data/`. Column `t_s` is seconds from the start of
the window. Each column after it is a channel. `channels.csv` maps each column to
its full channel path and unit.

In pandas, read the Parquet file. It holds one row per sample:

```python
import pandas as pd

df = pd.read_parquet("data/signals.parquet")
# columns: t_us, path, value_f64, value_text, kind
wide = df.pivot_table(index="t_us", columns="path", values="value_f64")
```

`t_us` is the exact time in microseconds since 1970 (UTC).

## Check it worked

- The folder holds `README.txt`, `channels.csv`, `data/` and `details/`.
- The README names every data file with its columns and units.
- A long run's CSV continues in `_part2.csv`, `_part3.csv`… Each part opens on
  its own in Excel.

> **Tip:** Excel set to a comma decimal? Under **Details**, set the decimal
> separator to **1,5**. The column separator switches to **Semicolon**.

- [Export data](https://phloem.ai/docs/review/export/): Every format and setting
- [Runs](https://phloem.ai/docs/review/runs/): Record and find runs
- [Replay](https://phloem.ai/docs/review/replay/): Choose a window instead of a run