Question: how to import data from sharepoint into excel?
Answer: Using the Saved Connection in a new Excel file Click on the Data tab and click Existing Connections and then Browse for More … and navigate to the saved Office Connection. On the Import Data select OK, and the Data from SharePoint just seamlessly Jumps into the Spreadsheet.