CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-drive-apixlsb
Harish Batchu
Harish Batchu

Reputation: 19

Convert xlsb to google sheets using google app script

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

Upvotes: 1

Views: 9408

Answers (2)

iansedano
iansedano

Reputation: 6481

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.

Upvotes: 2

oshliaer
oshliaer

Reputation: 4969

I think it's not possible.

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

Upvotes: 0

Related Questions