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 originated from the common usability problem: when an excel file driven web application is delivered for non-developer users (ie: team assistant, human resource administrator etc). The fact is that not everyone knows (or cares) about the differences between various excel formats: csv, xls, xlsx are all the same to them. Instead of training those users about file formats, this library helps web developers to handle most of the excel file formats by providing a common programming interface. To add a specific excel file format type to you application, all you need is to install an extra pyexcel plugin. Hence no code changes to your application and no issues with excel file formats any more. Looking at the community, this library and its associated ones try to become a small and easy to install alternative to Pandas.

Feature Highlights

Also available on