How to Map Notion Properties to TableCrafter Columns

Updated July 2026 • 7 min read • By Fahad Murtaza

Notion supports more than a dozen property types, and each one is structured differently in the Notion API response. TableCrafter normalizes, "flattens", every property to a clean table value: titles become text, selects become badges, multi-selects become multiple badges, dates respect your format, and complex nested values are reduced to readable strings. This guide covers exactly how each Notion property type maps to a TableCrafter column. WordPress powers 43% of all websites globally (W3Techs, July 2026), and TableCrafter bridges the gap between the data you collect and the tables your users need to see, no custom PHP, no dashboard access required for viewers. The free version on WordPress.org supports CSV, JSON, Google Sheets, and Excel. Pro adds Gravity Forms, Airtable, Notion, WooCommerce, REST APIs, inline cell editing, export to CSV/PDF, role-based column visibility, and auto-refresh. Every table embeds on any page with a [tablecrafter] shortcode or the native Gutenberg block. Auto-refresh tables reduce page reload frequency by 89% in live-data dashboard deployments (Kinsta performance benchmarks, 2024).

How Does Property Mapping Work?

When TableCrafter queries your Notion database, the API returns each row as a set of properties, where every property is a typed object, not a plain value. A Notion select, for example, comes back as a nested object containing the option's name and color, not just the text. TableCrafter's payload normalizer walks each property, reads its type, and reduces it to a single scalar (or a comma-joined string for multi-value types) that a table cell can display.

Each property name in your database becomes a column key. You can then toggle columns on or off, relabel them, set their display type, width, and sort/filter behavior in the Columns configuration panel.

How Does Three Columns TableCrafter Adds Automatically Work?

Alongside your database properties, TableCrafter exposes three metadata values from every Notion row. You can surface or hide each like any other column:

• notion_id, the Notion page (row) ID. Useful as a stable key; usually hidden from public tables.
• notion_created_time, when the row was created, as an ISO 8601 timestamp.
• notion_last_edited_time, when the row was last edited, as an ISO 8601 timestamp.

How Does Property Type Reference Work?

Title

Notion type: title

Every Notion database has exactly one title property. TableCrafter concatenates the title's rich-text segments into a single plain-text string. This is your primary column, names, page titles, item labels.

• Renders as: Plain text
• Search: Yes
• Filter type: Text contains

Rich Text

Notion type: rich_text

TableCrafter concatenates all rich-text segments into plain text. Inline formatting (bold, italics, links, colors) is flattened away, the cell shows the readable text only. For long notes, set a column width or truncation so the table stays scannable.

• Renders as: Plain text (formatting stripped)
• Search: Yes
• Filter type: Text contains

Number

Notion type: number

The numeric value is passed through as a number, so sorting is numeric (not lexicographic). You can add a currency or unit prefix/suffix in the column settings.

• Renders as: Number (right-aligned)
• Search: No (use a range filter)
• Filter type: Numeric range

Select

Notion type: select

TableCrafter reads the selected option's name and renders it as a badge-style label. For filtering, it builds a dropdown of all distinct values in the column.

• Renders as: Badge
• Search: No
• Filter type: Dropdown select

Status

Notion type: status

Notion's Status property is distinct from Select but maps the same way: TableCrafter reads the status option's name and renders a badge. Status columns are ideal for roadmaps and task lists where visitors want to filter by stage.

• Renders as: Badge
• Search: No
• Filter type: Dropdown select

Multi-Select

Notion type: multi_select

A multi-select returns an array of options. TableCrafter joins the option names into a comma-separated value, which renders as multiple badges in the cell. The filter is a multi-select dropdown, a row matches if it contains any of the chosen values (OR logic).

• Renders as: Multiple badges
• Search: No
• Filter type: Multi-select dropdown

Date

Notion type: date

Notion returns dates in ISO 8601. TableCrafter formats them using your configured date format (for example MM/DD/YYYY). Sorting is chronological and the filter is a date range picker. If the Notion property is a date range (it has both a start and an end), TableCrafter renders it as start → end in a single cell.

• Renders as: Formatted date, or start → end for ranges
• Search: No
• Filter type: Date range

Checkbox

Notion type: checkbox

A checkbox maps to a boolean and renders as a checkmark (true) or a dash (false).

• Renders as: Checkmark / dash
• Search: No
• Filter type: Boolean (Yes / No / Either)

Email, URL, and Phone

Notion types: email, url, phone_number

Each passes through as a string. Set the column type so they render as actionable links: email as a mailto: link, phone as a tel: link for click-to-call on mobile, and URL as a clickable hyperlink (you can override the link text with a static label).

• Renders as: mailto / tel / hyperlink
• Search: Yes
• Filter type: Text contains

People

Notion type: people

A People property returns an array of Notion users. TableCrafter resolves each to the user's display name and joins them with commas. If a user object has no name available (some integrations return only IDs), it falls back to the user ID for that entry.

• Renders as: Comma-separated names
• Search: Yes (searches resolved names)
• Filter type: Text contains

Files & Media

Notion type: files

Notion file properties return an array of attachment objects. TableCrafter joins the file names into a comma-separated string. It surfaces the filenames for reference rather than rendering inline image thumbnails.

• Renders as: Comma-separated file names
• Search: Yes
• Filter type: Text contains

Relation

Notion type: relation

A relation property links to rows in another Notion database and returns an array of related page IDs. TableCrafter joins those IDs with commas. Unlike a spreadsheet lookup, it does not automatically resolve each related page to its title.

• Renders as: Comma-separated related page IDs
• Search: Limited (matches on the ID strings)
• Filter type: Text contains

Created Time and Last Edited Time

Notion types: created_time, last_edited_time

These system timestamp properties pass through as ISO 8601 strings. Map them as Date columns to apply your configured date format and enable chronological sorting. (These are the property-level versions; the row-level notion_created_time / notion_last_edited_time values described earlier are always available too.)

• Renders as: Formatted date/time
• Search: No
• Filter type: Date range

Formula, Rollup, and Other Computed Types

Notion types: formula, rollup, and any newer or less common type

For property types without a dedicated rule, TableCrafter falls back to a JSON encoding of the property object so the data is never lost. The cell will show the raw structured value rather than a clean scalar.

How Does Overriding the Auto-Detected Column Type Work?

TableCrafter pre-configures a sensible column type for each property, but you can override it in the Columns panel. Common overrides:

• A rich text property that actually holds a URL → set the column type to URL for a clickable link.
• A number that represents money → add a currency prefix/suffix.
• A timestamp string → set it to Date so it formats and sorts chronologically.

What Are the Next Steps?

• How to Connect a Notion Database to TableCrafter, first-time setup
• How to Display a Notion Database as a Live WordPress Table, read-only display, filtering, and refresh
• How to Map Airtable Fields to Table Columns, the equivalent reference for Airtable