Column Formatting Generator
Generate SharePoint list column formatting JSON for conditional styling and custom rendering.
// Select a column type and template to generate formatting JSONHow to Use the Column Formatting Generator
The SharePoint Column Formatting Generator produces JSON definitions compatible with the SharePoint column formatting feature available in SharePoint Online (Microsoft 365) and SharePoint Server Subscription Edition. Column formatting lets you customize how list column values are rendered without writing code — directly from the column settings menu.
Choose a column type matching your SharePoint column, then pick a template such as progress bar, conditional color coding, status badges, or overdue date highlighting. The tool generates a complete JSON object you can paste directly into the Format this column dialog in SharePoint list settings.
Applying Column Formatting
To apply: open your SharePoint list, click the column header, select Column settings → Format this column, choose Advanced mode, paste the generated JSON, and click Save. The formatting applies immediately without requiring an app deployment or admin permissions.
Available Templates by Type
- Number — Progress bar (fills proportionally), conditional color (green/yellow/red thresholds), number badge.
- Choice / Status — Color-coded pills with configurable value-to-color mappings, icon + text combinations.
- Date — Relative date display ("3 days ago"), overdue highlighting when a date is past the threshold.
- Yes / No — Check mark and X icons replacing true/false text.
- Text — Highlight matching values, truncate long text with a tooltip for the full value.
- Person — Show profile picture alongside the person's display name.