What is this?

The export script is a simple google script that runs in the context of any google spreadsheet file and performs one basic task: 

  1. export a subset of columns from the current sheet to a new public spreadsheet

How does it work?

These are the necessary steps to run the script.

  • Open the script (it's a file inside a google drive folder currently called "Custom LabMap Data Curation")
  • Click on Run in the menu and select "Test as add-on"
  • Then select the spreadsheet in which you want to run the script clicking in "Select Doc", and once it's selected click Save.
  • The file will be listed above, just select it and click Test

Once in the spreadsheet, the script will be found under the add-ons menu.

  • If you click on Export a small form will be displayed in the right sidebar. 
  • All the fields need to be completed to run the script
  • If there are no columnstoExport sheet it can be copied from the available copies om the "recourcesforCuration" folder in google drive.

Details on columnstoExport sheet

This sheet has only one column and it just lists all the fields to be exported, please keep in mind that all the field names need to be equal to the fields in the data sheet, otherwise they will not be exported.


This is also described in the export section of this video


Scope and potentiality

This script was initially written by InSTEDD to expedite the process but the code is totally open to any change, any developer or even a google power user can add a few lines to the script and get new functionalities.