Unanswered

Automate converting files from xlsb to xlsx

(4) Share

Report

Posted on by cferv_77

Hello,

I’m new to Power Automate and would like to know this is possible and if so, any references/resources would be greatly appreciated.

I have a SharePoint (SP) folder containing xlsb (Excel Binary) files and I want to create a Power Automate to take these files and save them as an xlsx file in a different SharePoint folder. And this only applies to files with a certain string in the filename (a condition). Because these files are updated through out the day, would like to run it once by end of day, overwriting files saved in the other SP.

Is this possible with Power Automate? I could not find a template involving file conversion.

Please and thank you.

Categories:

General topics

I have the same question (2)

All responses (4)

Answers (0)

S_PBI 4 on at

Like (1)

Report

@cferv_77 I'm trying to solve the same problem, curious to see if you found a way.

Was this reply helpful? Yes No
cferv_77 71 on at

Like (1)

Report

@S_PBI

We ended up using a macro based on a script found on Stack Overflow:
excel - How to change 100 files from .xlsb to .xlsx in a folder - Stack Overflow

We made some modification to make it point to the SharePoint path where the xlsb files are located. It loops through all the xlsb files and saves them one by one as an xlsx file.

Hope that helps.

Was this reply helpful? Yes No
JemmaKSS 97 on at

Like (0)

Report
Hi!
not sure if you had any success with this but I have managed to get around this for tabled data only by converting to csv:

create a table in the xlsb file using office script if you dont already have a named table range in the workbook
use list rows connector to read rows
create csv table
create file using csv data
We use this for Power BI as Power BI can read csv without plug ins.

it doesnt result in an xlsx file but if you can use csv maybe its a solution?

Was this reply helpful? Yes No
Gimlic 2 on at

Like (0)

Report

Since this is the top google result for "Convert .xlsx to .xlsb". Here is what I came up with for Power Automate:

Was this reply helpful? Yes No