Totals and row numbers — without typing a single formula.
Turn on auto-sum for any numeric column and a running total appears in a summary row below your data. Enable auto-numbering and rows count themselves. No spreadsheet formulas required.
Benefits
Totals that update automatically
Enable auto-sum on a Number or Currency column and a summary row appears at the bottom. Add a row, change a value — the total updates instantly without any recalculation.
Row numbers that resequence themselves
Auto-numbering fills a column with sequential integers — 1, 2, 3. Add a row, delete a row, reorder — the sequence updates automatically. No manual renumbering.
Summary row exports with the table
The auto-sum row is included in PDF, Excel, and image exports — styled clearly as a summary rather than a data row. In CSV, it exports as a final row of values.
Auto-numbered cells are read-only
Auto-numbered cells are locked — you cannot type in them. This prevents accidental edits that would break the sequence. Disable auto-numbering to make the column editable again.
How it works
Set the column type to Number or Currency
Auto-sum is only available for Number and Currency columns. Click the type label in the column header and select the appropriate type.
Enable auto-sum in the Column Type panel
In the right sidebar, find the Column Type section. Toggle 'Show sum row' for any Number or Currency column. A summary row appears at the bottom of the table.
Or enable auto-numbering for a row counter
Toggle 'Auto-number' for any Number column to fill it with sequential integers. The column locks — values are managed automatically.
Use cases
- Adding a total row to a budget or expense table that sums all currency values automatically
- Numbering rows in a ranked list or ordered dataset without typing each number manually
- Showing the total quantity or value at the bottom of an inventory table
- Creating a numbered list of references, items, or entries that resequences when rows are added or removed
Related features
Every column formatted consistently — with one click.
Set a column type and every cell in that column formats automatically. Numbers right-align. Currency adds the symbol. Dates normalise. No formulas, no manual formatting.
Sort any column — the way you'd actually expect.
Click the sort icon in any column header to sort ascending or descending. Number columns sort numerically. Date columns sort chronologically. Empty cells sink to the bottom, always.
Export any table to Excel in one click.
Build your table, click Export, get a clean .xlsx file. Works with Excel, Google Sheets, and LibreOffice — any spreadsheet app.
Try Tablesmit for yourself — free, no signup required.
Open Tablesmit