+1 to leveraging the API - it will give you a lot finer-grained control to your data pulls and it will break you away from Excel's performance limitations if you're consuming large amounts of data. One potential barrier would be if you're unfamiliar with APIs and programming for data pulls/processing.
The second option, if you absolutely must use Excel is to use Power Query + the API above. It still requires the same level of programming though.
Another method, mentioned by @WayneV is to structure your data in Workspace or Data Warehouse and get CSV data.
Also there is another convoluted method to push AA data to Google Sheets, but that would require a few different tools and accounts - you would also have to consider if your organization permits that process.