Pivot Tabel data range from Google sheets

Hi,

I would like to ask how can I get data from google sheet to excel in order to use them for pivot table as range.

I have data input sheet in google sheet. I would like to have them in excel and get all updates automatically as it is made.

Can I make a link from google sheet to excel to get the dates? For example, like I do with IMPORTRANGE formula in google sheet?