Santre Grid
Spreadsheets your team already knows.
Santre Grid keeps the ribbon, formula bar and sheet tabs people already work with, and covers budgets, reports and analysis from the first formula to the printed page. Workbooks open and save as .xlsx.
Alternative to
Q3 launch budget workbook
Sample content
Santre Grid with fictional sample content. The window follows the layout of the established application it is built on.
What is inside.
Formulas with dynamic arrays
Roughly five hundred worksheet functions cover statistics, finance, engineering, text, lookup and dates. Results spill into neighbouring cells, and LET and LAMBDA turn long formulas into readable ones.
Tables and data tools
Format a range as a table with a totals row and filter buttons, then sort on several levels. Remove Duplicates, Flash Fill, Text to Columns, data validation and subtotals tidy the data.
PivotTables and PivotCharts
Drag fields into the Pivot Table Fields pane to summarise thousands of rows. Group dates, show values as a share of the total, add calculated fields and chart the result.
Charts and sparklines
Column, bar, line, pie, scatter, waterfall, histogram, treemap and combo charts with a secondary axis. Trendlines show their equation and R², and sparklines fit a trend into one cell.
Conditional formatting
Colour scales, data bars and icon sets show the highs and lows at a glance.
What-if analysis
Goal Seek finds the input for a target result, and data tables and scenarios compare options side by side. Solver handles constrained problems, and Forecast Sheet projects a series forward.
A modern formula language
Dynamic arrays, LET, LAMBDA, MAP and REDUCE work alongside the classic functions.
Keeps what it does not edit
Custom data, external links and form controls in an .xlsx are carried through a save untouched.
Macros kept safely
Macros in .xlsm files are preserved exactly as they were and never run.
In practice.
Build a monthly budget
Enter the categories as a table with a totals row, apply accounting number formats and add a colour scale to the variance column. A bar chart of spending against plan updates as the month goes on.
Report sales by region
Import the CSV export, turn it into a table and insert a PivotTable with region in rows and quarter in columns. Add a PivotChart and sparklines, then check the key formulas with trace arrows and the Watch Window.
Print a clean report
Set the print area in Page Break Preview, drag the margins on the rulers and add headers and footers in Page Layout view. Print to the office printer or export a PDF.
Made for
Finance and accounts teams
Build budgets, reconciliations and forecasts with tables, PivotTables and what-if tools.
Sales and operations
Summarise exports by region, product and period with PivotTables, charts and sparklines.
Teachers
Keep gradebooks with formulas, conditional formatting and printed reports.
Analysts with older files
Bring data out of .xls, .xlsb and .ods files into .xlsx or CSV.
Opens and saves.
.xlsx has not yet been tested across a wide range of real-world workbooks, and very large workbooks are a known limit. .xls opens without formatting or charts, .xlsb and .ods open as values only, and PDF export covers Latin-script text only.
At the desk.
Ribbon and formula bar
Home, Insert, Formulas, Data, Review and View tabs, with a formula bar, Name Box, fill handle and point-and-click formula entry.
File view
New, Open, Info, Save As, Print preview and Export in one place, with sample workbooks to explore.
Formula auditing
Trace arrows, the Watch Window, Evaluate Formula and error checking show how a result was reached.
Page Layout views
Page Layout and Page Break Preview show the printed page while you edit.
Freeze and split
Drag the header handles to freeze panes, or split the window to compare distant ranges.
Dark mode and scaling
Work in dark mode and set the interface scale to suit your screen.
Good to know.
- Can Santre Grid open .xlsx files?
- Yes, including macro-enabled and template files and password-encrypted workbooks. It has not yet been tested across a wide range of real-world workbooks, so check complex files after opening.
- Does Santre Grid support PivotTables?
- Yes. PivotTables have a field list pane, filters, layouts, date grouping, show-values-as options, calculated fields and PivotCharts, and they save to .xlsx.
- How many functions does Santre Grid have?
- Roughly five hundred worksheet functions across statistical, maths, financial, engineering, text, lookup, date and logical categories, including LET and LAMBDA.
Explore the Stack.
Every app in the Stack is designed around one sign-in, one profile and one place for files, so work moves between them.
- Image editing
Santre Photo - Vector illustration
Santre Vector - Video editing
Santre Film - Photo library and RAW
Santre Light - PDF editing
Santre PDF - Motion graphics and VFX
Santre Effects - Page layout and publishing
Santre Layout - Interface design
Santre Interface - Word processing
Santre Docs - Audio recording
Santre Sound - Presentations
Santre Deck - CAD and drafting
Santre CAD - Document intelligence
Santre Document Intelligence