+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 structu...