Click “Tools,” “Data Connections” and “Add.”
Choose “Create New Connection To” and “Receive Data.”
Choose “SharePoint Library or List” from the menu.
Type the URL address of the SharePoint site from which you wish to receive the list.
Choose the columns and fields that you need to retrieve from the list.
Choose ” Store a Copy of the Data in the Form Template.” Enter a name for the file and click “Finish.” You have now retrieved XML list data from SharePoint