Start in a blank sheet or a ready made template. 536 functions, pivot tables, charts and live collaboration, your Excel files open just as they are, and AI writes and explains formulas right in the sheet.
Try everything free for 3 days, no card needed.
A real screenshot of SheetsBat with sample data
Scroll through the real app. Every screen below is a screenshot of SheetsBat with sample data.
Formulas, charts and formatting that update as the numbers change, in a sheet that opens in any browser. No install, and no account needed to try it.
XLOOKUP, FILTER, SUMIFS, LET, LAMBDA, GROUPBY and PIVOTBY work the way spreadsheet people expect, and results spill into the cells next to them.
Describe a result in plain words and SheetsBat AI writes the formula with your real headers and ranges. You see it before it goes in, and Undo takes it out.
Summarise thousands of rows by region, month or product. Drag fields into rows, columns and values, group dates and filter with slicers.
Start from one of 73 free templates, like this Gantt chart, a budget, an invoice, a loan schedule or a dashboard, with the formulas and charts in place.
Share a workbook with people or a link and edit it at the same time. See where others are working, comment on cells and restore any version.
Budgets, invoices, loan schedules, dashboards, trackers and planners, sorted by category, with the formulas, formatting and charts in place.
Pick a formula or type your own. This page runs a handful of functions in your browser: SUM, AVERAGE, MIN, MAX, COUNT, COUNTIF, SUMIF, SUMIFS and XLOOKUP. SheetsBat calculates 536.
| A | B | C | |
|---|---|---|---|
| 1 | Region | Month | Revenue |
| 2 | North | Jan | 12,400 |
| 3 | South | Jan | 9,800 |
| 4 | East | Jan | 15,100 |
| 5 | North | Feb | 13,900 |
| 6 | South | Feb | 10,450 |
| 7 | East | Feb | 14,200 |
XLOOKUP, FILTER, SUMIFS, LET, LAMBDA, GROUPBY and PIVOTBY among 536 functions, with dynamic arrays that spill, tables and named ranges.
Describe a result and get the formula, fill a column, ask about your data, explain and fix errors, or press Ctrl+K for a command.
Drag fields into rows, columns and values, group dates, show percent of total and filter with slicers.
14 chart types that follow your data, plus colour scales, data bars, icon sets, dropdowns, checkboxes and validation.
Open .xlsx, .xlsm, .ods, CSV and TSV files with their formulas and formatting. Save as .xlsx, .ods, CSV, TSV or PDF.
Share with people or a link, see where others are working, discuss cells in comment threads and restore any version.
Open a blank sheet, a template or an Excel file. No account needed to try it.
Write formulas, add charts and pivot tables, or ask SheetsBat AI for the formula you need.
Edit together live, share a link with a role, or download as .xlsx, .ods, CSV or PDF.
The same OfficeBats account signs you in to every Bats app, so work flows from one to the next without another password or another bill.
One OfficeBats plan covers SheetsBat and the six other apps. Pick Free, Pro or Business once.
| SheetsBat | Free | Pro | Business |
|---|---|---|---|
| Price, covers all seven apps | $0 | $10.99 a month | $19 a month |
| Workbooks | 25 | Unlimited | Unlimited |
| Cells per workbook | 500,000 | 5 million | 5 million |
| Largest import | 10 MB | 50 MB | 50 MB |
| Version history | 7 days | A year | A year |
| Collaborators per workbook | 3 | 100 | 100 |
| Every function, chart, pivot table and template | Included | Included | Included |
| Shared AI credits each month | 300 | 5,000 | 20,000 |
SheetsBat is a spreadsheet app that runs in any browser. It calculates 536 functions, from SUM and SUMIFS to XLOOKUP, FILTER, LET, LAMBDA, GROUPBY and PIVOTBY, with dynamic arrays that spill into the cells next to them. Function names, arguments and error values work the way spreadsheet people expect, so the formulas you know work the first time.
Your Excel files open just as they are, with their formulas, formatting, tables and rules, and download again as .xlsx, .ods, CSV or PDF. Add charts that follow your data, summarise thousands of rows with a pivot table and slicers, and let conditional formatting point out what needs attention.
Describe what you need in plain words and SheetsBat AI writes the formula with your real headers and ranges. It can also fill a column, answer questions about your data, explain a formula someone else wrote and fix errors. You see every change before it goes in, and Undo removes it.
Sign in to SheetsBat with your OfficeBats account. One plan covers SheetsBat and every other Bats app, spreadsheets live in the same Drive as your documents and PDFs, and AI features draw from one shared credit wallet.
Share a spreadsheet, edit it together live, see who is where, comment on cells and roll back mistakes. A step by step guide on the free SheetsBat plan.
Build a month by month loan schedule with PMT, IPMT and PPMT, then see how extra payments change your payoff date and interest. Free template included.
Turn a long list of sales into a clear summary by region and quarter. A beginner friendly pivot table walkthrough with grouping, totals and percentages.
Yes. The free plan includes 25 workbooks of up to 500,000 cells each, every function, chart, pivot table and template, live editing with 3 collaborators per workbook and your share of the AI wallet.
Unlimited workbooks, 5 million cells per workbook, 50 MB imports, a year of version history and 100 collaborators per workbook, plus Pro in every other Bats app.
Yes. SheetsBat opens .xlsx, .xlsm, .ods, .csv and .tsv files with their formulas and formatting, and downloads workbooks as .xlsx, .ods, CSV, TSV or PDF.
No. Open a blank sheet or a template and start typing. Create a free account when you want to save it, share it and open it on other devices.
No. It receives what the task needs: the sheet name, headers, a small sample of rows and your selection. You see each change before it goes in, and Undo takes it out.
Create a free account once and use it for SheetsBat and every other Bats app.