Question: how to open iqy file in excel 2016?
Answer: Create a worksheet and paste into different cells: The key generated above. A timeframe (eg. lastMonth) Your Google Analytics profile id or name. ... 
Selected a destination cell, then. Windows: Click on Data > Get External Data > Existing Connections. Select or browse for the IQY file you downloaded. Click Close.