Data ribbon > Get Data > From File > From Workbook
Browse to the file, select it, and click Import
Select the data you want to import. Excel really wants this data to be in a table format. Wherever possible, I'd recommend importing the entire sheet.
If you want to get particular, you can click
Transform Data to open up the power query editor. From there, you can pick particular columns or a certain number of rows. It's not straight SQL but you'll figure it out if you're familiar with the
QUERY() function in Google Sheets.
Excel turns your data into a table and opens the Queries and Connections sidebar. Right-click on the query in that sidebar and then click
Refresh every box and change the number of minutes as desired.