Python for Excel

Best Open-Source Python Libraries for Excel

XlsxWriter
- 2285
- 481
- 25
XlsxWriter is a Python module for writing files in the Excel 2007+ XLSX file format.
xlrd
- 1794
- 392
- 3
xlrd is a library for reading data and formatting information from Excel files, whether they are .xls or .xlsx files
xlwings
- 1741
- 332
- 281
Automate Excel with Python on Win & macOS. Works great for macros, UDFs, reporting, unit tests & REST API.
xlwt
- 954
- 270
- 8
xlwt is a library for writing data and formatting information to older Excel files (ie: .xls)
pyexcel
- 814
- 129
- 7
pyexcel provides one application programming interface to read, manipulate and write data in various excel formats.
pycel
- 381
- 97
- 18
A library for compiling excel spreadsheets to python code & visualizing them as a graph
PyExcelerate
- 361
- 40
- 9
Accelerated Excel XLSX writing library for Python
xlutils
- 252
- 77
- 1
Utilities for working with Excel files that require both xlrd and xlwt.
formulas
- 100
- 30
- 2
Excel formulas interpreter in Python
openpyxl
- 100
- 31
- 1
openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.
pylightxl
- 91
- 7
- 2
A light weight, zero dependency, minimal functionality excel read/writer python library
Koala
- 65
- 45
- 59
Transpose your Excel calculations into python for better performances and scaling.
pyxlsb
- 41
- 15
- 4
Excel 2007+ Binary Workbook (xlsb) reader for Python
hotxlfp
- 11
- 1
- 1
A Python Excel Formula Parser similar to the javascript handsontable formulaparser
vb2py
- 11
- 4
- 2
The vb2Py project is developing a suite of conversion tools to aid in translating existing VBA projects into Python.
xltable
- 4
- 3
- 2
xltable is an API for writing tabular data and charts to Excel.