A worked example, end to end

Most of this site describes what ExcelInsight does. This page shows it. Below is the actual output of the analyser over a real 156-row spreadsheet — the column types it inferred, the statistics it computed, the gaps it found and the charts it proposed. These numbers are generated when the site is built, not written by hand, so they are exactly what you would get by loading the same file yourself.

The file

sample-sales-data.csv — a product order export with 156 rows and 9 columns, covering January to September 2026. It is synthetic, but shaped like a real export: regions and sales channels are unevenly distributed, prices vary within each product's band, and 5 orders have no sales representative recorded.

What the analyser inferred

No column mapping, no configuration. Types are detected from the values themselves — and the statistics below are computed for every numeric column automatically.

ColumnDetected typeDistinctMissingComputed statistics
order_dateDate119——
regionCategorical4—top value “North America” (59 rows)
productCategorical8—top value “Headset” (28 rows)
categoryCategorical3—top value “Accessories” (75 rows)
channelCategorical3—top value “Online” (66 rows)
sales_repCategorical65top value “A. Okafor” (36 rows)
unitsNumeric36—min 1.00 · max 40.00 · mean 12.65 · median 8.00
unit_priceNumeric156—min 29.02 · max 1,871.70 · mean 222.20 · median 115.38
revenueNumeric156—min 93.13 · max 20,195.04 · mean 1,954.51 · median 1,146.98

Headline figures

Total revenue
$304,903
Orders
156
Units sold
1,974
Mean order value
$1,955

Every figure here is a KPI the tool derives on its own — sum, count, mean — and each one recalculates when you apply a filter in the live dashboard.

Grouped totals

Because revenue was detected as summable and region and category as categorical, these groupings are proposed without being asked for.

Revenue by region

  • Europe$124,772
  • North America$85,188
  • Asia Pacific$78,836
  • Latin America$16,106

Revenue by category

  • Hardware$154,773
  • Accessories$130,142
  • Software$19,988

Detected time series

order_date was recognised as a date column, so the rows are bucketed by month automatically — total units by month.

  • 2026-01260
  • 2026-02155
  • 2026-03260
  • 2026-04308
  • 2026-0590
  • 2026-06245
  • 2026-07189
  • 2026-08274
  • 2026-09193

Data quality

Gaps are reported rather than quietly filled in:

  • sales_rep — 5 of 156 rows empty (96.8% complete)

30 charts proposed automatically

From 9 columns the analyser derived 30 candidate charts. You start from these rather than from an empty canvas, and keep the ones that are useful. A sample:

  • area
    units over order_date
    Total units by month
  • area
    unit_price over order_date
    Total unit_price by month
  • bar
    region Distribution
    Distribution of region values
  • donut
    region Breakdown
    Proportional breakdown of region
  • bar
    product Distribution
    Distribution of product values
  • donut
    product Breakdown
    Proportional breakdown of product
  • bar
    category Distribution
    Distribution of category values
  • donut
    category Breakdown
    Proportional breakdown of category
  • bar
    channel Distribution
    Distribution of channel values
  • donut
    channel Breakdown
    Proportional breakdown of channel
  • bar
    sales_rep Distribution
    Distribution of sales_rep values
  • donut
    sales_rep Breakdown
    Proportional breakdown of sales_rep