Menu
I am testing the new Google Spreadsheets as there is a new feature I really need: the 200 sheets limit has been lifted (more info here: https://support.google.com/drive/answer/3541068).
However, I can't publish a spreadsheet to CSV like you can in the old version. I go to 'File>Publish to the web' and there is no more options to publish 'all sheets' or certain sheets and you can't specify cell ranges to publish to CSV etc.
This limitation is not mentioned in the published 'Unsupported Features' documentation found at: https://support.google.com/drive/answer/3543688
Is there some other way this gets enabled or has it in fact been left out of the new version?
My use case is: we retrieve Bigquery results into the spreadsheets, we publish the sheets as a CSV automatically using the "publish automatically on update" feature which then produces the CSV URL which gets placed into charting tools that read the CSV URL to generate the visuals.
Does anyone know how to do this?
855
Up to 100: You can let up to 100 people with view, edit, or comment permissions work on a Google Docs, Sheets, or Slides file at the same time. 100 or more: When 100 people or more are accessing a file, only the owner and some users with editing permissions can edit the file.
As Google Sheets does count blank cells as part of the cell limit, the most simple way to avoid the limit is to delete these empty cells. You can do this by using the Filter feature in Google Sheets. Highlight the entire dataset in your spreadsheet and head to Data > Create a filter.
When you convert a file into Google Sheets, it can have a maximum of 100 MB size. For files that are created in Google Sheets itself, the limit is 5 million rows.
The new Google spreadsheets use a different URL (just copy your <KEY>):
https://docs.google.com/spreadsheets/d/<KEY>/pubhtml https://docs.google.com/spreadsheets/d/<KEY>/export?gid=<GUID>&format=csv The GUID of your spreadsheet relates to the tab number.
/!\ You have to share your document using the Anyone with the link setting.
183
Here is the solution, just write it like this:
https://docs.google.com/spreadsheets/d/<KEY>/export?format=csv&id=<KEY>
I know it's weird to write the KEY twice, but it works perfectly. A teammate from work discovered this by opening the excel file in Google Docs, then File -> Download as -> Comma separated values. Then, in the downloads section of the browser appears a link to the CSV file, like this: https://docs.google.com/spreadsheets/d/<KEY>/export?format=csv&id=<KEY>&gid=<SOME NUMBER> But it doesn't work in this format, what my friend did was remove "&gid=<SOME NUMBER>" and it worked! Hope it helps everyone.
44
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
