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.