This guide will walk you through the simple steps to open IQY files on your Mac. Often originating from Informer here on campus, IQY files are web query files that allow you to retrieve data directly into a spreadsheet program like Microsoft Excel.

The initial step is to retrieve the iqy file. Often these files are emailed to you or saved directly from Informer. The iqy files are not able to be directly opened by double-clicking the file on a Mac, instead we need to follow a couple of steps to open this file from Microsoft Excel on a Mac.

1. With the iqy file stored on your Mac, open Microsoft Excel.

2. With Excel open to a new workbook, click the Data menu — the one at the top of the screen, not the one on the ribbon —
3. Click Get Data
4. Click Run Web Query.

5. Navigate to the file on your computer
6. Click Get Data

7. At the Import Data prompt, click the Import button to pull the data into the blank workbook and sheet that you are currently on.

8. Depending on the data being pulled, there may be additional prompts. The screenshot below is an example of one such additional prompt. It is recommended that you not check the box to Use this value/reference for future refreshes because this will make it more difficult to pull in different data in the future.