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.