I have created a joined view (with a Data View Web Part in SharePoint Designer), how can I export it (ideally to Excel)?


There isn't way for that to directly export to Excel. However, as iOnline247 mentioned, you can use jQuery to convert the HTML table on the page to CSV. Then you can save that and open it with Excel: http://www.kunalbabre.com/projects/table2CSV.php

  • I've used that library many times, works well. – Eric Alexander May 2 '12 at 19:34
  • Interesting... Does this work when the table contains other tables (which would obviously be the case with joined views)? Also, it doesn't address the save step. – Christophe May 2 '12 at 19:49
  • link not working anymore – netadictos Jan 9 '18 at 9:25

John Chapman is spot on with deciphering my comment. With a php solution, you'd have to have those bits on the server for it to work. I'm more familiar with datatables and the export options that exist with this library.

Datatables TableTools

If I remember correctly, we've done some very funky reporting --> export using this library. I'll ping Mark Rackley and get a definitive answer on the nested table question.

  • thx Matt. It seems that the TableTools rely on Flash, like what I have on my user toolkit. Same concern, does it work with multiple layers of tables, not just a datagrid? – Christophe May 3 '12 at 6:43
  • Mark will have a definitive answer. He'll be able to set this straight. It's been a while since I've worked with the codebase on that project. I thought we did though. – iOnline247 May 3 '12 at 12:51

What I did was to:

  1. Create and Web Query in Excel (How to create a Web Query in Excel),
  2. save the query (*.iqy),
  3. uploaded the web query file to the site
  4. and just added "Export to Excel" linked to the query file.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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