App Icon
Automatically store snapshots of historical data in your Google Sheets reports and dashboards.
Works with:
117,912
Overview
Archive Data lets you automatically store historical data in your Google Sheets reports and dashboards. Set a schedule to paste from range X to Y, backing up data before it gets refreshed. 
👇 More info

✏️ 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.
*Free :)
_______________________________________________________________________________________

📓 Documentation:
https://mixedanalytics.com/blog/archive-data-add-on-google-sheets/

💬 Fast, friendly support
https://mixedanalytics.com/contact/
_______________________________________________________________________________________

📃 Changelog:
2020-12-05: run archives one at a time + drag-n-drop ordering
2020-11-07: style update
2019-09-25: better navigation
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
2017-11-05: re-release after accidentally borking the 1st version 😅
2017-06-28 first release!
Additional information
Privacy policy
Terms of service
Archive Data will ask for the permissions shown below. Learn more
Archive Data will need access to your Google account
This will allow Archive Data to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
Dinesh P
March 31, 2018
Hi, I have used the add on, It is really user friendly and effective, I would like to have one more option in the add on, Example ;- i 1 have archived sheet1:A1:F100 to sheet2:A1:F100 after that i deleted the data in the source sheet the next time when i archive i dont want the data in A1 to F100 to be over written instead it should write to next available epmpty range in sheet 2
Is this review helpful?
Yes
No
Profile Picture
A User of Archive Data
November 8, 2017
Muy bien! Very cool, simple, effective) But it seems that scheduling does not work, archiving is possible only "by hand". --- 8/11/17 checkbox (or smth) to paste data to row/column would be great - spreadsheet is longer down than to the right
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of Archive Data
September 27, 2017
Really helpful addon, thanks. I was wondering if there is a way that the data could be constantly written in the same column, as opposed to moving to the next available. Thanks again!
Is this review helpful?
Yes
No
Profile Picture
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 :)
Is this review helpful?
Yes
No
Profile Picture
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
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of Archive Data
April 12, 2018
Nice add-on. Please add fill data in next available row.
Is this review helpful?
Yes
No
Profile Picture
A User of Archive Data
April 13, 2018
Really happy with the potential here, though I'm having trouble getting the scheduling to work. I've tried hourly and daily-set to a certain timeframe. Any suggestions?
Is this review helpful?
Yes
No
1-10 of 26
Search
Clear search
Close search
Google apps
Main menu