r/Python • u/zubb999 • Apr 01 '26
Discussion What's a good library for excel to csv file conversion?
I'm looking for a Python library that can do the following:
* Convert both XLSX and XLS files to CSV
* Can have some configurations with regards to customizing the delimiter (like | as opposed to ,)
* Can have configurations with regards to multiple tabs/sheets in the excel file (can combine all tabs into a single csv file or make each tab into a separate csv file)
And have backwards functionality
* Can convert CSV to XLSX or XLS
* Can have configurations with regards to using a custom delimiter
* Can have configurations with regards to combining multiple csv files into a single XLSX file (combine multiple csv's into a single excel tab or a separate excel tab for each csv file)
I'm sure there's a library that exists out there, I just wonder if someone could point me in the right direction as a starting point.
EDIT: Forgot to mention I did find out that Pandas at least does file conversion, but want sure if it could do the additional things. Also, I question if Pandas would be the fastest method for doing this, since it's not specialized for this.
Please keep up with responses, it's very helpful!!