> For the complete documentation index, see [llms.txt](https://developer.collibra.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://developer.collibra.com/tutorials/export-collibra-platform-users-to-microsoft-excel.md).

# Export Collibra Platform users to Microsoft Excel

{% hint style="info" %}
The following example uses Microsoft Excel for Office 365 on Windows 10 Pro.
{% endhint %}

To get a list of all the users of your Collibra Platform in Excel:

{% stepper %}
{% step %}
In Microsoft Excel, go to **Data** → **From Web**.

<img src="https://2912049260-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8DYDBo6jzvQ73H6CZj6k%2Fuploads%2Fgit-blob-23ea6b24774b5d3576102ed7a50bee14ba1d7684%2Fdocs_howto_excel-users-from-web.png?alt=media" alt="" width="275">
{% endstep %}

{% step %}
In the dialog box, enter the request URL: *https\://\<your\_collibra\_url>/rest/2.0/users*, and then click **OK**.

<img src="https://2912049260-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8DYDBo6jzvQ73H6CZj6k%2Fuploads%2Fgit-blob-976c6eeff7fa26905de7f41122159a61a6d93d52%2Fdocs_howto_excel-users-url.png?alt=media" alt="" width="350">
{% endstep %}

{% step %}
In the **Access Web content** window:

1. Select the **Basic** tab.
2. Provide your credentials.
3. Click **Connect**.

<img src="https://2912049260-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8DYDBo6jzvQ73H6CZj6k%2Fuploads%2Fgit-blob-362daeba90d84b50048ec9dab0993d5c467a2f9c%2Fdocs_howto_excel-users-credentials.png?alt=media" alt="" width="351">
{% endstep %}

{% step %}
In the **Power Query Editor** window:

1. In the **results** row, click **List**.

   <img src="https://2912049260-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8DYDBo6jzvQ73H6CZj6k%2Fuploads%2Fgit-blob-e9a830a3a92732189ebafd2f6d7bf0a4d65204cc%2Fdocs_howto_excel-users-list.png?alt=media" alt="" width="215">
2. In the **Transform** menu, click **To Table**.

   <img src="https://2912049260-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8DYDBo6jzvQ73H6CZj6k%2Fuploads%2Fgit-blob-c1581aede9d6cee6470769b94daaa059728caceb%2Fdocs_howto_excel-users-to-table.png?alt=media" alt="" width="215">

{% endstep %}

{% step %}
In the dialog box, click **OK**.

<img src="https://2912049260-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8DYDBo6jzvQ73H6CZj6k%2Fuploads%2Fgit-blob-09f1f5a775fedfe17a0754536cb57aba90424328%2Fdocs_howto_excel-users-to-table-options.png?alt=media" alt="" width="350">
{% endstep %}

{% step %}
In the **Power Query Editor** window, in the heading of the table, click the divergent arrows icon.

<img src="https://2912049260-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8DYDBo6jzvQ73H6CZj6k%2Fuploads%2Fgit-blob-892229161ebb41486a80a6b7654318d84499209b%2Fdocs_howto_excel-users-columns.png?alt=media" alt="" width="180">
{% endstep %}

{% step %}
In the dialog box, select the columns you want to include in the table, and then click **OK**.

<img src="https://2912049260-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8DYDBo6jzvQ73H6CZj6k%2Fuploads%2Fgit-blob-2c7740537ee34ab2446a819ece998a2d6d7b4fae%2Fdocs_howto_excel-users-columns-options.png?alt=media" alt="" width="257">
{% endstep %}

{% step %}
In the **Power Query Editor** window, in the **Home** menu, click **Close & Load**.

<img src="https://2912049260-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8DYDBo6jzvQ73H6CZj6k%2Fuploads%2Fgit-blob-9c9c3a8b6ffded14cef74baebf07053d71a70884%2Fdocs_howto_excel-users-load.png?alt=media" alt="" width="180">
{% endstep %}
{% endstepper %}

<i class="fa-chevrons-right">:chevrons-right:</i> The list of Collibra Platform users with the columns you have selected is loaded in a new sheet of your Excel workbook.

<img src="https://2912049260-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8DYDBo6jzvQ73H6CZj6k%2Fuploads%2Fgit-blob-b66f0b92cbfe4291ebe5a36732e1eba11e0c4ba4%2Fdocs_howto_excel-users-table.png?alt=media" alt="" width="273">
