Column Data Type
Set a type for each column to improve sorting, filtering, grouping, and formatting. Simple Tables supports Text, Number, Date, Boolean, and Enum.
How to set a column type
- Edit the Simple Tables macro or open the import dialog.
- Open the settings for the column you want to configure.
- Choose Text, Number, Date, Boolean, or Enum.
- If available, choose a format or appearance and review the preview.
- Click Save to apply the change.
Tip: Changing a column type affects how values are interpreted and displayed, but it does not modify the original raw data.
At a glance
| Type | Good for | Example |
|---|---|---|
| Text | Names, titles, notes, links | [Link](url) → Clickable link |
| Number | Prices, quantities, metrics | 1234567.89 → 1,234,567.89 or 1.23M |
| Date | Deadlines, events | 2025-01-15 → Jan 15, 2025 or 2025-01-15 |
| Boolean | Done/active flags | true / false → filterable true/false values |
| Enum | Status, priority, category | "In review" → pill, colored text, or plain label |
Examples are illustrative. Actual formatting depends on your selected format, appearance, and locale.
Text
Use Text for names, titles, descriptions, IDs, and general string values. Text works well with search and filtering and is displayed as entered.
Links inside Text columns
Text columns can render links when the cell value contains a supported link format.
- Markdown:
[Link](https://link.com) - HTML anchor:
<a href="https://link.com">Link</a> - Mixed content:
This is a text [Link](https://link.com)
Acme Co — Knowledge Base
Titles and authors displayed clearly in a searchable table.
Set “Title” and “Author” to Text to keep names readable and easy to filter.
Number
Use Number for prices, quantities, percentages, and metrics. Number formatting changes the display only, not the stored value.
Formats
- Default — Plain number display.
- Decimal — Thousands separators with configurable decimals.
- Compact — Short display such as
3.4Kor1.2M. - Currency — Locale-aware display with currency symbol and configurable decimals.
Acme Co — Finance
Readable amounts for reporting and review.
Set “Amount” to Number → Currency to display values clearly while preserving numeric behavior for sorting and calculations.
Date
Use Date for deadlines, events, and timestamps. Date columns sort chronologically and can support date-based filtering.
Formats
- Default — Locale-based date display.
- ISO8601 —
YYYY-MM-DD. - Custom format — A pattern that matches your preferred display style.
If a value cannot be parsed as a date, the preview may show Invalid date until the value or format is corrected.
Acme Co — Product
Dates that behave like real dates.
Set “Release Date” to Date with ISO8601 when you want a consistent format across locales and teams.
Boolean
Use Boolean for true/false fields such as Active, Completed, or Approved.
Hikari Solutions — PMO
Simple true/false tracking for team workflows.
Convert “Done?” to Boolean so teams can quickly filter or review completed tasks.
Enum
Use Enum when a column should contain a fixed set of labels such as Status, Priority, or Category.
Appearance
- Pills — Colored pill-style labels.
- Simple — Small indicator with text.
- Colored text — Text colored by value.
- Raw — Plain text.
Manage values
- Discovered values show the unique labels already present in the column.
- Use Add new value to introduce a label that is not currently present.
- Removing a configured label limits future options but does not automatically rewrite existing cell text.
Knowledge Base — Documentation Team
Clear status labels for filtering and review.
Convert “Status” to Enum with values such as Draft, In review, Approved, and Archived to make the table easier to scan and filter.
Choosing the right column type helps tables behave more predictably and makes the final result easier to read, sort, and filter.
Want to try it in your site? InstallSimple Tables for Confluence from the Atlassian Marketplace.