SOLVED

Create a Link to a List that exports the list to Excel?

Copper Contributor

Is there anyway to create a link to a SharePoint list that will automatically start the process of exporting it into excel? Or a way to create a link that'll kick off a PowerAutomate workflow that will do this?

3 Replies

@Objulen 

I do not know a direct way to create a link in SharePoint Online that will automatically export a list to Excel when clicked. However, you can achieve this functionality using Power Automate (formerly known as Microsoft Flow). Here is a general outline of how you can set this up:

  1. Create a Flow in Power Automate:
    • In Power Automate, create a new flow.
    • Set up a trigger for the flow. You can use the "For a selected item" trigger, which allows you to trigger the flow manually when a specific list item is selected.
  2. Add an Action to Export to Excel:
    • In your flow, add an action that exports the list data to an Excel file. You can use the "Create an Excel table" action to create an Excel table from the list data.
    • Specify the destination for the Excel file, such as a SharePoint document library or OneDrive for Business.
  3. Test and Publish the Flow:
    • Test the flow to ensure it works as expected. You can manually trigger it by selecting a list item and running the flow.
    • Once you are satisfied with the flow's functionality, publish it.
  4. Create a Link in SharePoint:
    • In SharePoint, you can create a link to the Power Automate flow by adding a custom column or using the "Quick Links" web part.
    • Configure the link to open the Power Automate flow when clicked. Users can select a list item, click the link, and trigger the export process.

Please note that the exact steps and options may vary depending on the updates and changes made to SharePoint and Power Automate since my last knowledge update in September 2021. I recommend checking the latest documentation for SharePoint Online and Power Automate or consulting with your organization's IT department for the most up-to-date guidance.

Keep in mind that SharePoint Online provides various ways to work with list data, and Microsoft regularly updates its services, so there may be more streamlined options available now for exporting list data to Excel.The text and the steps were created with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark them as helpful and like it!

This will help all forum participants.

best response confirmed by Objulen (Copper Contributor)
Solution

Hi @Objulen,

yes you can. 

First get the ID of the list you want to export.
Go to "Gear->List Settings". Now copy the url, it should look like this

https://<tenant>.sharepoint.com/sites/<site>/_layouts/15/listedit.aspx?List=%7Bbcb327c9-a3b3-404f-a623-e91a85caf7a7%7D

Remove everything up to "List="

%7Bbcb327c9-a3b3-404f-a623-e91a85caf7a7%7D

This is url-encoded.
Replace "%7B" with "{" and "%7D" with "}".
There might by some "%2D", replace them with "-"

{bcb327c9-a3b3-404f-a623-e91a85caf7a7}

Now append that to the following url

https://<tenant>.sharepoint.com/sites/<site>/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&CacheControl=1&List=

You get this

https://<tenant>.sharepoint.com/sites/<site>/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&CacheControl=1&List={bcb327c9-a3b3-404f-a623-e91a85caf7a7}


If you open that link, your browser will download an .iqy File. If you open that using Excel, you will have your list exported to excel.

Best Regards,
Sven

That does the trick. Thank you!
1 best response

Accepted Solutions
best response confirmed by Objulen (Copper Contributor)
Solution

Hi @Objulen,

yes you can. 

First get the ID of the list you want to export.
Go to "Gear->List Settings". Now copy the url, it should look like this

https://<tenant>.sharepoint.com/sites/<site>/_layouts/15/listedit.aspx?List=%7Bbcb327c9-a3b3-404f-a623-e91a85caf7a7%7D

Remove everything up to "List="

%7Bbcb327c9-a3b3-404f-a623-e91a85caf7a7%7D

This is url-encoded.
Replace "%7B" with "{" and "%7D" with "}".
There might by some "%2D", replace them with "-"

{bcb327c9-a3b3-404f-a623-e91a85caf7a7}

Now append that to the following url

https://<tenant>.sharepoint.com/sites/<site>/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&CacheControl=1&List=

You get this

https://<tenant>.sharepoint.com/sites/<site>/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&CacheControl=1&List={bcb327c9-a3b3-404f-a623-e91a85caf7a7}


If you open that link, your browser will download an .iqy File. If you open that using Excel, you will have your list exported to excel.

Best Regards,
Sven

View solution in original post