In this blog, you are going to learn about how to export data from a CSV file to Excel XLS or XLSX in Python within a few easy steps. You can easily integrate this CSV to Excel conversion into your Python applications.
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 XLS XLSX in Python.
- Python CSV to Excel Converter Library - Free Download
- Easy Steps to Convert CSV to Excel
- Convert CSV to Excel XLSX or XLS
Python CSV to Excel Converter - Free Download
In order to convert CSV to Excel’s XLSX or XLS, we will use Aspose.Cells for Python via Java. It is a high-speed and powerful spreadsheet manipulation library that allows you to create, modify or convert Excel files. Using the library, you can easily perform back and forth conversion of Excel XLS/XLSX files. You can install the API using the following command.
pip install aspose-cells
How to Convert CSV to Excel XLS in Python
The conversion of CSV files to Excel using Aspose.Cells for Python is as simple as pie. The following steps are required for Python CSV to Excel conversion.
- Load the CSV file using its path.
- Save CSV file in Excel format to the desired location.
And that’s it. The following section demonstrates how to transform the above-mentioned steps into code and perform CSV to Excel conversion in Python.
Save CSV as XLS in Python
The following are the steps to convert a CSV file to XLSX or XLS in Python.
- 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 XLS 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,205
CSV to Excel XLS - Conversion Result
CSV to XLS Python Converter - Get a Free 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 XLS XLSX 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.