# openpyxl

*noun*

say it: **“OH-pun-PY-ek-SEL”** **/ˌoʊpənˈpaɪ ɛkˈsɛl/**

A Python package for reading and writing Excel workbooks, which pandas uses behind the scenes to open and save .xlsx files.

## What is **openpyxl**?

**openpyxl** is the Python library that reads and writes Excel `.xlsx` files. pandas uses it behind `read_excel()`
and `to_excel()`, so a project that opens workbooks lists it in `requirements.txt`, even if no line of its code
imports it.

```python
# requirements.txt has openpyxl==3.1.5; pandas uses it here
import pandas as pd
vendors = pd.read_excel("vendors.xlsx")
```

## In a sentence

- “pandas asked for **openpyxl** the first time she read a workbook.”
- “He added **openpyxl** to requirements.txt, though no line of his code imports it.”

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/openpyxl
