Convert several Excel files (*.xlsx) to CSV files with the same name and sheets

[mkankatala (Mahesh Kankatala)]

Hi @Anaskra

=> Use for each file in folder activity to iterate the files in the folder. In the filter by option give like “*xlsx”.
=> Inside for each Insert the Use excel file activity and pass the CurrentFile.toString in the Path of file.
=> Inside for each activity take an assign activity to store the file name create a variable called FileName (String Datatype).

• Assign → FileName = CurrentFile.Name (Which stores the excel file name)
  => Take for each excel sheet activity to iterate the sheets in the excel. Output - CurrentSheet
  => Inside for each excel sheet activity insert the Read range activity to read the CurrentSheet data and store in to a datatable variable called dtExcelData.
  => After Read range activity place the Write CSV activity to write the datatable data to csv file.
  In Write from field give the dtExcelData Variable.
  In Write to what file give the Path of the csv file and give the name of excel name to csv.
  Path - “C:\Users\Downloads"+FileName+”.csv"

In the Path give the csv path. FileName is the variable which stored the Excel file name.

Check the below workflow for better understanding.

Hope it helps!!