Convert XSLX to CSV in a single line

Py

Convert a XLSX file to a CSV in one line

First, install the necessary modules.

pip install pyexcel
pip install pyexcel-xlsx

Then, follow below:

from pyexcel.cookbook import merge_all_to_a_book
import glob
merge_all_to_a_book(glob.glob("my_xslx_directory/my_xlsx.xslx"), "output.csv")

That’s it! 🙂

P.S. You can also do CSV to XLSX conversion too.

from pyexcel.cookbook import merge_all_to_a_book
import glob
merge_all_to_a_book(glob.glob("my_csv_directory/my_csv.csv"), "output.xlsx")
GitHubGitHubLinkedin