Convert xlsb to google sheets using google app script

8.6k Views Asked by At

I would like to convert xlsb format file into google sheets using google app script.

2

There are 2 best solutions below

0
On

This is not possible

Referring to the documentation here, Google Docs supports:

.xls (if newer than Microsoft® Office 95)
.xlsx
.xlsm
.xlt
.xltx
.xltm
.ods
.csv
.txt
.tsv
.tab

If you need to use an XSLB file, first convert it using Office or another converter to one of the above formats.

Alternatively, if you are skilled and brave, you can tackle the XLSB Specs to see if there is a way to convert the binary to something understandable using Apps Script!

If this is important to you and your business, I suggest you file a well justified feature request so that Google might consider implementing it.

0
On

I think it's not possible.

You need to use some MS's tools for converting xlsb to xlsx before anything.