Nov 19, 2026
Show a SharePoint list on a Confluence page, always in sync with the live data in SharePoint. The SharePoint Lists macro is part of SharePoint Connector for Confluence and replaces the retired SharePoint Lists for Confluence app.
Before you start: the SharePoint Lists macro needs the Advanced Edition of SharePoint Connector for Confluence and Mirror Storage Permissions ON (the default). Your Confluence admin can check this in the admin settings.
Lists are a great way to share structured data with your team, like a project tracker, an inventory or a contact list. The list on your page shows the list title, the columns you choose and the rows, 10 per page. From the list's menu you can open it in SharePoint.
When you add the macro, you choose the SharePoint account it uses to find the list. Pick an account that can open the list in SharePoint.
In SharePoint, open the list and copy its URL from your browser's address bar. You can also use the list's name.
Edit your Confluence page.
Type / and search for SharePoint Lists (or just Lists), or use the Insert menu (the + icon in the toolbar), and select the macro.
In the Configure SharePoint List dialog, select the SharePoint account to use. No account yet? Click Connect account and sign in with your SharePoint account.
Paste the list URL, or type the list name, in the SharePoint List URL or name field and click Attach.
Choose how the list looks in the Layout Options tab, and check the result in the Live preview tab (see below). You can change this later.
Click Insert, then publish the page.
That's it. Your list now shows on the page and stays in sync with SharePoint.
Screenshot to add: the Configure SharePoint List dialog with the SharePoint List URL or name field and the Attach button.
If you see "No matching SharePoint list was found. Check the URL or name and try again.", check that you copied the full list URL and that the selected account can open the list in SharePoint.
The Layout Options tab shows one row per column of your list. To change the layout later, edit the page and edit the macro.
Columns: select or clear the checkbox to show or hide a column. The checkbox in the header shows or hides all columns at once.
Width (px): keep Auto (the default) or set a width in pixels.
Type: choose how the column's data is displayed. The choices depend on the column type in SharePoint.
Options: extra settings for the selected type, like a color, a date format or a currency.
Screenshot to add: the Layout Options tab with the Columns, Width (px), Type and Options columns.
Type | Available for | What it does |
|---|---|---|
Regular | Text, hyperlink or picture columns | Shows the data as plain text. This is the default for text columns. |
Label | Text columns | Shows the data as a colored label. Pick the color in Options. |
Custom | Text columns | Shows one value from fields that hold several values, like people or lookup fields. Type the value's name in the Format field (see below). |
Number | Number columns | Shows the data as a number. This is the default for number columns. |
Currency | Number and currency columns | Shows the data as an amount. Pick the currency in Options: $, €, £ or ¥. |
Date | Date and time columns | Shows a date. Pick the format in Options: YYYY-MM-DD, DD-MM-YYYY or MM-DD-YYYY. |
Time | Date and time columns | Shows the time as HH:mm. |
Other column types have no display options and show as "None" in the Type column.
Some SharePoint fields allow several selections. Their raw value looks like this:
[{"LookupId":12,"LookupValue":"John Smith","Email":"john@email.com"},{"LookupId":10,"LookupValue":"Sara Smith","Email":"sara@email.com"}]
Each selection has a LookupId, a LookupValue and an Email. To show the names (John Smith and Sara Smith), type LookupValue in the Format field. To show the email addresses, type Email.
Open the Live preview tab and find the column you want to change.
Copy the name of the value you want to show, for example LookupValue.
Go back to the Layout Options tab, set the column's type to Custom and type the name in the Format field.
Check the Live preview tab again, then click Insert.
Need SharePoint's own features, like editing items or filtering? Open the list right from your page:
Click the More actions menu (···) next to the list title.
Select Open in SharePoint.
The list opens in SharePoint in a new tab.
On this page, you learned how to show a SharePoint list on a Confluence page, choose its columns and formats, and open it in SharePoint.
If you still have questions about the topics covered on this page, visit our support portal and send them to us. Our team is always happy to help.