Skip to main content Link Menu Expand (external link) Document Search Copy Copied
Metadata Spreadsheet Validator Documentation

Upload Spreadsheet

Users can upload their spreadsheet file using the input field on the homepage. Currently, the tool supports two types of input format:

  1. Excel spreadsheet (.xlsx)
  2. TSV file (.tsv)

Metadata information

Both input formats require metadata information that provides context for the tool’s algorithm. The table below lists required metadata fields:

Field Description
schema:title Enter the title of the spreadsheet.
pav:version Enter the version of the spreadsheet.
pav:createdOn Enter the creation date and time (format: YYYY-MM-DD hh:mm).
pav:derivedFrom Enter the CEDAR template IRI that contains the validation rules.

How to include the metadata information?

  • For Excel file format, add a new sheet called .metadata and create a table with the metadata information.

Screen Shot 2023-04-24 at 4 40 18 PM

  • For TSV file format, add a new column called metadata_schema_id and include the metadata schema UUID identifier. You can find the identifier in the CEDAR OpenView documentation page. As an example, this page shows the ATACseq documentation page. Navigate to the bottom of the page to locate the ‘Metadata schema ID’ field. Hover your mouse cursor over the information (i) icon (as depicted in the screenshot below), and then copy and paste the provided string from the popup message into your TSV file.

find-metadata-schema-id

Uploading the file to validate

You can either drag-and-drop the file from your local computer to the input field or use the “Browse” option to select the file from your file system.