This article will provide step by step instructions for the following versions of Excel:
Excel (Microsoft 365 for Windows)
- Open an existing Excel file or create a new file.
- On your desired worksheet, select “Data “-> “Get & Transform” -> “From Web.”
- Paste the URL into the text box, and then select OK.
- In the Navigator pane, under Display Options, select the Results table.
- Power Query will preview the data for you in the Table View pane on the right.
- Select Load. Power Query transforms the data and loads it as an Excel table.
- To refresh the data, select the table, in your worksheet, and click “Query” -> “Refresh”
- To schedule automatic updates, select a cell in the external data range.
- Select “Data” -> “Queries & Connections” -> “Connections” tab, right click a query in the list, and then select “Properties”.
- Click the “Usage” tab.
- Select the “Refresh every” check box, and then enter the frequency between each refresh operation.
Excel (Office 2016 for Windows)
- Open an existing Excel file or create a new file.
- On your desired worksheet, select the “Data” tab and choose “Get Data” -> “From Other Sources” -> “From Web.”
- Paste the URL into the text box, and then select OK.
- In the Navigator pane, under Display Options, select the Results table.
- Power Query will preview the data for you in the Table View pane on the right.
- Select Load. Power Query transforms the data and loads it as an Excel table.
- To manually refresh the data, select the table, in your worksheet, and click “Query” -> “Refresh.”
- To set up automatic refreshing, click on the Data tab. In the Connections group, click the arrow under Refresh All, and then click Connection Properties.
- In the dialog box that opens, choose the options you want on the Usage tab, under Refresh Control.
Should you have any additional questions, please reach out to our Support Team by emailing into support@apartmentiq.io.