It offers a single API for reading, writing, and tweaking data in various spreadsheet formats, including CSV, XLS, XLSX ... Openpyxl Python library is designed to read and write Excel files.

To work with csv and xlsx files the easiest package is the pandas package because it has the functionality to edit and subset the data along with writing the edited data back to a csv or excel ...