Skip to main content
Using Tables on Labstep

Step-by-step guide on how to create, edit and use spreadsheet-like tables to your protocols, experiments and notes

Anoä Calpas avatar
Written by Anoä Calpas
Updated over 6 months ago

On Labstep, you can add tables to your protocols, experiments and notes. You can choose between a Basic Table for simple tabulations or an Interactive Table for more complex actions such as calculations. Interactive Tables contain the majority of functionalities you can find in spreadsheets such as Microsoft Excel and Google Sheets. If you'd like to know how to add an Excel or Google Sheets to your entry, click here. For the Conditions table, click here.


Creating a Table:

From a protocol/experiment entry

  1. Navigate to the protocol/experiment entry of your choice

  2. Type / (slash)

  3. Select which type of Table you need

  4. Click on 'Untitled Table' to rename your new Table (interactive Table only)

  5. Start adding elements (interactive Table only)

  6. Click on 'Done' once you're finished (interactive Table only)

Labstep team tip: You can always add/remove or edit elements of your Table later on. Click on your Table's name to view and edit it freely. However, make sure you are in 'Edit' mode.

From notes

  1. Navigate to the content of your choice

  2. Click on 'Notes' in the right-hand side menu

  3. Click on the +

  4. Select 'Table'

  5. Click on 'Untitled Table' to rename your new Table

  6. Start adding elements

  7. Click on 'Done' once you're finished

Labstep team tip: You can add a comment to the Table (within the Notes) by clicking on the chat conversation bubble icon. You can create threads or comments and mention other workspace members.

Editing a Basic Table:

  1. Click on one of the cells

  2. Click on the Table icon in the toolbar

  3. Make the necessary changes

Labstep team tip: You can select the number of rows and columns you want to add when creating a Basic Table.

Importing/Exporting Tables:

Please note this is only for Interactive Tables. However, if you wish to import data to a Basic Table, you can copy-paste it.

Import a .xlsx file

  1. Click on the 'Import from XLSX' icon (far-left side of the menu)

  2. Select the file of your choice

  3. Click on 'Open'

Labstep team tip: We currently do not support graphs within the Table feature. If you have a graph you wish to add to your experiment/protocol/notes, you can import it as a file or image.

A screenshot showing where to click to import a XLSX file

Export as a .xlsx file

  1. Click on the 'Save as XLSX' icon (far-left side of the menu)

  2. The download will automatically start

A screenshot showing where to click to save the table as a XLSX file

What can you do with our Interactive Table feature?

Undo/redo

  • Undo changes by clicking on the left-pointing arrow (far-left side of the menu)

  • Redo changes by clicking on the right-pointing arrow

A GIF showing how to use the undo and redo features

Add/remove column or row 

To add a column or row:

  1. Select the cell where you want an adjacent column or row to be added

  2. Click on the 'Insert Rows/Columns' button on the left-hand side of the menu

  3. Select from either 'Row above', 'Row below', 'Column left' or 'Column right'.

A GIF showing how to add a column

To remove a column or row:

  1. Select a cell on the column or row you wish to be removed.

  2. Click on the 'Delete Rows/Columns' button on the left-hand side of the menu.

  3. Select from either 'Delete column(s)' or 'Delete row(s)'.

A GIF showing how to remove a column from a table


Formatting cell text

  • Format text to bold, italics, underlined or strikethrough

  • Change cell or text colour

  • Increase or decrease the number of decimal places that are displayed

A GIF showing how to format cell text

Text alignment

Adjust both vertical and horizontal alignment of the text to align text to the cell's left, centre, right, top, middle, or bottom.

A GIF showing how to align text within a cell

Cell border options and merging cells

  • Add or remove borders outlining the cells

  • Merge or un-merge selected cells

A GIF showing how to change cells borders and how to merge and unmerge cells


Resizing cells or wrapping text

By default, the text will overflow into the adjacent cell. To enlarge the cell, either click and drag the cell border or double-click to expand the size of the cell automatically. Alternatively, you can click on the wrap text button to fit your text into the cell.

A GIF showing how to resize a cell or wrap text within a cell

Showing formulas

To show formulas in your interactive table, press CTRL and ` (backtick/accent grave key). You'll need to do this before you can copy-paste your table if you want to also paste the formulas.

Carrying our calculations using formulas

A GIF showing how to calculate an average using tables


Still need help?

Contact us here or start a conversation with a member of our team using our in-app chat.

Did this answer your question?