Excel spreadsheets are widely used to keep, import, or export data from one application to another. In addition, you can perform various operations on data, such as sorting, applying mathematical formulas, generating charts, etc. However, in various cases, Excel’s XLSX or XLS workbooks are required to be converted to CSV (Comma Separated Values) format. For such scenarios, this article covers how to convert Excel files to CSV in Python.
Python Excel to CSV Converter API
In order to convert Excel’s XLSX or XLS formats to CSV, we will use Aspose.Cells for Python via Java. It is a powerful spreadsheet manipulation API that allows you to create, modify or convert Excel files. You can install the API using the following command.
pip install aspose-cells
Convert Excel File to CSV
The following are the steps to convert an Excel XLSX or XLS file to CSV in Python.
- Load Excel file using Workbook class.
- Convert Excel to CSV using Workbook.save(String, SaveFormat.CSV) method.
The following code sample shows how to convert an XLSX file to CSV in Python.
Excel File
Converted CSV
My Data,,,,,,,
Items A,Items B,Items C,Items D,Items E,Items F,Items G,Items H
12,23,33,66,11,87,99,33
23,22,33,77,31,22,45,56
34,11,12,23,22,34,11,12
45,43,54,88,36,45,45,37
65,65,65,65,13,65,9,35
34,22,27,22,32,23,23,32
213,186,224,341,145,276,232,205Get a Free API License
You can use the API without evaluation limitations by requesting a free temporary license.
Conclusion
In this article, you have learned how to convert Excel files to CSV in Python. You can explore more about the Python spreadsheet API using the documentation. In case you would have any questions or queries, feel free to let us know via our forum.
