Trying to build a 'generate report' link with various options. I would have three links, each with different list filtration criteria. The idea is then that whilst people are on that page, they can click any of the three links, a report will be generated based on the criteria given, and an excel spreadsheet download will pop up on their PC.

So basically near instant excel exports based on specific criteria, which download when a link within a page is clicked.

Any pointers? Thanks.

  • Is this for SharePoint? -There's an Export to Excel button in the tab bar on each List View.
    – Paul Leigh
    Commented Nov 29, 2013 at 9:39
  • @PaulLeigh I know; and that's exactly what I need - except ideally I'd like to have three links which are pre-defined to do this with different filters.
    – Henry C
    Commented Nov 29, 2013 at 9:47

1 Answer 1


You can use the Excel URL Protocol described here: http://msdn.microsoft.com/en-us/library/ms478653.aspx

With it you can create your three links and generate the excels on the fly, example:

  • 1
    this helped a huge amount, thanks. I've now got it set up and working exactly as I want, however I'm hitting one problem in particular. Whilst this works perfectly in Internet Explorer, if I try it in Chrome or Safari I get the following error: dropbox.com/s/nj99eu2ki1isg5b/…
    – Henry C
    Commented Nov 29, 2013 at 11:53
  • 1
    ^ Obviously it's not a colossal issue as I can persuade staff to use IE for this site, but it'd be easier if all could use on anything.
    – Henry C
    Commented Nov 29, 2013 at 11:54
  • 1
    The office integration with other browser do not work very often - least effort is to use IE. Commented Nov 29, 2013 at 12:15
  • 1
    Yeah, I'll stick a note on the site to let people know they'll need IE for that feature. Thanks very much for your help.
    – Henry C
    Commented Nov 29, 2013 at 13:40
  • Server_Name/[sites/][Site_Name]/_vti_bin/…
    – Pravin
    Commented Feb 22, 2016 at 6:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.