Five Number tools › Column Formatting Builder
SharePoint Column Formatting Builder and Preview
Paste the JSON from "Format this column" and see the cell render live as you edit. Set a sample value for @currentField and the preview updates. It understands both expression styles, the abstract operator form and the Excel-style =if(...) form, and it flags unknown element types, bad attributes and unknown operators.
Start from an example (loads JSON and a sample value)
Numbers and ISO dates are detected automatically. Other-column refs like [$Title] use a placeholder in preview.
Live preview approx. of the SharePoint cell
The rendered cell appears here.
This is a close approximation using Segoe UI and the built-in sp-field-severity colors. Fluent UI icons are shown as stand-in glyphs, and real list theming or custom fonts may differ slightly.
What this tool checks
- Valid JSON and a present
$schema(the v2 column-formatting schema is recommended). - elmType is one of
div, span, a, img, svg, path, button, p, filepreview. Anything else is an error in SharePoint. - attributes keys are limited to
href, rel, src, class, target, title, role, iconName, d, aria, data-interception, viewBox, preserveAspectRatio, draggable. - Expressions in both forms: the abstract
{"operator": "...", "operands": [...]}and Excel-style strings that start with=. Unknown operators are flagged. - Links allow only
http,https,mailtoandtel. In SharePoint, images load only from allowed Microsoft and tenant domains; this preview does not fetch remote images at all (only inlinedata:images render, remote ones show a placeholder) so nothing you paste reaches an outside server.