This flow saves all xslx excel files and each worksheet in the files as csv files.
Updated to save files named as filename + worksheet name.
Choose the source folder and then choose the destination folder and run or schedule the flow to run.
Explanation
If you work with excel online there is no option to save as csv. You would have to open each file on the desktop and save each worksheet as csv.
This flow will do this for you all online and it will even save each worksheet in the xlsx file as csv.
It is very simple to use.
It will require you to first make an office script.
Making the Office Script
Open excel online with a blank file or any xlsx file.
The format must be xlsx for the office scripts to be available.
Go to automate
Click all scripts
Make a new script and name it as you like
Open the script and you will see an empty main function
Copy this code inside the main function
// declare variables
let wbook = workbook;
// the workbook filename
let sheetnames = new Array({});
// worksheets in the work book
let sheets = wbook.getWorksheets();
// array of items
let items = new Array({});
// get each worksheet data set
for (let i = 0; i < sheets.length; i++) {
// try catch - errors when a sheet is blank and other possible errors
try {
items[i] = sheets[i].getUsedRange(true).getTexts();
sheetnames[i] = sheets[i].getName();
}
catch (any) { }
}
// return the worksheets array
return [items,sheetnames];
Save it and now you can close excel
Note: The office script is not embedded into the file you opened. Opening the file is the only way I know to get to the office scripts.
Prepare your flow steps
There are a couple of steps in the flow that you need to configure so it works in your environment.
You will also need Excel (Business) because Excel (OneDrive) does not offer the same flow actions.
Source files location
This probably has to be sharepoint location since the script runs out of sharepoint.
Choose your sharepoint site or change the action. If you change the action, you will need to put the "body" back in place in apply to each file loop action.
Update the run script action
Choose your script name.
The file ID should be available from the list files action.
This step should not be modified. It is made to save each worksheet in the xlsx file with the same file name appended with sheet name. So when you have multiple worksheets they will all have the same file name with each sheet name.
Note: If any of the fields in the actions disappear during import, I can provide them for you.
My Sample Run
