Question: how to open iqy file in excel?
Answer: Mac: Click on Data > Get External Data > Run Saved Query. Select or browse for the IQY file you downloaded.