Five Number tools
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.

Your JSON is never sent anywhere. Validation and preview run in your browser.
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, mailto and tel. In SharePoint, images load only from allowed Microsoft and tenant domains; this preview does not fetch remote images at all (only inline data: images render, remote ones show a placeholder) so nothing you paste reaches an outside server.

Disclaimer

These tools are provided free and as-is, with no warranty of any kind. The preview is an approximation of the SharePoint renderer and can differ from the real list. Always verify in SharePoint before you rely on it.

fivenumber tools is an independent project and is not affiliated with, sponsored by, or endorsed by Microsoft. Microsoft, Microsoft 365, SharePoint, Entra, OneDrive and Copilot are trademarks of the Microsoft group of companies.

Send feedback

Found this useful, or hit a snag? Tell me what worked and what would make it better. Your note comes straight to me.

Thanks, your feedback was sent.

I read every note. If you left your email, I may follow up.