Hi all

I have a large folder containing multiple xlsx (only one sheet) files which I need to convert to a csv format.
I can convert them individually using the xlsx2csv but I cannot make a working function that loops over all the files in the folder and saves them with the same names as the xlsx-files but as csv.

I have been searching a lot of different forums, but I have been unable to find a helpful thread.

Can anyone help me?


I do the individual conversion like the following:

from xlsx2csv import *
xlsx2csv("dir\ID_01.xlsx", open("ID_01.csv", "w+"))

And that converts the file ID_01.xlsx into ID_01.csv.