Column formatting

Applies to: SharePoint Online, SharePoint Server 2019, SharePoint Online Small Business.

About column formatting

Enhance the display of columns in SharePoint lists with formatting. The column-formatting text outlines the elements that are presented and their display style. The data in the column remains intact.

Anyone who can design and handle views in a list can reach column formatting from the column settings.

Column formatting example

Example SharePoint list without column formatting

Here is a standard list view, without formatting:

Example SharePoint list with column formatting applied

With formatting, a coloured bar displays size, a mail link is added, and status is represented by colours and icons:

How to

Column formatting is applied using a text format called JSON. However, you don’t have to know everything about JSON to format columns. JSON is a text based data definition language that defines JSON objects as text pairs. For example, “name”: John, or “state”: WA are objects.

The simplest way to use column formatting is to begin with an example and edit it to coalesce to your specific field. The link below contains examples that you can copy, paste, and edit for your scenarios.

  • To enter the Format column panel, choose a column heading, pick Column settings from the menu, and then press Format this column. The Format column panel will launch.

Leave a Reply

%d bloggers like this: