How to add your data in BioRender Graphing How to add your data in BioRender Graphing

How to add your data in BioRender Graphing

📌 Beta: The Graphing agent is in beta. 

There are two ways to add your data into a BioRender Graphing file:

  1. With the Graphing agent: Upload a file in the chat.
  2. Manually: Upload a file from the Data tab, or enter or paste your data into a blank spreadsheet.

Either way, Smart Data Import detects your variables automatically, so you don't need to reformat. You can switch between the two at any point.

With the Graphing agent

BioRenders AI agent uses Smart Data Import to automatically interpret and prepare your experimental data for graphing, no matter how it's structured or formatted. There's no need to manually rearrange, copy, or paste your data for most formats. You can also generate multiple graph types from a single dataset, giving you the flexibility to explore different visualizations without reformatting or duplicating your work. Your underlying data isn't changed.

Create a new graph file

  1. From your Gallery, click “Create New” > “Graph” > “Graphing”.
  2. Or open an existing Graph file if you're continuing work on a previous dataset.

Upload your dataset

  1. In the agent's message, click “Upload data”, or click the “+” button in the chat box.
  2. Choose your file. Supported formats: .csv, .xls, .xlsx, .prism, and .pzfx (up to 50 MB). 
  3. In the “Select datasets from your file” window, select the datasets you want, or choose “Select All”, then click “Import data”. Files with multiple sheets show all available sheets.
  4. For .prism files, importing graphs and analyses is on by default. Uncheck it if you only want the raw data. 
  5. The agent confirms what it added, describes your data, and highlights the variables it detected.

Example: Upload your data in the Graphing agent chat (central chat view)

Upload your data with the Graphing agent

Example: Select your datasets (central chat view)

Choose the data you want to import

💡 You can't send a file as a chat message. Use “Upload data” or the “+” button. Both open the same import window.

Review the variables

You make these edits by hand. The agent doesn't change your data.

  • Click a variable name to edit it.
  • Edit highlighted cells for a variable if needed.
  • You can also add or delete variables.

Review the variables

Create your first graph

The agent suggests a graph type for your data. Follow its prompts, or ask it for the graph you want. For the full walkthrough, see How to use the Graphing agent in BioRender Graphing.

Add more data later

Click the “+” button in the chat box to upload another file.


Manually

Option 1: Upload a file (Smart Data Import)

Smart Data Import interprets and prepares your data for graphing, however it’s structured. There’s no need to rearrange, copy, or paste anything. You can also create multiple graph types from one dataset.

Option 2: Blank spreadsheet

Enter or paste your data in any format. When you’re done, re-detect your variables and BioRender gets you ready to graph.

How to use Smart Data Import

  1. Create a new graph file
    • From your Gallery, click "Create New" > "Graph"  > "Graphing"
    • Alternatively, open an existing Graph file if continuing work on a previous dataset.
  2. Upload your dataset
    • On the Data tab, click "Upload dataset"
    • Select your file (supported formats: .csv, .xls, .xlsx, .prism, .pzfx — up to 50MB)
    • Files with multiple sheets will show all available sheets — select all or choose one

Drag and drop your data in or start from a blank spreadsheet or sample dataset

  • For .prism files, the option to import graphs and analyses is on by default. Uncheck this if you only want the raw data.
  1. Select the Dataset(s) you want to import.

Choose the data you want to import

  1. Automatic data and variable identification. The system automatically:
    • identifies variables present in your spreadsheet 
    • Handles merged header cells
    • Ignores annotations (e.g. machine output headers outside the main dataset)
    • Ignores empty rows or columns
  2. Review the variables
    • Click a variable name to edit it
    • Edit highlighted cells for a variable if needed
    • You can also add or delete variables

💡 Importing from GraphPad Prism? BioRender supports .prism files (newest format). Older .pzfx files will import data only. See the full guide: Importing from GraphPad Prism


Recommendations for all datasets

  • For upload: File size max (all file types): 50 MB
  • For upload or manual data entry into blank spreadsheet: Recommended max of 5,000 datapoints for creating graphs and running analysis. Files larger than this may have very slow performance.

Recommended data limits for CSV or Excel files

For best performance, keep your data within these limits:

Limit Recommended Value
Maximum columns 50
Maximum rows 10,000

These limits ensure:

  • Fast processing times (under 10 seconds)
  • Compatibility with statistical analysis features
  • Reliable imports across all data types

Prism File Limits

  • Max 50 data tables within a Prism file

Recommended data limits for prism files

Limit  Value
Rows per table 10,000
Columns per table 100
Total data points (all tables) 100,000

Note: If your Prism file has many tables, keep total data points under 100,000 (e.g., 10 tables × 10,000 points).

How datasets are organized

Once imported, each dataset appears as a tab along the bottom of the Data tab.  You can click between datasets to view them. Variables for the active dataset are listed in the left panel.

Example: Data tabs with the side panel agent chat view.

Alternate between datasets in the tabs below

From the data view, you can:

  • Manually add or delete variables, rows or columns
  • Rename variables
  • See which graphs are linked to each dataset.

Add, delete or rename your variables

What's next?

Once your data is in, you're ready to start building graphs. To create your first graph, click ‘Create New Graph’ from the data tab in the right hand panel or head to the Graph tab, apply analysis guidance to choose the right statistical test, and customize your visuals - all without leaving BioRender.

Learn how to Run a Statistical Analysis in BioRender Graphing →

Need help? Reach out to our support team at support@biorender.com or start a live chat by clicking the "Chat With Us" bubble in the bottom right corner.

What's new →
Discover more in BioRender
 
 BioRender AI

Draft custom figures in seconds from a text prompt.

Learn more → Browse help articles →
 
 Graphing

Turn raw data into journal-quality graphs in minutes.

Learn more → Browse help articles →

Was this article helpful?

3 out of 6 found this helpful