petl - Extract, Transform and Load

petl is a general purpose Python package for extracting, transforming and loading tables of data.

petl use cases diagram



  • Version 2.0 will be a major milestone for petl.
  • This version will introduce some changes that could affect current behaviour.
  • We will try to keep compatibility to the maximum possible, except when the current behavior is inconsistent or have shortcomings.
  • The biggest change is the end of support of Python 2.7.
  • The minimum supported version will be Python 3.6.

Getting Help

Please feel free to ask questions via the mailing list (

To report installation problems, bugs or any other issues please email or raise an issue on GitHub.

For an example of petl in use, see the case study on comparing tables.


For an alphabetic list of all functions in the package, see the Index.

Indices and tables