google-docs-publisher icon indicating copy to clipboard operation
google-docs-publisher copied to clipboard

Document too big .. what is the limit?

Open Bullinachinashop opened this issue 4 years ago • 3 comments

I have deliberately kept this lean

[https://docs.google.com/spreadsheets/d/1l3_QEkWcvRhQQn4ieYv3Mxbx6Pk3nMuhKx2bwQGUJcg/edit?usp=sharing]

so published under 30000 cells 27 tabs

Last night it worked .. now it is saying document too big ...

confused!?!

Bullinachinashop avatar Jul 21 '20 13:07 Bullinachinashop

Hello,

The limit of the document size is set to 1Mb.

I tried to download your file, and it appears to be exactly 1Mb big. In terms of cells, it is unpredictable how many that represents. You may want to try to diminish it to pass below.

That said, I don't think gdoc.pub deals with multiple tabs correctly, hence I'm not sure this is the right tool for you. You can give it a try of course.

I may have a look at that later on, but this won't be in a short future.

Best,

Augustin

augnustin avatar Jul 22 '20 08:07 augnustin

ah - thanks for getting back to me .. I have now split the output file to reduce the size .. I maybe asking a dumb question but .. how to find the size of the googlesheet?

Bullinachinashop avatar Jul 22 '20 22:07 Bullinachinashop

It is not dumb. :smile:

You need to have a link to the document URL. Eg: https://docs.google.com/spreadsheets/d/1l3_QEkWcvRhQQn4ieYv3Mxbx6Pk3nMuhKx2bwQGUJcg/pub

And then click right on it, and select "Save link as", and you can have a look at the downloaded file size. For now, as for me, it is still 1Mb.

Cheers

augnustin avatar Jul 23 '20 08:07 augnustin