Compute Correlation Matrix for Excel Files Online
Compute a Pearson correlation matrix for numeric columns in Excel files directly in your browser. Instantly spot which variables move together — colour-coded heatmap, no upload required.
How to compute Correlation Matrix for Excel files
- Drop your file onto the upload area. Every numeric column is found and selected.
- Click column names to leave out any you do not want, such as ID or ZIP code columns. At least two must stay selected.
- Click Compute Correlations. A colour-coded matrix appears, blue for positive and red for negative, with values to 3 decimals. Hover a cell for 6 decimals.
- Click Export Matrix CSV to download the matrix with values to 4 decimals.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
An estate agent has recent house sales and wants to see which property features move with the sale price before building a pricing model.
Input (Excel)
Excel workbook, first sheet (Sheet1)
| floor_area_sqft | bedrooms | age_years | sale_price |
|---|---|---|---|
| 1450 | 3 | 32 | 612000 |
| 2100 | 4 | 8 | 845000 |
| 980 | 2 | 55 | 455000 |
| 1720 | 3 | 20 | 701000 |
| 2600 | 5 | 3 | 990000 |
| 1200 | 2 | 41 | 540000 |
Settings
- Numeric columns: floor_area_sqft, bedrooms, age_years, sale_price (all selected)
- Export: Export Matrix CSV
Result
| floor_area_sqft | bedrooms | age_years | sale_price | |
|---|---|---|---|---|
| floor_area_sqft | 1.0000 | 0.9830 | -0.9669 | 0.9991 |
| bedrooms | 0.9830 | 1.0000 | -0.9306 | 0.9798 |
| age_years | -0.9669 | -0.9306 | 1.0000 | -0.9721 |
| sale_price | 0.9991 | 0.9798 | -0.9721 | 1.0000 |
The output is always a CSV, whatever the input format, with an empty top-left header cell. Floor area tracks price almost perfectly at 0.9991. Age is strongly negative at -0.9721: older homes sold for less. The diagonal is 1 because each column matches itself, and the matrix is symmetric. With only six rows these values are fragile, and one unusual sale could move them a lot.
Working with Excel files
The first sheet is loaded using each cell's displayed text. Numbers shown with currency symbols, thousand separators or percent signs, such as "$845,000" or "12%", become text and are left out of the matrix. Set those columns to General format in Excel before saving, or the columns you care most about may be the ones that disappear. If you cannot change the workbook, clean the symbols with Find & Replace and convert the column with Cast Column Types, then compute. Cells with formulas are fine, because their last calculated value is what gets loaded.
Excel's CORREL function returns the same Pearson coefficient for a pair of columns, so you can spot-check a cell of the matrix against it. The difference is that this tool computes every pair at once and shows them as a heatmap. The result is downloaded as a CSV file, not a new workbook. It opens directly in Excel, with the first row and first column holding the column names.
Frequently Asked Questions
Does this give the same result as Excel's CORREL?
Yes, for columns of plain numbers with no blanks. Both compute the Pearson coefficient. This tool skips any row where either value is empty, so check CORREL on the same rows if your sheet has gaps.
Why are my currency columns missing from the list?
Currency formatting makes the displayed values text, and only numeric columns are listed. Switch the cells to General format in Excel and load the file again.
Which correlation method is used?
Pearson correlation, which measures straight-line relationships. A strong curved relationship can still show a value near 0. Spearman and Kendall are not available.
Why does a cell show NaN or a dash?
NaN means one of the two columns has the same value in every row it shares with the other, or only one shared row exists, so there is no variation to correlate. A dash means there were no rows with values in both columns. In the CSV export a dash becomes an empty cell.
Is there a limit on the number of columns?
There is no fixed limit, but the matrix grows with the square of the column count. Deselect IDs and other columns that are not real measures to keep it readable.
Related Tools
Detect Outliers in Excel Files Online
Detect statistical outliers in Excel files directly in your browser. Flag or remove rows where numeric values exceed a chosen number of standard deviations from the mean — no upload required.
Normalize Columns in Excel Files Online
Normalize numeric columns in Excel files using min-max scaling (0–1) or z-score standardisation (mean=0, std=1). Adds new columns alongside the originals — no upload required.
Manage Columns in Excel Files Online
Drop or select specific columns from Excel files directly in your browser. No upload required.
Compute Correlation Matrix for CSV Files Online
Compute a Pearson correlation matrix for numeric columns in CSV files directly in your browser. Instantly spot which variables move together — colour-coded heatmap, no upload required.
Compute Correlation Matrix for Parquet Files Online
Compute a Pearson correlation matrix for numeric columns in Parquet files directly in your browser. Instantly spot which variables move together — colour-coded heatmap, no upload required.
Compute Correlation Matrix for JSON Files Online
Compute a Pearson correlation matrix for numeric columns in JSON files directly in your browser. Instantly spot which variables move together — colour-coded heatmap, no upload required.
Excel Viewer Online
View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Excel to Parquet Online
Convert Excel files to Parquet format directly in your browser. No upload required — your data never leaves your device.