Excel to Dashboard

What is Excel to Dashboard?

Excel to Dashboard is a free, browser-side tool that turns any spreadsheet into an interactive visual dashboard in seconds. Upload an Excel workbook (.xlsx or .xls) or a CSV file, and the tool automatically analyses your data's structure, identifies column types, and generates a set of charts and KPI cards tailored to what it finds. No registration, no upload, no waiting — everything runs locally on your device using your browser's own JavaScript engine.

How it works

When you drop a file onto the upload zone, SheetJS (a battle-tested open-source spreadsheet library) reads the binary data directly in browser memory. The file never leaves your machine. For multi-sheet workbooks, you can pick which sheet to use; the tool then counts rows and columns and shows you a preview of the first twenty rows so you can confirm the data looks right before proceeding.

Column type detection is automatic. The tool samples up to 200 rows from each column and applies three heuristics: if more than 80% of non-empty values parse as finite numbers, the column is classified as numeric; if more than 70% match a date pattern, it is classified as date; everything else is text. These types drive every downstream decision — which charts are generated, which columns appear in the builder's dropdowns, and how aggregations are computed.

The auto-generated dashboard

When you click "Proceed to dashboard", the tool builds an initial layout automatically. KPI stat cards appear at the top for every numeric column — showing the sum, average, min, max, and row count — giving you an immediate numerical snapshot at a glance. Chart cards appear below in a responsive grid.

The chart-selection logic is intentionally conservative. If a text column exists with between 2 and 20 distinct values (the right cardinality for a bar chart) and there is at least one numeric column, a bar chart is generated showing the top 20 categories by sum. If a date column exists alongside a numeric column, a line chart tracks the value over time. If a text column has very few distinct values (2–8), a pie chart shows the category distribution. The tool adds charts that are likely to be meaningful, not a wall of noise.

Building your own charts

Click "Add chart" to open the chart builder modal. Choose from eight chart types: bar, horizontal bar, line, area, pie, doughnut, scatter, or KPI card. Select your category column, value column, and aggregation method — sum, average, count, min, or max. A live preview updates as you adjust any control. Click "Add to dashboard" to place the chart in the grid. Every chart card on the dashboard also shows edit and remove controls, so you can refine the layout freely.

Group & Summarize

The "Group & Summarize" panel (below the chart grid, opened from the toolbar) provides a lightweight pivot capability without any formulas. Pick a group-by column (any column), a value column (numeric), and an aggregation. The tool computes grouped totals and displays them in a scrollable table with four sort modes: value high-to-low, value low-to-high, label A–Z, and label Z–A. You can send the grouped result directly to the dashboard as a bar chart, or export it as a CSV file for use in another tool.

Exporting your work

Each chart card has a download button (the arrow icon in the card controls) that saves the chart as a PNG image at full canvas resolution — ready to drop into a presentation, report, or document. The "Export charts" button in the dashboard toolbar downloads all visible charts as separate PNG files in one click. Grouped summaries from the pivot panel can be downloaded as CSV via the "Export CSV" button that appears after computing.

Privacy and security

Nothing in this tool sends your data to a server. SheetJS parses the file in browser memory, Chart.js renders to an HTML canvas element, and all aggregation logic runs client-side. To verify this yourself: open your browser's Network tab (F12) before uploading a file and watch for outbound requests while processing — you will see none beyond the initial CDN loads for the libraries (SheetJS and Chart.js), which happen once on page load.

Supported file formats

.xlsx — Excel 2007 and later (OOXML format). The most common format for modern Excel files. .xls — Older Excel binary format (97–2003). Fully supported via SheetJS's BIFF8 parser. .csv — Comma-separated values. Works with any CSV exported from Excel, Google Sheets, or any other tool. Files up to 50 MB are accepted. For files with more than 50,000 rows, chart generation uses the first 50,000 rows for performance; the full data remains available for pivot and CSV export.

Typical use cases

Sales reporting: upload a monthly sales export and get instant bar charts by region or product, plus KPI totals for revenue, units sold, and average order value. Inventory analysis: group stock counts by category to see which product lines are over- or under-stocked. Survey results: visualise response distributions across multiple-choice columns as pie or donut charts. Financial data: compare monthly expenses or revenue over time with a line chart. Log or event data: aggregate event counts by type, region, or status code from a CSV export, then chart and export the summary.