You can get the data with one of these:
• IEX Trading: https://iextrading.com/
• Alpha Vantage: https://www.alphavantage.co/
I’ve done research on both for one of my projects and Alpha Vantage is the one most likely to increase in price. I can see IEX staying free for the foreseeable future.
You then connect them to excel with this bad boy:
I haven’t tried it, but I’ve heard it’s really good!