SharePoint
Return to PEPFAR SharePoint

How to Export a SharePoint List into Excel

Bardha Ajeti -

This article will walk you through the steps on how to export a SharePoint list into Excel:

  1. In Internet Explore, open a page that contains a list such contacts. Remember: it's always best practice to use this browser with SharePoint.
  2. Select an item in the list to set the “context” of the menu to the list by clicking in the space by an item underneath the Checkmark at the top of the list.
    mceclip1.png
  3. Click “List" then “Export to Excel”
    mceclip2.png
  4. You will be asked to save a .iqy file. Please give this file a meaningful name when you save it such as "your team_contact list."
    mceclip3.png
  5. Open the .iqy file in Microsoft Excel. Select “Enable” when presented with the following Security Notice.  You may also be required to supply your SharePoint (PEPFAR.net) username and password.

       mceclip5.png

  1. Save the file as an Excel Workbook with a meaningful name when it opens.

    mceclip7.png


You have now exported a SharePoint list into Excel!

 

 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.