Source spreadsheets
Use XLSX, CSV, and multiple related data files.
Spreadsheet analysis
Clean spreadsheets, calculate metrics, and create reviewable analysis
Upload XLSX or CSV files and explain the business question. Flowmint checks fields and anomalies, builds repeatable calculations, and produces editable spreadsheets, analysis notes, or an interactive dashboard.
Sales analysisJan–Mar
Revenue
$842k
+12.4%
Margin
38.6%
+2.1%
Refunds
2.8%
−0.6%
Revenue by region
RegionRevenueMarginStatus
East268k40.2%OK
South211k34.8%!
Combine data files with business definitions
Add only what helps the agent understand the target and verify the result.
Metric definitions
Explain how revenue, conversion, margin, and other metrics are calculated.
Exception rules
Define records that should be excluded, corrected, or flagged separately.
Deliverables
Get conclusions and a calculation trail
Cleaned data
Preserve source fields and document normalization and exception rules.
Editable XLSX
Include formulas, summaries, formatting, and charts.
Analysis notes
Explain important changes, anomalies, and data limitations.
Interactive dashboard
Filter key metrics by region, product, or time.
Process
From data inspection to reviewable delivery
01
Inspect the structure
Identify types, missing values, duplicates, and inconsistent definitions.
02
Clean and normalize
Standardize names and dates while retaining a transformation record.
03
Calculate and analyze
Generate metrics, grouped comparisons, and anomaly checks.
04
Review and deliver
Check formulas and totals and package the workbook and dashboard.
Example workflow
Turn sales records into an operating workbook and dashboard
Start from several raw sheets and preserve cleaning rules, formulas, and traceable anomaly notes.
View the full example“Clean three months of sales records, standardize region and product names, calculate revenue, margin, and month-over-month change, identify anomalies, and create an executive dashboard and reviewable workbook.”
Spreadsheet analysis questions
Will it modify the source file?
The default workflow preserves source files and writes cleaned data and results to new files.
Will formulas remain editable?
Yes. XLSX outputs can retain formulas, cell formatting, data tables, and charts.
How can I verify the calculations?
Request definitions, sample checks, grouped subtotals, and balancing against source totals.
Is it suitable for very large datasets?
Typical office datasets work well. Very large data should use a database or dedicated compute environment.
Turn spreadsheets into decision-ready results
Upload the data and describe the metric definitions and questions.