Wikipedia:Reference desk/Archives/Computing/2018 August 28

= 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)
 * 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)