Python Excel Libraries
For a python library for manipulating excel files, the strongest matches are jmcnamara/xlsxwriter (This library is a specialized tool for creating and), pandas-dev/pandas (Pandas is a primary tool for data manipulation that) and xlwings/xlwings (This library allows you to automate Excel by controlling). pyexcel/pyexcel is also worth a look. Each is ranked by relevance to your query, popularity and recent activity.
We curate open-source GitHub repositories matching “best python excel libraries”. Results are ranked by relevance to your query — pick filters below to narrow, or refine with AI.
Python Excel Libraries
Find the best repos with AI.We'll search the best matching repositories with AI.
- jmcnamara/xlsxwriter
jmcnamara/XlsxWriter
3,911View on GitHubXlsxWriter is a library for generating spreadsheets in the XLSX format, functioning as an Excel workbook writer and file generator. It provides the capability to write data, apply cell formatting, and build complex layouts across multiple worksheets. The project distinguishes itself with a memory-optimized writing mode that flushes large datasets to disk row-by-row, enabling the creation of files exceeding 4 GB while minimizing RAM consumption. It also includes a specialized mechanism for embedding binary project files and digital signatures to enable VBA macros and signed scripts within work
This library is a specialized tool for creating and formatting XLSX files with high performance, though it is strictly a writer and lacks the ability to read or modify existing spreadsheet files.
PythonCell Styling SystemsXLSX File Generation - pandas-dev/pandas
pandas-dev/pandas
49,039View on GitHubPandas is a high-performance data analysis library that provides a comprehensive framework for manipulating, cleaning, and transforming structured datasets. It centers on labeled one-dimensional and two-dimensional data structures, allowing users to construct, filter, and reshape tabular information while performing complex arithmetic and logical operations. The library distinguishes itself through a sophisticated indexing engine that enables automatic data alignment during calculations and relational merges. By utilizing a block-based memory layout, it optimizes cache locality for vectorized
Pandas is a primary tool for data manipulation that includes robust built-in IO drivers for reading and writing Excel files, making it a standard choice for programmatic spreadsheet interaction despite its broader focus on data analysis.
PythonData Analysis LibrariesData Manipulation FrameworksDataframe Constructors - xlwings/xlwings
xlwings/xlwings
3,312View on GitHubxlwings - Make Excel fly with Python!
This library allows you to automate Excel by controlling the application directly via Python, providing robust support for reading, writing, and styling spreadsheets while integrating seamlessly with Pandas.
PythonExcel AutomationPython-Excel Bridge LibrariesEmbedded Python Excel Add-Ins - pyexcel/pyexcel
pyexcel/pyexcel
1,283View on GitHubSingle API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files
This library provides a unified interface for reading and writing various spreadsheet formats including XLSX, making it a capable tool for programmatic data manipulation in Python.
PythonDocument and File ProcessingOffice Document Tools
