# read_excel()

*noun*

say it: **“REED ek-SEL”** **/ˈrid ɪkˈsɛl/**

A pandas function that reads one sheet of an Excel workbook into a table that Python can work with.

## What does **read_excel()** do in pandas?

**read_excel()** (`pd.read_excel`) loads one sheet of an Excel workbook (`.xlsx`) into a DataFrame. `sheet_name`
picks the sheet, the first one by default, and `skiprows` steps over title rows above the real column names. It needs
the openpyxl package installed.

```python
import pandas as pd
vendors = pd.read_excel("vendors.xlsx", sheet_name="2026", skiprows=2)
vendors.head(4)
```

## In a sentence

- “Two title rows sat above the headers, so he gave **read_excel()** skiprows=2.”
- “**read_excel()** loaded the 2026 sheet of the vendor workbook.”

Level: Journeyman · [More Python terms at this level](https://www.ask-codey.com/glossary?category=python&level=3)

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/read-excel
