team-files-vs-confluence-1
Confluence Smart Links Explained
See how they work, where they fail with external files, and more secure, consistent management alternatives.
Read more: Confluence Smart Links Explained
untitled_Flux 2 Pro_2026-03-26_21-41-00
Jira SharePoint Integration
Discover how to sync files, automate folders, and enhance collaboration in Jira Cloud and Data Center.
Read more: Jira SharePoint Integration
Porto-pic
About us
From the start, our goal has been to remove the hidden friction that prevents teammates from collaborating easily on the files that matter most. We believe productivity is not about adding more tools but making the ones you already use work together seamlessly. Based in Porto, ikuTeam builds the invisible layer for the Atlassian ecosystem to dissolve file silos and help over a million users stay focused and move faster.
Read more: About us
team-files-vs-confluence-1

Confluence Smart Links Explained

See how they work, where they fail with external files, and more secure, consistent management alternatives.
Read more: Confluence Smart Links Explained
untitled_Flux 2 Pro_2026-03-26_21-41-00

Jira SharePoint Integration

Discover how to sync files, automate folders, and enhance collaboration in Jira Cloud and Data Center.
Read more: Jira SharePoint Integration

About us

From the start, our goal has been to remove the hidden friction that prevents teammates from collaborating easily on the files that matter most. We believe productivity is not about adding more tools but making the ones you already use work together seamlessly. Based in Porto, ikuTeam builds the invisible layer for the Atlassian ecosystem to dissolve file silos and help over a million users stay focused and move faster.
Read more: About us
Porto-pic
Product Documentation

Nov 19, 2026

2.7 SharePoint Lists macro

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.


About lists

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.


Add a list to your page

  1. In SharePoint, open the list and copy its URL from your browser's address bar. You can also use the list's name.

  2. Edit your Confluence page.

  3. Type / and search for SharePoint Lists (or just Lists), or use the Insert menu (the + icon in the toolbar), and select the macro.

  4. 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.

  5. Paste the list URL, or type the list name, in the SharePoint List URL or name field and click Attach.

  6. 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.

  7. 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.


Layout options

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.

Display types

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.

Configuring the Custom type

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.

  1. Open the Live preview tab and find the column you want to change.

  2. Copy the name of the value you want to show, for example LookupValue.

  3. Go back to the Layout Options tab, set the column's type to Custom and type the name in the Format field.

  4. Check the Live preview tab again, then click Insert.


Open a list in SharePoint

Need SharePoint's own features, like editing items or filtering? Open the list right from your page:

  1. Click the More actions menu (···) next to the list title.

  2. Select Open in SharePoint.

The list opens in SharePoint in a new tab.


Wrap-up

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.