Question: how to export data from sharepoint to excel?
Answer: Navigate to the SharePoint site that contains the list.
On the Quick Launch, select the name of the SharePoint list, or select Settings. ... 
Select List, and then select Export to Excel. ... 
If you are prompted to confirm the operation, select OK.
In the File Download dialog box, select Open.