App Icon
Easily move/archive rows of data from one Google Sheet™ (tab) to another, within the same file. If you prefer something a bit quicker than cut/paste and with less chance of human-error.
Listing updated:February 7, 2022
Works with:
189
Overview
WHAT IT DOES
Easily move/archive rows of data from one Google Sheet™ (tab) to another, within the same file. If you prefer something a bit quicker than cut/paste and with less chance of human-error.

It will also remember your individual preferences for each file so it is even quicker to use next time around.


NEW FEATURES
February 2022:
A new setting called 'Multiple rows' to allow you to select a range of cells and move/archive more than one row at a time.

January 2022:
A new 'Settings' page allowing you to select more than just cell values when archiving row data. You can now also select:
> Text formatting: bold, italics, colour, size and style.
> Cell: background colour, Notes and wrapping.


HOW TO USE
After installing:

1) You can access the tool from any Google Sheet™, by clicking the 'Show side panel' button at the far bottom right of the Sheet. Then select the 'Archive Sheet data' icon to open the Add-on (if you already had your Google Sheet™ open when you installed the Add-on then you may need to refresh the page first for the new icon to appear).

2) When you are ready click 'GET STARTED'. Use the dropdown boxes to select where you are moving data from/to (your preferences will automatically be saved for future). Remember to ensure you have copied the Header row to your destination tab so that the row of data can be appended under it.

3) Now click anywhere in the row(s) of the data that you want archiving and then select the 'ARCHIVE ROWS' button.

4) A success message will confirm it has been moved. Click the 'BACK' button to return and continue archiving to your heart's content!

Use the 'Settings' button in order to adjust the type of formatting you want to preserve or to be able to select multiple rows of data.


CAVEATS
At the moment the Add-on does not transfer:
> Cell Comments - recommended you create a separate column for Comments if you wish to retain these.

Also note:
> Tickboxes will retain their value but will become 'true' or 'false' in the destination tab.
> Formulas will be lost but the resultant value maintained eg if you have a 'SUM' formula in a cell it will archive the total of that Sum.
> There will be no 'cell history' available as the entire source row is deleted after the move. 'Version history' still remains available however.
Additional information
PricingFree
Developer
Trader status unspecified
Privacy policy
Terms of service
Archive Sheet data will ask for the permissions shown below. Learn more
Archive Sheet data will need access to your Google account
This will allow Archive Sheet data to :
View and manage spreadsheets that this application has been installed in
View your country, language, and timezone
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
No comments
Search
Clear search
Close search
Google apps
Main menu