excelToCSV

The xlsxToCsv package contains the ability to convert .xlsx file to a .csv file that is more consumable by many other packages/programs/scripts.

The source code for this package is available at https://github.com/willmichel81/excelToCSV.

The importable name of the package is excelToCSV

Import into your code

>>> from excelToCSV import excelToCSV

Test to make sure package is connecting

>>> pip install xlsxToCsv
>>> python
>>> from excelToCSV import excelToCSV
>>> test = excelToCSV(C:/complete/path/to/file/example.txt)
>>> print(test)

If you have succesfully installed xlsxToCsv then you should get the following results from the above code

"('C:/complete/path/to/file/', '.txt')"

Short Summery

Takes user specified range data (ex. A1:A16) data from sheet(s)(ex. "MAIN") in side of .xlsx and then converts data to json dict and/or csv.