CSV (Comma Separated Values) is a commonly used file format to keep, import, and export data from one application to another. Furthermore, most of the datasets in the field of data science are stored in CSV files. However, in certain cases, you have to convert comma separated values in CSV to tabular form in Excel’s XLSX or XLS workbooks. For such scenarios, this article covers how to convert CSV files to Excel in Python.
Python CSV to Excel Converter API
In order to convert CSV to Excel’s XLSX or XLS formats, 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 CSV to Excel in Python
The following are the steps to convert a CSV file to Excel XLSX or XLS format.
- Create an object of LoadOptions class and initialize it with FileFormatType.CSV.
- Create an object of the Workbook class and initialize it with the CSV file’s path and LoadOptions object.
- Convert CSV to Excel using Workbook.save(String, SaveFormat.XLSX) method.
The following code sample shows how to convert CSV file to Excel in Python.
CSV File
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,205Converted Excel File
Get 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 CSV files to Excel 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.
