Skip to main content

Importing a Table

Upload an existing spreadsheet of drugs, companies, or trials to create a Smart Table and enrich it with AI-powered analysis.

When you already have a spreadsheet of pipeline assets, target companies, or clinical trials from an internal tracker or conference notes, Import Table brings that list into Maven Bio so you can enrich it with AI Columns without re-entering the data.

Upload your spreadsheet

Click Smart Tables in the left toolbar, then select Import Table. Upload an Excel (.xlsx) or CSV (.csv) file. A configuration window appears where you choose the row type (Drug, Trial, Company, Document, Mechanism, Indication, Target, or Abstract) and select which column serves as the primary identifier. The primary column maps each row to Maven Bio's ontology.

Import table configuration showing entity type selection and primary column picker

Click Import Table to create the Smart Table. Any additional columns in your spreadsheet are preserved, but AI Columns and enrichment are linked to the primary entity column.

Review row mapping

After import, the Row Mapping button shows how many items from your list were automatically matched to entries in Maven Bio's database. From this screen you can confirm correct matches, reassign mismatches, or manually map unmatched rows.

Row mapping screen showing matched and unmatched entities with reassignment options

What you can do next

Once your imported table is mapped, add AI Columns to enrich each row with custom analysis. To export the enriched table back to a spreadsheet, see Exporting a Smart Table.

Did this answer your question?