How to enter data into the spreadsheet

Note: You now have two options for creating graphs in BioRender:

• The original step-by-step method (outlined below)

• The new Smart Data Import (beta) option, which allows you to upload a spreadsheet directly and have your graph generated for you. Learn more about Smart Data Import here.

Learn how to format and enter data into BioRender’s spreadsheet for different statistical analyses, including t-tests, ANOVAs, and regressions. Unlike GraphPad Prism, BioRender uses a long format for data entry, which is similar to R, Origin, and SPSS.

Important for GraphPad Prism users:

GraphPad Prism uses wide format data tables, while BioRender requires long format data.

Long format means:

• Each row represents a single observation.
• Columns represent variables like groups or measurement types.

→ Learn more about long vs. wide data formats

t-tests and one-way ANOVAs

• The spreadsheet for t-tests and one-way ANOVAs will have two columns:
  1. (A) your independent variable and
  2. (B) your dependent variable.
• All of your group labels for your data points will go in column A and your results will go in column B.
• Note: This is different from how GraphPad Prism’s spreadsheet requires your data to be formatted, but the same as how R, Origin, and SPSS typically accept data.

Example: You’re comparing the weight of wild-type vs. knockout mice.

Two-way ANOVAs

• The spreadsheet for regressions has three columns:
  
  1. (A) the independent variable which will be displayed on the x-axis
  2. (B) the dependent variable
  3. (C) the (optional) second independent variable which will be displayed in the legend.
• Note: This is different from how GraphPad Prism’s spreadsheet requires your data to be formatted, but the same as how R, Origin, and SPSS typically accepts data.

Example: you’re comparing the effect of different drug types (independent variable) on the resting heart rate (dependent variable) of male and female (independent variable) mice.

Regressions (linear and non-linear)

• The spreadsheet for regressions has three columns:
  
  • (A) the independent variable which will be displayed on the x-axis
  • (B) the dependent variable
  • (C) the (optional) second independent variable which will be displayed in the legend
• Important: Column A must contain numeric values for regression to work properly.

Example: you’re comparing the effect of different drug concentrations (independent variable) on the resting heart rate (dependent variable) of male and female (independent variable) mice.

Related articles

• BioRender Graph
• How to customize your graph
• Setting up a new file in BioRender Graph

Need help?

If you have any questions or concerns:

1. Email Support: support@biorender.com
2. Live Chat: Available by clicking on the "Help" bubble in the app on the bottom right-hand corner.