Forum Discussion

Objulen's avatar
Objulen
Copper Contributor
Sep 11, 2023

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

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?

Lists
SharePoint Online
  • SvenSieverding's avatar
    SvenSieverding
    Sep 12, 2023

    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

  • SvenSieverding's avatar
    SvenSieverding
    Bronze Contributor
    Sep 12, 2023

    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

    • Objulen's avatar
      Objulen
      Copper Contributor
      Sep 12, 2023
      That does the trick. Thank you!
    • FAlpizar's avatar
      FAlpizar
      Copper Contributor
      Jul 25, 2024

      Thanks...
      You can also include de view on the link... just append "&View={ID view} at the end.  The ID view, you can get it the same way you got the list ID, as Sven explained, just use the text after "View=". It will also be URL encoded.

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Sep 11, 2023

    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.