MSSheets
Spreadsheets that calculate fast and look sharp.
MSSheets is a spreadsheet with a ribbon, formula bar, charts, PivotTables and a calculation engine built for dynamic arrays. It reads and writes XLSX, CSV and TSV files.
Serious formulas
500+ functions, dynamic arrays with spilling, LET, LAMBDA, MAP, REDUCE, SCAN and structured table references.
Charts and pivots
Seventeen chart types, sparklines, PivotTables with filters and date grouping. Selecting a chart outlines its source data.
Quick to recalculate
Incremental recalculation and a virtualised grid that only lays out what is on screen keep big workbooks responsive.
Sales dashboard
A quarterly sales table with banded rows, filter buttons, totals, data bars, arrow icons and sparklines, beside a clustered column chart and a pie chart.
PivotTables
A PivotTable summarising revenue by region and product with a Channel filter and grand totals, with the PivotTable Fields pane open on the right.
Budget formatting
A household budget with accounting formats, red highlights on overspent rows, a colour scale on percent used, a totals row and a bar chart.
Everything in MSSheets
Formulas
- 500+ worksheet functions
- Dynamic arrays with spilling
- LET, LAMBDA, MAP, REDUCE, SCAN, BYROW and BYCOL
- Structured table references
- Point-mode entry with coloured references
- Dependency-graph calculation engine
Charts
- Seventeen chart types
- Chart Design tab and Format Chart pane
- Sparklines in cells
- Source data outlined when you select a chart
- Charts saved to and read from XLSX
Analysis
- PivotTables with field list and report filters
- Date grouping and show-values-as
- Sort and AutoFilter
- Flash Fill
- Data validation
- Outlining and subtotals
Formatting
- Accounting and custom number formats
- Cell styles and table styles
- Conditional formatting with colour scales and data bars
- Icon sets for status at a glance
- Frozen headers
- Format Cells and Paste Special
Files & Print
- XLSX styles, themes, tables and charts round-trip
- Pictures, comments and hyperlinks round-trip
- CSV and TSV import and export
- Page Break Preview and print settings
- PDF export and printing
- Dark mode
