Python for Excel

Best Open-Source Python Libraries for Excel

XlsxWriter
- 3372
- 623
- 10
XlsxWriter is a Python module for writing files in the Excel 2007+ XLSX file format.
xlwings
- 2744
- 480
- 308
Automate Excel with Python on Win & macOS. Works great for macros, UDFs, reporting, unit tests & REST API.
xlrd
- 2104
- 443
- 3
xlrd is a library for reading data and formatting information from Excel files, whether they are .xls or .xlsx files
pyexcel
- 1147
- 164
- 19
pyexcel provides one application programming interface to read, manipulate and write data in various excel formats.
xlwt
- 1028
- 294
- 8
xlwt is a library for writing data and formatting information to older Excel files (ie: .xls)
pycel
- 532
- 143
- 19
A library for compiling excel spreadsheets to python code & visualizing them as a graph
PyExcelerate
- 489
- 62
- 23
Accelerated Excel XLSX writing library for Python
formulas
- 300
- 68
- 13
Excel formulas interpreter in Python
pylightxl
- 276
- 46
- 22
A light weight, zero dependency, minimal functionality excel read/writer python library
xlutils
- 270
- 81
- 1
Utilities for working with Excel files that require both xlrd and xlwt.
openpyxl
- 162
- 41
- 1
openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.
nb2xls
- 152
- 30
- 1
Jupyter notebooks to Excel Spreadsheets
Koala
- 133
- 59
- 65
Transpose your Excel calculations into python for better performances and scaling.
pyxlsb
- 82
- 24
- 11
Excel 2007+ Binary Workbook (xlsb) reader for Python
XlsxPandasFormatter
- 63
- 16
- 1
Deals with the limitations of formatting when using Pandas dataframe and xlsxwriter to export to Excel format
xls2slsx
- 44
- 17
- 11
Convert xls file to xlsx
vb2py
- 31
- 9
- 2
The vb2Py project is developing a suite of conversion tools to aid in translating existing VBA projects into Python.
hotxlfp
- 25
- 10
- 2
A Python Excel Formula Parser similar to the javascript handsontable formulaparser
xltable
- 14
- 7
- 2
xltable is an API for writing tabular data and charts to Excel.