Question: how to import sharepoint data into excel?
Answer: If prompted and you trust the SharePoint site, in Excel's security page, select Enable. In Excel's Import Data dialog, select the How you want to view this data and Where do you want to put the data options. When done, select OK. The list should appear in Excel.