---
id: xlsxwriter
version: "3.2.9"
license: BSD-2-Clause
license_treatment: permissive
maintenance: active
---

# xlsxwriter — A Python module for creating Excel XLSX files.

License: permissive · Maintenance: active · Popularity: top 1,000 on PyPI

## Install

pip install xlsxwriter
uv add xlsxwriter
poetry add xlsxwriter

## Description

XlsxWriter
==========

**XlsxWriter** is a Python module for writing files in the Excel 2007+ XLSX
file format.

XlsxWriter can be used to write text, numbers, formulas and hyperlinks to
multiple worksheets and it supports features such as formatting and many more,
including:

* 100% compatible Excel XLSX files.
* Full formatting.
* Merged cells.
* Defined names.
* Charts.
* Autofilters.
* Data validation and drop down lists.
* Conditional formatting.
* Worksheet PNG/JPEG/GIF/BMP/WMF/EMF images.
* Rich multi-format strings.
* Cell comments.
* Integration with Pandas and Polars.
* Textboxes.
* Support for adding Macros.
* Memory optimization mode for writing large files.

It supports Python 3.8+ and PyPy3 and uses standard libraries only.

Here is a simple example:

.. code-block:: python

   import xlsxwriter

   # Create an new Excel file and add a worksheet.
   workbook = xlsxwriter.Workbook("demo.xlsx")
   worksheet = workbook.add_worksheet()

   # Widen the first column to make the text clearer.
   worksheet.set_column("A:A", 20)

   # Add a bold format to use to highlight cells.
   bold = workbook.add_format({"bold": True})

   # Write some simple text....

## AI interpretation — verify before relying

XlsxWriter creates Excel 2007+ XLSX files from Python, supporting text, numbers, formulas, charts, formatting, images, and data validation without external dependencies.

Verdict: XlsxWriter is a stable, actively maintained library for generating Excel files with no external dependencies. Its permissive BSD license, broad Python version support, and zero-friction installation make it a low-risk choice for spreadsheet generation tasks.

[View on SkillFed](https://skillfed.io/packages/xlsxwriter) · [View on PyPI](https://pypi.org/project/xlsxwriter/)