📌 Beta: The Graphing agent is in beta.
There are two ways to add your data into a BioRender Graphing file:
- With the Graphing agent: Upload a file in the chat.
- 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
- From your Gallery, click “Create New” > “Graph” > “Graphing”.
- Or open an existing Graph file if you're continuing work on a previous dataset.
Upload your dataset
- In the agent's message, click “Upload data”, or click the “+” button in the chat box.
- Choose your file. Supported formats: .csv, .xls, .xlsx, .prism, and .pzfx (up to 50 MB).
- 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.
- For .prism files, importing graphs and analyses is on by default. Uncheck it if you only want the raw data.
- 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)
Example: Select your datasets (central chat view)
💡 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.
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
- 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.
- 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
- For .prism files, the option to import graphs and analyses is on by default. Uncheck this if you only want the raw data.
- Select the Dataset(s) you want to import.
- 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
- 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.
From the data view, you can:
- Manually add or delete variables, rows or columns
- Rename variables
- See which graphs are linked to each dataset.
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.
Was this article helpful?
Articles in this section
- How to use the Graphing agent in BioRender Graphing
- An overview of BioRender Graphing
- Getting Started with BioRender Graphing
- How to add your data in BioRender Graphing
- How to import your Prism files into BioRender Graphing
- How to export your classic Graph files and re-import your data into BioRender Graphing
- The classic version of BioRender Graph was retired: What you need to know
- Exporting graphs and analyses in BioRender Graph (classic version)