Help & Support
Send Feedback
Archive Data
Automatically store historical data from your Google Sheets reports and dashboards before it gets refreshed.
462 users
Works with
Install
Overview
Archive Data lets you automatically store historical data from your Google Sheets reports and dashboards. Set a schedule to paste from range X to Y, backing up data before it gets refreshed. 

Example:
You have a monthly dashboard that uses the "Google Analytics spreadsheet add-on" and a Salesforce connector to automatically pull in new website and customer data each month. When the report refreshes and gets populated with new data, the old data is wiped out. With this extension, automatically save January's data in a new column before it gets overwritten by February's data.

Features:
*Choose your source and destination ranges
*Choose whether to archive to row or columns
*Copy formatting or paste plain text
*Scheduling options (hourly, daily, weekly, or monthly) or archive immediately
*** Generally you should choose an archive time an hour or two after the report refreshes.

Changelog:
2019-09-25: improved navigation options
2019-08-19: increased save request limit
2019-06-24: last day of month scheduling
2018-07-06: new archive to rows functionality
2018-04-23: improved scheduler functionality
2017-12-10: archive to the same column

If you have any questions, please send a message or view https://mixedanalytics.com/blog/archive-data-add-on-google-sheets/ for more information.
Reviews
A User of Archive Data
January 16, 2020
This is really good.I love this
Submit reply
Cancel
Scott Guidry
December 26, 2019
Love this add on. Is it possible to have it paste each archive to a new tab in the sheet?
Submit reply
Cancel
Ana Kravitz
January 1, 2020
Thank you for the kind comment! Currently the archive process can paste only to subsequent columns or rows in the same tab.
A User of Archive Data
December 21, 2019
Very cool add-on! I'm trying to archive several sheets and it's not working. Is it possible? For example, "ARCHIVE Sheet 1" is getting info from "SOURCE Sheet 1" (in the same document), "ARCHIVE Sheet 2" is getting info from "SOURCE Sheet 2" (in the same document), etc. Here's the error message: "The number of rows in the data does not match the number of rows in the range. The data has 1495 but the range has 1986." I think it's summing the rows from multiple sheets, because when I did it for just one sheet it worked perfectly.
Submit reply
Cancel
A User of Archive Data
November 20, 2019
Awesome add-on tool! Covers basic archiving needs. NOTE: If you receive an error code referencing user authorization when selecting the source and destination, make sure you're not logged in to multiple google accounts. I had to log-out and log back in to my google user account.
Submit reply
Cancel
Burke Autrey
October 2, 2019
Great tool and Ana is very responsive to questions and support!
Submit reply
Cancel
Ana Kravitz
October 6, 2019
Thanks, Burke! Happy to hear it's working well.
A User of Archive Data
May 16, 2019
I would very much like to use this add on, however I am unable to enter any information in the "Select destination tab and range." Please advise and thank you.
Submit reply
Cancel
Ana Kravitz
May 17, 2019
Hi Miles, sorry you're having trouble. I'd like to help you get this sorted out. Please email me at info@mixedanalytics.com with a link to the report and/or a screenshot of what you're seeing.
A User of Archive Data
April 13, 2019
This add-on is good! I think it lacks of versatility to make it great. For example, I need to keep track of a value, and copy it to other cell, only during weekdays, and from 11 to 17hs. In this case, the only choose I have is to run it non-stop, every hour.... So, wouldn't do! Thanks for offering this.
Submit reply
Cancel
Ana Kravitz
April 16, 2019
Noted, thanks for the feedback. For now I think you can resolve this with some helper functions that check if the current date is in the acceptable date range. For example, if cell A1 contains the current time with =now(), then the formula =IF(AND(weekday(A1)>1,weekday(A1)<7),"Yes","No") would show "Yes" it's a weekday right now. Similar logic would determine if it's 11 to 17 hrs. You can then do an IF or QUERY function that checks for a "Yes" and pulls your data into a cell based on the results. That cell can be the source range for your archive process -- if it's empty because it didn't meet the date condition, the archive process won't paste anything.
A User of Archive Data
February 26, 2019
Can it be automatically archived and sent to specific Emails "weekly/monthly", to keep previous data easily accessible even if owner's account is blocked for any reason
Submit reply
Cancel
Ana Kravitz
March 4, 2019
The Archive Data plugin is only intended to archive the data within the sheet, but there are other plugins that let you schedule and email certain sheets or ranges. Also, if you uncheck the option 'Paste To Next Empty Range', the archive process will always paste into the same range, so that should make emailing easy.
Douglas Rose
December 20, 2018
I love this add-on tool! Would it be possible to add a timestamp to the rows/columns of the archived data? Then I'd easily be able to tell which segment of data was archived when Thanks :)
Submit reply
Cancel
Ana Kravitz
December 24, 2018
Glad you like it and thank you for the suggestion! For now, if you want to add a timestamp, you can create a cell containing the formula '=now()' in your source range. Then when the archive runs, that timestamp will be pasted into your destination range.
Andrew Aijian
May 12, 2018
Works great - really useful function and great potential for continued development Would be nice to be able to schedule the hourly archiving to occur at a particular time.
Submit reply
Cancel
1-10 of 15
Additional information
Search
Clear search
Close search
Google apps
Main menu