Skip to main content
Sign In

University Web Services (UWS)

University Web Services, University of Colorado Denver

 

 
 
 

Module 3: Access & manage form data

Export Data To Excel


BackNext
 

The data in SharePoint lists can be easily exported to an Excel file.

Note

To export data to Excel, you must use Internet Explorer.

To export list data to Excel:

  1. Navigate to the Responses list
  2. In the List Tools menu, click the List tab
  3. In the Connect & Export group, click Export to Excel
    Click Export to Excel
  4. When the File Download window appears, click Open to view the spreadsheet, or Save to save it to a specific location
Tip

Data exporting from SharePoint to Excel is more reliable than from Excel to SharePoint. If you need to make updates to your data, do it in SharePoint and then export to Excel instead of Excel to SharePoint.

​​​
BackNext
University of Colorado Denver

© The Regents of the University of Colorado, a body corporate. All rights reserved.

All trademarks are registered property of the University. Used by permission only.