Upload a CSV or Excel file and turn it into an interactive sales dashboard with trend charts, category breakdowns, heatmaps, filters, and summary statistics — free, in your browser.
Content last reviewed
Spreadsheet Sales Dashboard
Turn a CSV or Excel file into an interactive dashboard in seconds — free, private, no account.
CSV and XLSX up to 20 MB · processed locally, nothing is uploaded
Legacy .xls files should be resaved as .xlsx first
Upload a CSV or Excel file
Or start from the fictional sample to explore first.
Confirm the detected columns
Date, value, and category are suggested automatically.
Explore and export
Interactive charts, insights, and report-ready downloads.
What you’ll get (illustrations, not live data)
Upload a CSV or Excel spreadsheet, or open the fictional sample data.
Select the worksheet when the workbook contains multiple sheets.
Confirm the detected date, value, and category columns in the setup panel.
Review the generated charts, heatmap, statistics, observations, and data-quality notes.
Apply filters or change the aggregation, time interval, and number format.
Open the Export center to download charts, CSV summaries, or the printable report.
Upload a file with Order Date, Revenue, and Channel columns. Select monthly grouping and sum aggregation to compare the sales trend and leading channels.
Input
Order Date,Revenue,Channel
2026-01-03,1250,Online
2026-01-08,920,Retail
2026-02-04,1480,OnlineOutput
A monthly line chart, a ranked channel breakdown with percentage shares, a category-by-month heatmap, summary cards, and plain-language observations such as the leading channel's share of total revenue.After the dashboard loads, open Filters and choose a single category and a date range. Every chart, card, and observation recalculates for that subset without re-uploading the file.
Input
Filter: Category = Online, From 2026-01-01 To 2026-03-31Output
The dashboard shows only matching records — for example “Showing 52 of 210 analyzed records with 2 active filters” — while the data-quality panel continues to report the full file's parse results.The Spreadsheet Sales Dashboard is a free CSV and Excel dashboard builder that turns a familiar sales export into a focused visual report — without formulas, pivot-table setup, or an account. Upload a spreadsheet, confirm the detected columns, and the tool builds an interactive dashboard with a sales trend chart, a ranked category breakdown, a heatmap, summary statistic cards, plain-language observations, and a transparent data-quality report. Supported files are read locally in the current browser tab: rows are not uploaded to Motifuse, placed in a URL, or saved in browser storage.
It is designed for quick exploration rather than as a replacement for full business-intelligence software. Small-business owners, ecommerce sellers, freelancers, sales and operations teams, students, teachers, researchers, and consultants can use it to answer everyday questions — which month was strongest, which category leads, where the gaps and spikes are — in the time it would take to open a workbook.
Column detection combines header clues with a sample of cell values. Names such as Order Date, Revenue, Amount, Product, Region, or Channel receive extra weight, and sampled values are tested as dates, numbers, and category labels. Every suggestion stays editable: the Dashboard setup panel shows example values from each column so you can confirm or correct the mapping in seconds. Numeric normalization recognizes common currency symbols, thousands separators, percentages, parentheses for negatives, and several international separator patterns. Ambiguous slash dates such as 04/05/2026 are never silently reinterpreted — the tool asks you to choose day/month or month/day order.
Every chart uses the same normalized records. Values in the selected column are combined with the aggregation you choose — sum, average, count, minimum, or maximum. Dated records are grouped into daily, weekly, monthly, quarterly, or yearly periods; the automatic setting picks a readable interval from the overall date span. Categories are ranked by the current aggregation, and smaller categories beyond your chosen top 5, 10, 15, or 20 are combined into an Other group so the chart stays legible. Percentage shares are calculated from the analyzed total, and each period records its change from the previous period.
Results can differ from Excel for explainable reasons: rows whose value cannot be read as a number are excluded, invalid dates are excluded from time-based charts, duplicate dates are combined within their period, filters narrow the analyzed records, formulas are read from their last saved cached result rather than recalculated, and hidden Excel filters are not applied. The data-quality panel counts every exclusion.
A heatmap shows relative intensity: darker cells hold larger aggregated values under the current settings and filters. Three modes are available where the data supports them — category by month, a calendar view of dated records, and day-of-week by hour when timestamps include time. A dot marks a cell whose aggregate is exactly zero; an em dash marks a cell with no records at all, which is an important difference when checking coverage. Hovering, tapping, or focusing a cell shows its total, average, highest, lowest, and record count. Interpret spikes and lulls in context — a dark cell shows a relatively large value, not the reason behind it.
The dashboard works best with one clean table per worksheet:
A minimal example:
| Date | Category | Sales |
|---|---|---|
| 2026-01-04 | Electronics | 12500 |
| 2026-01-05 | Clothing | 8400 |
Browser analysis has practical bounds: files up to 20 MB, 10,000 analyzed rows, 120 columns, and a 50-row preview. Legacy XLS, encrypted workbooks, macros, formula recalculation, pivot tables, and external data connections are not supported. Very large or complex workbooks depend on the memory available to your browser and device. This utility provides exploratory data visualization — verify important totals against the original spreadsheet before business, accounting, tax, or financial decisions.
Upload a CSV or XLSX spreadsheet using the dropzone, or click Try sample data to explore first.
If the workbook has several worksheets, pick the one to analyze from the worksheet menu.
Check the automatically detected date, sales value, and category columns, and correct any of them from the Dashboard setup panel.
Choose how values are combined (sum, average, count, minimum, or maximum), the time interval, and the number format, then apply the changes.
Explore the summary cards, key observations, sales trend chart, category breakdown, and heatmap; hover or tap any point or cell for detailed statistics.
Use filters to focus on a date range, category, or value range without re-uploading the file.
Open the Export center to download chart images, CSV summaries, copy the statistics, or print the full report.
Drop a CSV or unencrypted XLSX file, browse for it, or start from the built-in fictional sample. Multi-sheet workbooks show a worksheet selector so you analyze exactly the sheet you need.
Date, value, and category columns are suggested from headers and sampled values, with example values shown for each choice — and every mapping can be corrected by hand, including the day/month order of ambiguous dates.
A time-series line or area chart grouped by day, week, month, quarter, or year, with optional data points and a cumulative view. Hovering any point shows the period's total, average, range, record count, and change from the previous period.
See the top 5–20 categories as a doughnut, pie, or horizontal-bar chart beside a ranked list with each category's total, share, and record count. Smaller categories fold into an Other group so the chart stays readable.
Calendar, day-and-hour, and category-by-month heatmap modes reveal strong and weak cells at a glance, with full statistics on hover, tap, or keyboard focus, and a clear distinction between zero values and missing data.
Total, average, highest, lowest, record count, best period, and overall change are shown as clear cards, alongside automatically calculated observations such as the leading category's share — derived only from your data, never from an external AI service.
Narrow the dashboard by date range, category, or value range, or exclude negative values. Filters re-aggregate the already-parsed records, so charts update immediately without re-reading the file.
Excluded rows, invalid dates, ambiguous dates, duplicates, negatives, and grouped categories are counted and explained by severity, including the effect each has on your charts — and your source file is never modified.
Download the trend chart, category chart, and heatmap as PNG images, export period and category summaries as CSV, copy the key statistics or observations, or print the full report to save as PDF.
Supported files are parsed and analyzed in the current browser tab. Spreadsheet rows are not uploaded to Motifuse, sent to analytics, or written to browser storage.
Compare revenue across months, channels, or product lines from a store or marketplace export before a weekly or monthly review.
Freelancers, consultants, and account managers can turn an approved spreadsheet into presentation-ready charts and a printable summary in minutes.
Sales and operations teams can spot unusually strong days, seasonal peaks, and quiet stretches using the trend chart, observations, and calendar heatmap.
Check a dataset for invalid dates, non-numeric values, blanks, and duplicates before loading it into a CRM, accounting system, or database.
Administrative staff can summarize registrations, donations, or bookings by period and category without building spreadsheet formulas.
Students, teachers, and researchers can explore aggregation, grouping, and missing-data behavior with their own datasets or the built-in sample.
The original spreadsheet is never modified: every transformation happens on an in-memory copy that is released when you reset or close the page.
Comma-, semicolon-, tab-, or otherwise consistently delimited text, detected automatically. Files up to 20 MB with up to 10,000 analyzed rows and 120 columns.
Unencrypted Excel workbooks with selectable worksheets, up to the same limits. Formula cells use their last saved calculated value; formulas are never executed.
Legacy binary XLS is intentionally not parsed. Open the file in Excel or LibreOffice and save it as XLSX or CSV first.
ISO and common numeric dates, Excel serial dates, currency symbols (₹, $, €, £, ¥), thousands separators, percentages, parentheses negatives, and blank cells — each handled and counted explicitly.
Sum, average, count, minimum, and maximum.
Automatic, daily, weekly, monthly, quarterly, and yearly.
Plain number, percentage, or a selected common currency — formatting only, values are never converted.
Top 5, 10, 15, or 20 categories as a doughnut, pie, or horizontal-bar chart, with smaller categories grouped into Other.
Date range, category, minimum and maximum value, and an exclude-negatives switch — applied without reparsing the file.
Calendar, day-and-hour (when timestamps include time), and category-by-month (when a category column is mapped).
Select the intended value column manually in Dashboard setup. Mixed text and numeric cells lower detection confidence; the data preview highlights unreadable values.
Choose the correct date column and, for slash dates such as 04/05/2026, the correct day/month order. Unsupported or ambiguous dates are never guessed.
Remove encryption or password protection, resave the workbook as XLSX, and make sure formula cells contain saved calculated results.
Check the data-quality panel first — a high excluded-row count usually means the wrong value column is selected or the file mixes several tables in one sheet.
If totals differ from your workbook, check the selected aggregation and column mapping first, then review the data-quality panel for excluded rows, invalid dates, and negatives. Active filters narrow every chart — the filter bar shows how many records are currently included. The tool reads formulas' saved cached results and does not apply hidden Excel filters or pivot rules, so a workbook that depends on either can differ from the dashboard. Locale-specific separators (such as 1.234,50) are recognized in common patterns, but unusual mixed formats may need cleaning in the source file.
The dashboard is designed for small and medium exploratory datasets: 20 MB per file, 10,000 analyzed rows, 120 columns, and a 50-row preview. It does not support legacy XLS, encrypted or password-protected workbooks, macros, formula recalculation, pivot tables, external workbook connections, or embedded objects, and very wide or multi-table worksheets may map poorly. Charts reflect only the mapped columns and current filters. There is no forecasting, no automatic accounting reconciliation, and no cloud saving or collaboration — dashboards exist only in the current browser session. Browser memory limits on the device also constrain very large or complex files.
This tool provides general spreadsheet visualization and exploratory analysis. It is not a substitute for professional accounting, tax, investment, or legal advice, certified financial reporting, or an audited business-intelligence system. Verify important figures against the source system before relying on them.
Supported spreadsheets are parsed and analyzed locally in the current browser tab. Spreadsheet rows are not posted to an API, written to MongoDB, placed in URLs, stored in localStorage or sessionStorage, or included in the anonymous tool-usage event, which contains only the tool's identifier. Chart images, CSV summaries, and the printable report are generated locally. Clearing the dashboard, replacing the file, refreshing, or closing the tab releases the application's references to the file bytes and normalized rows; normal browser memory may persist until garbage collection. Browser memory limits are also why file-size and row limits exist. As with any browser-based tool, follow your organization's policies before analyzing confidential data.
Use one clear header row with short, unique, descriptive column names.
Store one record per row and avoid merged cells or decorative title rows in the data region.
Prefer ISO dates such as 2026-07-19 to avoid day/month ambiguity.
Keep number formats consistent — one decimal separator style and one currency per column.
Recalculate and save formula-based workbooks before importing them.
Keep category labels consistently spelled so variants do not become separate segments.
Reconcile exported totals with the source system before sharing a final report.
Choose a value column whose unit is consistent across all rows — mixing currencies, percentages, and plain counts in one column produces misleading totals; split or normalize them first. Remove empty columns and unrelated side tables so detection stays accurate. For large operational exports, analyze a documented sample or split the file by period. When negative values represent refunds or corrections, decide deliberately whether to keep them (net view) or exclude them with the filter (gross view), and note the choice in anything you share.
The interactive tool is a dynamically loaded React client component. CSV parsing runs in a Web Worker via Papa Parse; XLSX workbooks are read by a bounded local reader that loads only the selected worksheet and never executes formulas. Headers are normalized into stable, prototype-safe keys. Pure aggregation functions produce the time-series, category, heatmap, and summary datasets; filters re-aggregate the normalized records without touching the parsed matrix, and the observation list is calculated deterministically from those aggregates. Chart.js is imported only after analysis data exists, each chart instance is destroyed on cleanup, and the expanded chart view creates its instance only while open. Heatmaps are accessible HTML with a bounded canvas used only for PNG export. CSV exports neutralize formula-like cells before RFC-style quoting, and exported PNGs are composited onto an opaque background so they stay readable in dark mode.
Unlike a full business-intelligence platform, this tool has no accounts, cloud datasets, data modeling, joins, scheduled refreshes, or shared dashboards — which is exactly what makes it faster for a one-file review and lets supported input stay local. Compared with building charts in a spreadsheet, it removes formula and pivot setup, adds automatic data-quality reporting, and keeps the original file untouched. Use spreadsheet software or a BI system when you need editable formulas, persistent models, governed metrics, collaboration, or datasets beyond the stated browser limits.
The dashboard is intended for anyone with a spreadsheet and a question: small-business owners and ecommerce sellers reviewing sales, freelancers and consultants preparing client summaries, sales and account teams checking period performance, operations and administrative staff summarizing registrations or bookings, marketers comparing channels, students and teachers exploring datasets, and researchers doing a first pass over tabular data. It is best for quick exploration and communication — not as a system of record, a forecasting engine, or a substitute for professional review.
A free browser tool that turns a CSV or Excel file into an interactive dashboard: a sales trend chart, category breakdown, heatmap, summary statistics, plain-language observations, filters, a data-quality report, and export options.
Yes. Uploading files, building dashboards, filtering, and every export listed on this page are free. There are no usage limits beyond the technical file limits, no watermarks, and no locked charts.
No. The tool works without registration, sign-in, or email collection.
No. Supported CSV and XLSX files are parsed, analyzed, charted, and exported in the current browser tab. The anonymous usage event contains only the tool's identifier — never a file name, header, row, or cell value.
CSV and unencrypted XLSX, up to 20 MB, 10,000 analyzed rows, and 120 columns. Legacy XLS, encrypted workbooks, and macro-enabled features are not parsed — resave those files as XLSX or CSV first.
Yes. The first non-empty worksheet loads initially, and a worksheet menu lets you rebuild the dashboard from any other sheet in the same locally held workbook.
The tool scores common header words such as Date, Revenue, or Category and inspects a sample of each column's values for date, numeric, and text patterns. Detected fields are marked in the setup panel with example values so you can verify them.
Yes. Every mapping is editable in the Dashboard setup panel, including the date column, value column, category column, and the day/month order used for ambiguous slash dates. A “Use recommended setup” action restores the detected configuration.
The trend chart, summary cards, observations, calendar or day-hour heatmap, data preview, and exports still work. Only the category chart and category-based views are omitted.
You still get summary statistics, the category breakdown, the data preview, the data-quality report, and category exports. Time-based charts and heatmaps need at least one readable date column.
Records that fall in the same period are combined using your selected aggregation. Tooltips still show the group's total, average, highest, lowest, and record count, so nothing is hidden by the grouping.
Rows whose selected value cannot be read as a number are excluded from the numeric analysis, and invalid dates are excluded from time-based charts only. Every exclusion is counted and explained in the data-quality panel; the file itself is never changed.
Common causes: excluded unreadable rows, a different aggregation than your formula, duplicate dates grouped into one period, active filters, formulas whose cached results are stale, ambiguous locale-specific numbers, or hidden Excel filters that the tool does not apply. The data-quality panel and filter bar make each of these visible.
It reads the calculated result that Excel last saved for each formula cell. It never executes formulas, so recalculate and save the workbook before importing if formula results have changed.
No. Header normalization, exclusions, grouping, filtering, and formatting exist only in browser memory. The source file on your device is never rewritten.
Yes. Filter by date range, category, and minimum or maximum value, or exclude negative values. Filters recalculate every chart, card, and observation instantly and show how many records are included.
Yes. The Export center collects everything: PNG images of the trend chart, category chart, and heatmap; CSV files of the period and category summaries; copyable key statistics and observations; and a printable report you can save as PDF.
Relative intensity — darker cells hold larger aggregated values under the current settings. Modes include a calendar view, day-of-week by hour, and category by month. A dot means the cell's aggregate is exactly zero; an em dash means no records exist for that cell.
Yes — 20 MB per file, with analysis capped at 10,000 rows and 120 columns so the browser stays responsive. Very large or complex workbooks are also constrained by your device's memory; splitting the file by period is the most reliable workaround.
Yes. The layout adapts to small screens with touch-friendly controls, scrollable tables and heatmaps, and expandable charts. Very large files may still exceed a mobile device's memory.
No. Those platforms provide data modeling, joins across sources, governed metrics, scheduled refreshes, and shared dashboards. This tool intentionally stays a fast, private, single-file explorer — useful before or alongside BI work, not instead of it.
No. Every number on the dashboard is calculated from the rows you uploaded. The observations describe what the data shows — such as the strongest period or the leading category — and never predict future values.
No. Dashboards exist only in the current browser session. To keep results, use the Export center — chart images, CSV summaries, or the printable PDF report.
No. Spreadsheet rows are not sent to Motifuse servers, stored in a database, or included in analytics. When you reset the dashboard or close the tab, the application releases its references to your data.
Open the data-quality panel. If most rows were excluded, the selected value column probably contains text — pick a different column in Dashboard setup. If time charts are empty, choose the correct date column or the right day/month order. The data preview highlights exactly which cells could not be read, and the sample data is a quick way to confirm the tool itself is working.