Computing desk
< August 27	<< Jul \| August \| Sep >>	August 29 >

Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.

August 28

How can I grab all archived versions of a Google Sheet?

I want to turn the set of historical versions of a Google Sheet into one temporal database. (I only want a one-time process; once achieved the temporal database will become my master version.) I can pull the current data into another Google Sheet with ImportRange but to access an earlier version I only know how to manually select it and restore it and then run ImportRange again at a different place in my destination Google Sheet. (Once I have slapped all the versions into the destination Google Sheet with some kind of nearby timestamps I will be able to parse it into a useful structure.) I wonder how to automate finding and selecting earlier versions and knowing their date in order to time stamp my new copies.

If this cannot be done, or if I don't have the skills to follow suggestions, I suppose I could manually find and restore each version and paste it into a new sheet and record that sheet's URL and build up a destination sheet that uses ImportRange for each URL ... but there are a lot of tabs in a lot of versions so I'd like an easier method that I can also learn from.

I can imagine I haven't explained it quite well enough and would be happy to answer questions.

Hayttom (talk) 13:20, 28 August 2018 (UTC)[reply]

Wikipedia describes Google Sheets in the article Google Docs, Sheets, and Slides. Google further provides this guide and an article See what’s changed in a file. You may try describing your issue at Docs Editors Help at the last named link.DroneB (talk) 15:57, 29 August 2018 (UTC)[reply]