App Icon
Mixed Analytics
•  111,534
Overview
Automatically store historical data from your Google Sheets reports and dashboards before it gets refreshed.
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. 
👇 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.
_______________________________________________________________________________________

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

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

📃 Changelog:
2020-11-07: small 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
Reviews
Language:
Sort by:
Profile Picture
Nika Jikurashvili
October 4, 2020
Thanks!! It's helpful for me
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
October 5, 2020
Nice! I'm glad you like it :)
Profile Picture
Aston Hunt
September 23, 2020
It works on a manual basis, but scheduling for the purpose of automation doesn't work.
Is this review helpful?
Yes
No
Profile Picture
Adel M. Ibrahim
July 30, 2020
Thanks
Is this review helpful?
Yes
No
Profile Picture
A User of Archive Data
July 2, 2020
This is awesome, but would love to be able to Archive to a separate Sheet so that my main sheet does not get bogged down!!!
Is this review helpful?
Yes
No
Profile Picture
A User of Archive Data
May 13, 2020
I'm using real-time data & I was needing a way to take a snapshot at a given time. This is perfect for what I needed. It's very simple and user friendly to set up. Plus, I made contact with the developer, Ana, who is very accessible, helpful, and kind. You'll probably never need it. But conscientious assistance is right there for you if you do. This is an excellent add-on.
Is this review helpful?
Yes
No
Profile Picture
A User of Archive Data
March 2, 2020
Thank you for this nice add-on. Set it and (kind of) forget it.
Is this review helpful?
Yes
No
Profile Picture
A User of Archive Data
January 16, 2020
This is really good.I love this
Is this review helpful?
Yes
No
Profile Picture
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?
Is this review helpful?
Yes
No
Profile Pciture
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.
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
1-10 of 21
Additional information
Mixed Analytics
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu