Question: how to extract data from sharepoint into 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.