How to Analyze ELISA Data in Excel

Performing an ELISA (enzyme-linked immunosorbent assay) gives you a plate full of colorful wells, but those colors are just the beginning. The real value is in the numbers - the absorbance data you get from your plate reader. This article guides you step-by-step through how to organize, analyze, and interpret your ELISA data using the powerful tool you already have: Microsoft Excel.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Start with a Well-Organized Data Sheet

Before you can plot a beautiful standard curve, your data needs to be structured properly. A clean setup in Excel prevents confusion and makes the analysis much smoother. Good organization is the foundation for accurate results.

Create a few simple columns to log your raw data:

• Well: The position on the 96-well plate (e.g., A1, A2, B1, B2). This helps you track everything back to the physical plate if you need to troubleshoot.
• Type: What was in the well? Label it as either "Blank," "Standard," or "Sample."
• Concentration: For your standards, note the known concentration (e.g., 2000 pg/mL, 1000 pg/mL, 500 pg/mL). For your unknown samples, you can leave this blank or note the sample ID.
• OD Reading: This is the crucial column for your raw Optical Density (absorbance) values from the plate reader. If you ran your samples in duplicate or triplicate (which you always should!), each replicate will get its own row.

Here's a snapshot of how your initial data table might look:

Step 1: Calculate Averages and Perform Blank Subtraction

Your first calculation step is to average your replicates and correct for any background signal from the buffer or reagents. This ensures your measurements are both precise and accurate.

Calculate Average ODs

First, you need a new, cleaner table to perform your analysis. This "Analysis Table" will have columns for your average ODs and corrected ODs. Start by listing your unique standard concentrations and sample IDs. Then, use Excel's AVERAGE function to calculate the mean OD reading for each set of replicates.

Let's say your blank ODs are in cells D2 and D3, and your 2000 pg/mL standard ODs are in D4 and D5. The formula is simple:

=AVERAGE(D2:D3) // For your blanks =AVERAGE(D4:D5) // For your highest standard

Do this for all your blanks, standards, and unknown samples.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Subtract the Average Blank OD

Every ELISA has a small amount of background signal. To remove this, you subtract the average OD of your blank wells from every other average OD reading. This is called blank correction or background subtraction.

Let's assume the average blank OD you calculated (0.090) is in cell F2 of your analysis table. In a new "Corrected OD" column, subtract this value from all your averaged ODs. Pro Tip: Use an absolute cell reference ($F$2) for the blank OD so you can drag the formula down without the reference changing.

If your first averaged Standard OD is in cell G4, the formula would be:

=G4-$F$2

Drag this formula down the column to apply it to all your standards and samples. Your analysis table should now look something like this, with clean, background-corrected data ready for plotting:

Step 2: Generate and Validate Your Standard Curve

The standard curve is the heart of your ELISA. It maps the relationship between known concentrations and their OD readings, allowing you to determine the concentration of your unknown samples.

Create a Scatter Plot

To create the curve, you'll plot your standard concentrations on the X-axis against their blank-corrected ODs on the Y-axis.

1. Select your two columns of data: the known Standard Concentrations and their Calculated Blank Corrected OD readings.
2. Go to the Insert tab in Excel's ribbon.
3. In the Charts section, click on Insert Scatter (X, Y) or Bubble Chart and select the simple Scatter option (just dots, no lines).

Excel will generate a basic chart showing your data points. It should show a clear relationship - as concentration increases, OD increases.

Add a Trendline, Equation, and R-Squared Value

Next, you’ll fit a trendline to these points. This line generates an equation that defines the relationship between concentration and OD.

1. Right-click on any of the data points in your chart and select "Add Trendline...".
2. A "Format Trendline" menu will appear. For many ELISA assays, a simple Linear trendline is sufficient, especially if you remove any points that are clearly outside the linear range of the assay.
3. At the bottom of the Trendline Options panel, check two very important boxes:

The equation (in the form y = mx + b) is what you'll use to calculate your unknown concentrations. The R-squared (R²) value tells you how well the line fits your data. For a reliable ELISA standard curve, you want an R² value as close to 1.0 as possible - a value over 0.99 is typically considered excellent.

A Quick Note on 4-PL Curves: Most ELISA assays are not perfectly linear. They follow a sigmoidal (S-shaped) curve. The gold standard for fitting this is a 4-Parameter Logistic (4-PL) fit. While Excel doesn't have a built-in 4-PL trendline option, plugins and dedicated ELISA analysis software can do this. For basic analysis, using the most linear portion of your curve and a linear trendline in Excel is a perfectly valid and widely used approach.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Calculate Your Unknown Sample Concentrations

Now for the big reveal: determining the concentrations of your unknown samples. You'll do this by rearranging the trendline equation (y = mx + b) to solve for x.

The formula to find the concentration (x) is:

Concentration (x) = (OD Reading (y) - b) / m

Where:

• y is the blank-corrected average OD of your unknown sample.
• m is the slope of your trendline (the number next to x in the equation).
• b is the y-intercept of your trendline (the number at the end of the equation).

Let’s say your chart trendline produced the equation: y = 0.001x + 0.045 and your unknown sample's blank-corrected OD is 1.152.

Let's rearrange to solve for x: x = (y - 0.045) / 0.001

In your analysis table, create a new column called "Calculated Concentration." If your unknown sample's corrected OD (1.152) is in cell H10, your Excel formula would be:

=(H10 - 0.045) / 0.001

The result of this calculation would give you the initial concentration of that sample.

Step 4: Don't Forget the Dilution Factor!

This is a common and easy-to-make mistake. Most samples (like serum or cell culture media) are too concentrated to fall within the standard curve's range, so they must be diluted before running the assay. You need to account for this to get the true final concentration.

Multiplying your calculated concentration by the dilution factor is the final step.

For example, if you diluted your sample 1:10 (1 part sample to 9 parts diluent), your dilution factor is 10. If you diluted 1:100, the factor is 100.

The final formula is:

Final Concentration = Calculated Concentration × Dilution Factor

In Excel, just add a column for your "Dilution Factor" and a Final Concentration column with the simple formula:

=[Calculated Concentration Cell] * [Dilution Factor Cell]

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Quick Quality Control Checks

Before finalizing your results, perform a few checks to ensure your data is reliable.

Check your R² Value

As mentioned, make sure the R² value on your trendline is greater than 0.99. If it's not, you may have an outlier in your standards or general issues with pipetting accuracy.

Calculate the %CV

The Coefficient of Variation (%CV) measures the precision of your replicates. A lower %CV is better. For most ELISAs, a %CV under 15-20% for your replicates is considered acceptable. You can easily calculate it in Excel.

The formula is: %CV = (Standard Deviation / Mean) * 100

Assuming your duplicate OD readings are in cells D4 and D5, the Excel formula would be:

=(STDEV.S(D4:D5) / AVERAGE(D4:D5)) * 100

Calculating the %CV for each set of replicates can help you spot inaccurate pipetting or other plate inconsistencies.

Final Thoughts

Analyzing ELISA data in Excel is a skill every molecular biologist can and should master. By carefully organizing your data, calculating blank-corrected ODs, plotting a reliable standard curve, and using its equation, you can confidently turn raw absorbance readings into meaningful concentration data.

While Excel gives you full manual control, the process of exporting, averaging, plotting, and calculating formulas can become repetitive when you run assays frequently. Our goal with Graphed is to eliminate this manual busywork. We let you connect your data sources - whether it's raw output from an analysis tool or an organized Google Sheet - and then use simple conversational language to automate the entire reporting process. You could ask, "Generate an ELISA report from my Q3 data, including standard curves and final concentrations," and get an interactive dashboard in seconds, saving you from repeating these same steps every time.