pyexcel - Let you focus on data, instead of file formats

      User: "I have uploaded an excel file"
            "but your application says un-supported file format"
 Developer: "Did you upload an xlsx file or a csv file?"
      User: "Well, I am not sure. I saved the data using "
            "Microsoft Excel. Surely, it must be in an excel format."
 Developer: "OK. Here is the thing. I were not told to support"
            "all available excel formats in day 1. Live with it"
            "or delay the project x number of days."

Fork Star

Feature Highlights

Time To Market

One pip-install command gets you the support for an additional excel format. No code changes required.

Highly Extensible

It is extremely easy to add a support for your own data format.

Data Streaming

A generator of data can be obtained when dealing with big data set.

Fully Optimized

Third party libraries(openpyxl, xlrd and xlwt) are pre-configured for optimal data reading and writing.

High Code Quality

98% of the code lines have been tested.
Code quality ranked at the highest level possible, L5

Fully Documented

The main code and its plugin library are well documented. Tutorials are provided too.

The idea behind pyexcel originated from a common usability problem: when Excel-driven web applications are delivered to non-developer users (e.g., project assistants, human resources administrators), they often are not aware of the differences between file formats such as CSV, XLS, and XLSX. Rather than training users on these formats, pyexcel provides web developers with a unified interface to handle most Excel file types. To add support for a specific Excel format in your application, simply install an additional pyexcel plugin—no code changes required. This eliminates issues with different file formats. In the broader community, pyexcel and its associated libraries aim to be a simple, easy-to-install alternative to Pandas, where minimal data manipulation is needed.

Feature Highlights

Also available on