Question: how to automatically export data from sharepoint to excel?
Answer: From the command bar of the SharePoint list, select Export to Excel . ...  If needed, select OK > Open after the file download begins. If prompted and you trust the SharePoint site, in Excel's security page, select Enable.