in Excel, pull down Help and go to Excel Help. Read about "Get External Data". Microsoft has a sample web query that will do what you want. play with this and write back if you need more help.
Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.