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.
Benefits
Types enforce consistency
A Number column right-aligns every cell and applies consistent decimal formatting. A Currency column adds the currency symbol. You set the type once — every cell follows.
Change type from the column header
Click the type label in any column header (it shows 'Text' by default) to open the type selector. The entire column updates instantly.
Sorting respects column type
Sort a Number column and the sort is numeric — 10 comes after 9, not before 2. Sort a Text column and the sort is alphabetical. The type determines the sort logic.
Types carry through to Excel
Column type information is written to the Excel export. Number columns export as number cells. Date columns export as date cells — not text strings that look like dates.
How it works
Click the type label in the column header
Each column header shows the current type — 'Text' by default. Click it to open the column type selector.
Choose a type
Select Text, Number, Currency, Percentage, or Date. Every cell in that column updates its formatting immediately.
Add data
Type values into the column cells. The formatting applies automatically as you enter content.
Use cases
- Setting a Price column to Currency so every cell shows the £ or $ symbol consistently
- Using Number type for a quantity column so totals sort and sum correctly
- Applying Percentage to a completion column for a progress-tracking table
- Using Date type so a chronological column sorts correctly rather than alphabetically
Related features
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.
Start from a structure, not a blank grid.
Tablesmit's built-in templates generate the right columns, headers, and row structure for common table types. Skip the setup and get straight to the content.
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