Unanswered

Convert .xlsb file to .xlsx

(1) Share

Report

Posted on by keihimekawa

Hi!

Is it possible to convert .xlsb file into .xlsx? We're using tableau as our report development tool and one of the data sources is in SharePoint uploaded as .xlsb file. Unfortunately, tableau can only accept .xlsx file as data source and not .xlsb that's why we need to convert it to .xlsx. The .xlsb file is uploaded in SharePoint.

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

rebeccas 2,591 on at

Like (0)

Report

Have you tried doing a create file and forcing the file name change to .xlsx? I would try first by putting the file name as "Test.xlsx" or something and if that works you could figure out a way to strip off the xlsb and then refer to that for the name with the .xlsx on the end.

I have not tried it from a XLSB but I have from a CSV and it worked.

Was this reply helpful? Yes No
keihimekawa 99 on at

Like (1)

Report

Hi @rebeccas. Thanks for the suggections but this didn't work 🙁 It did create the file but Excel wasn't able to open it.

Was this reply helpful? Yes No
rebeccas 2,591 on at

Like (0)

Report

Well poo...I don't know then. I only tried it for the one and it works..guess this is different. Sorry.

If I think of anything else that you could try I will come back but so far that is only thing I have done that is similar.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

any workaround please let me know

Was this reply helpful? Yes No
GokuPe 4 on at

Like (0)

Report

Same problem, will try creating an xl with a macro that will open the xlsb and save it as xlsx

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

Was this reply helpful? Yes No
CU06081659-0 122 on at

Like (0)

Report

I have the same query. My xlsb file has too many sheets and the sheet I want to refer is not in a Table format. It comes from one of our Customers. Has there been any solution to this yet?

Was this reply helpful? Yes No