Detect Anomalies & Outliers in Spreadsheet Data

A $9,800 discount when the average is $196. You'd never catch that scrolling.

Drop your invoice, expense, or transaction file. Aynalyx compares every row across all numeric columns and surfaces the ones that don't look right. Results are ranked by severity, not by amount.

Your clients' data stays on your computer.

This app runs in your browser. No files are uploaded, no data is transmitted. You can use it with your clients' financial data.

Features

Find what needs your attention, fast

No formulas. No pivot tables. Drop your file and see which rows don't look right.

Finds what you'd miss scrolling

Aynalyx compares each row to the rest across all numeric columns and tells you what stands out. "This discount is 50 times higher than normal."

Group by Date or Category

See totals by month, by vendor, by employee - then spot which groups stand out from the rest.

Custom Ratios

Define your own ratios (like Expense ÷ Revenue) and find the rows where the ratio is unusual.

Completely Private

Your data never leaves your computer. No uploads, no servers, no cloud. Period.

Plain English

"This amount is three times higher than average" - not math formulas. Anyone can understand.

Export Results

Download your findings to Excel or CSV with all the details included.

How It Works

Three Simple Steps

1

Upload Your File

Drop your Excel or CSV file. We support any spreadsheet format.

→
2

Pick What to Analyze

Choose the columns you care about (like Amount, Quantity, etc.)

→
3

See What Stands Out

Get a prioritized list with plain English explanations for each finding.

The Principle

How We Rank Your Data

One score that sees all your metrics at once: no black box, just proven math.

1

Normalize Each Column

We convert every value to a Z-score: how many standard deviations from the average. This makes all columns comparable, whether it's dollars, quantities, or percentages.

Example: Revenue $50K when average is $10K → Z-score = 4.0
2

Combine Into One Global Score

For each row, we add up the Z-scores from ALL selected columns. This creates one number that reflects how unusual the row is across everything.

Example: Z=4.0 (Revenue) + Z=2.5 (Costs) + Z=1.8 (Delays) = Global Score: 8.3
3

Rank by Global Score

Rows with the highest composite score rise to the top. These are the rows that stand out the most when looking at ALL your metrics together.

Result: Row #247 with Score 8.3 → Ranked #1 Priority

The Color Gradient: Your Visual Guide

Each column is colored from light (normal) to dark (high). Scan a row: multiple dark cells = multiple unusual values = higher rank.

Light = Close to average
Yellow = Somewhat higher
Orange = Notably higher
Red = Much higher, stands out

The Anomaly Score: Your Quick Reference

Each row gets a single score that summarizes how unusual it is. Higher = more anomalous.

How it's calculated:

  • We normalize Z-scores across columns (so 2 columns or 50 columns give comparable results)
  • We also check if any single value is a large multiple of the average (e.g., 10x)
  • The final score is the higher of these two, catching both multi-column patterns and single extremes

Score colors: Green (0-2) = Normal, Teal (2-4) = Notable, Blue (4-6) = High, Purple (6+) = Very High

Proven Statistics

Z-scores are used by data scientists, auditors, and analysts worldwide.

Transparent Logic

No hidden algorithms. Normalize, combine, rank. That's it.

Verify Yourself

Export to Excel with all values visible. Check any number.

100% Private

All calculations happen in your browser. No data sent anywhere.

Use Cases

What Questions Can You Answer?

Which expenses are unusually high?

"Show me the transactions that are much larger than our typical spending."

Which months look different?

"Group by month and tell me which months have unusual totals."

Who has unusual patterns?

"Group by employee and show me whose totals are different from the rest."

Which products are outliers?

"Which items have sales or inventory levels that stand out?"

Which ratios look wrong?

"Calculate Profit ÷ Revenue and show me where that ratio is unusual."

What should I review first?

"Prioritize everything so I know where to focus my time."

Try It Now

Free Demo - Up to 100 Rows

Upload your file and see the results. No signup required. Your data stays on your computer.

The free demo works with up to 100 rows. Get the full version for unlimited data.
Step 1

Upload Your Data

Drop your file here

or click to browse

Supports Excel (.xlsx, .xls) and CSV

Your data never leaves your device. All processing happens locally.

or

55 invoices · 5 hidden red flags. Can you spot them?

Pricing

One tool. No recurring fees.

Pay once, use forever. Your data never leaves your browser.

Free $0 Pro $99 $59 USD one-time
Row limit 100 rows Unlimited
Multi-column anomaly detection
Grouping & aggregation
Export (Excel, CSV, JSON, PDF)
100% private, runs locally
Works offline
Lifetime updates
Get Pro License - $59 USD
Instant delivery via email
FAQ

Common Questions

Yes, 100%. Your files stay on your computer. We process everything in your browser using JavaScript. Nothing is sent to any server. You can even turn off your internet after loading the page and it will still work.

We compare every row to all the other rows. If a value is much higher or lower than average, we flag it. We also look for combinations of values that don't fit the usual pattern. It's like having an extra pair of eyes that never gets tired.

The web demo works with up to 100 rows. The full version has no limits, exports to Excel, and runs as a Windows app that works completely offline. Same logic, just more capacity.

We support CSV files, Excel 2007+ (.xlsx), and older Excel files (.xls). Basically any spreadsheet you'd normally work with.

Aynalyx uses proven statistical methods: Z-scores for standardization, Mahalanobis distance for multi-dimensional outlier detection, and robust median-based estimators to handle skewed data. These are the same techniques used in audit analytics, quality control, and academic research, automated and accessible without a statistics background.

Ready to See What Stands Out?

Try it free right now, or get the full version for unlimited data.

No files uploaded No account required Free to start, no subscription Your data stays on your computer
Try Free Get Pro