The data in SharePoint lists can be easily exported to an Excel file.
To export data to Excel, you must use Internet Explorer.
To export list data to Excel:
- Navigate to the Responses list
- In the List Tools menu, click the List tab
- In the Connect & Export group, click Export to Excel
- When the File Download window appears, click Open to view the spreadsheet, or Save to save it to a specific location
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.