How does Benchling handle Excel files with multiple sheets?

Trisha
Trisha
  • Updated

Issue

User would like to upload an Excel spreadsheet with more than one sheet into their Benchling table (including Registration tables, Inventory tables, Results tables, etc.)

 

How does Benchling handle Excel files with multiple sheets? Does it only look at the first sheet, or can users choose which sheet they'd like to import into their table?

 

Environment

Notebook tables

 

Cause

Benchling will only import the first sheet of a multi-sheet Excel workbook.

 

Resolution steps

If a user would like to import another sheet in their Excel file, they will need to either (1) re-arrange the sheets so that their desired sheet is the first sheet before importing, or (2) separate the desired sheet into its own file.

Was this article helpful?

Have more questions? Submit a request