Import Web Data into Excel for Mac with a Saved Web Query
Question details
Create and run a saved web query to import web data into Excel for Mac when the Windows Web button is unavailable.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user wants to import an HTML table from a web page into an Excel worksheet.
- Observed behavior
- A saved web query directs Excel to the page so its table data can be placed in the worksheet.
Copy the URL of a web page containing an HTML table and check that your Excel for Mac version offers a saved web query command. Menu names and availability vary by version.
Create and run an IQY web query in Excel for Mac
Use a plain-text query file to import a web page's table in Excel versions that support saved web queries.
Open a new document in Microsoft Word and paste the URL of the page containing the HTML table.
Choose File > Save As, select Plain Text, and save the file in the Office Queries folder. In the File Conversion dialog, select MS-DOS encoding and Insert Line Breaks.
In Finder, locate the saved file and change its extension from .txt to .iqy. Confirm the extension change if prompted.
In Excel, select Data > Get External Data > Run Web Query, or Data > External Data > Run Saved Query, depending on your version. Select the IQY file and choose a worksheet destination, such as cell A1, when prompted.

Work with imported spreadsheet data in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheet data. Open an existing Excel workbook in WPS Spreadsheets for an easy transition; WPS does not enable Excel for Mac's saved web query command.

Frequently Asked Questions
What should I put in the web query file?
Paste the URL of a page containing an HTML table into a new Word document, then save it as plain text and give the file an .iqy extension.
Where do I run the query in Excel for Mac?
Depending on your version, look under Data > Get External Data > Run Web Query or Data > External Data > Run Saved Query. Select the saved IQY file when prompted.
Why is my saved query unavailable or disabled?
Check in Finder that the file has an .iqy extension and was saved as plain text with MS-DOS encoding and line breaks enabled. Also check whether your Excel version supports the saved web query command.
Can I choose where the imported data appears?
When Excel prompts for a destination after you run the query, choose a worksheet cell such as A1.




