Archive Sheet data Add-on

Last updated 07 January 2022

Archive Sheet data logos



 

 


What it does

This Add-on will allow you to easily move/archive a row 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

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.

Instructions

Install the Add-on from the Google Workspace Marketplace™.
  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 of the data that you want archiving and then select the 'ARCHIVE ROW' 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.

 
 

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.

Privacy Policy

Who is requesting Google user data? I am an individual developer making my tools available to all that want to use them. All of the data is stored within the Google™ environment, I am the only one with access to it and it is not shared with any third parties. There are no ads and no emails generated from any of the data. No other personal/sensitive data is collected and processed by me.

What data are you requesting? The Add-on does not access any sensitive scopes or private user data. It does not collect or store any of the data it is archiving. It does retain the below information in order to create your preferences and subsequently open faster:
  • The ID of the Google Sheet™.
  • The names of your source/destination tabs.
  • Your formatting preferences (eg colours, styles) - saved only as values such as 'fontStyleOn', 'fontSizeOn' for example.

Why are you requesting Google user data? The Add-on needs access to the current Google Sheet™ file in order to be able to move the data. As mentioned above your user preferences are saved to allow a faster interaction with the Add-on going forwards without the need to repeatedly select your Google Sheets™.
 
The 'Archive Sheet data' app's use and transfer to any other app of information received from Google APIs will adhere to the Google API Services User Data Policy, including the Limited Use requirements.


Terms of Service

This Add-on is free for use. You accept the Privacy Policy when installing the tool and will not attempt to interfere with its functionality. As an individual developer I take no responsibility for any adverse effects when using this Add-on, but I intend to make every effort to maintain it going forwards and ensure its functionality. I develop tools to a high standard. It is your responsibility to use the tool correctly and securely.

You will not attempt to copy the Add-on.


Feedback & Support

Please complete the below form.