S
Simpleasyty

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

  1. Edit the Simple Tables macro or open the import dialog.
  2. Open the settings for the column you want to configure.
  3. Choose Text, Number, Date, Boolean, or Enum.
  4. If available, choose a format or appearance and review the preview.
  5. 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.891,234,567.89 or 1.23M
Date Deadlines, events 2025-01-15Jan 15, 2025 or 2025-01-15
Boolean Done/active flags true / falsefilterable 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)
Use case: Document library
Document library avatar

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.4K or 1.2M.
  • Currency — Locale-aware display with currency symbol and configurable decimals.
Use case: Budget tracker
Budget tracker avatar

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.
  • ISO8601YYYY-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.

Use case: Release schedule
Release schedule avatar

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.

Use case: Task completion
Task completion avatar

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.
Use case: Article status
Article status avatar

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.

Why it matters
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.