
1
Download the Google Sheet to your local computer.
Note that Registry CSV import only supports .csv at the moment. If you
have an Excel file (.xls, .xlsx) or text file (.txt), please make sure to save
them as a CSV first.
2
Once you have clicked “Import CSV”, a new modal will pop up with a view of your Latch Data.
Select “Upload Files” to upload the metadata sheet downloaded in the previous step.

3
Once the file finishes uploading, choose the CSV and click “Select”.

4
Once you choose the CSV file, a pop-up window will show up, which lets you map the columns from the CSV to the registry table columns.

5
You can choose to create new columns for Registry or select existing columns to map the data to.
New tables only have one default existing column, which is “Name”. Let’s change the mapped column for the “Sample Name” (in the original CSV) to “Name” (in the Registry).

6
You can also change the types of the column to be imported.
As an exercise, we can change the type of the columns “organism_name” and “Strandedness” to “Select”.Once the import finishes, you will see your Registry table populated like so.
Pro-tip: If you want to import a CSV with new columns and one of the
columns contains values that match record names in the Registry, the columns
and their values will be linked with those records automatically.
