Wednesday, May 9, 2012

How to export a SharePoint 2010 list to Excel

  1. navigate to the list in question
  2. click on the "List" tab within the "List Tools" tab
  3. click Export to Excel
  4. You will end up with a .iqy file which one may open in Excel just by double-clicking upon it. This format references the live data in the SharePoint list and gives it to you in Excel format.
  5. save out a .xlsx file from the .iqy file
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)