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

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