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

# Excel Reader component

> Load Excel workbooks (.xlsx and .xls) into your ClickML Studio pipeline as a DataFrame, with sheet selection and header configuration options.

The **Excel Reader** reads `.xlsx` and `.xls` files. It works the same way as the CSV Reader but for spreadsheet files.

## Configuration

| Option         | Description                                                      | Default           |
| -------------- | ---------------------------------------------------------------- | ----------------- |
| **Source**     | `Upload` to load a local file, `URL` to fetch from a web address | Upload            |
| **File**       | The Excel file to upload                                         | —                 |
| **URL**        | A direct link to a publicly accessible Excel file                | —                 |
| **Sheet Name** | The name or index (0-based) of the sheet to read                 | `0` (first sheet) |

## Input / Output

|        | Type      |
| ------ | --------- |
| Input  | None      |
| Output | DataFrame |

## Notes

* Only one sheet is read per component. To load multiple sheets, add multiple Excel Reader components and connect them with a **Concatenate** component.
* Merged cells and non-tabular formatting in your spreadsheet may cause unexpected results. Use a clean, flat table layout.