If you don’t see this option, click the Get Data drop-down menu at the top-left, select From Other Sources, and then select From Web.
If you usually sign in to this page by entering a username and password into the site’s own login/sign-in fields, select Basic, enter your login details, and click Connect. If you need to log in through a work or school account, select Windows to use a Windows network login, or select Organizational account and then Sign In to log in through your organization’s server. If you have an API key, select Web API, enter the key, and click Connect.
If you’re not sure which table you need, click the Web View tab at the top of the right panel to display the website, and then click the table to select it. To import more than one table, check the box next to “Select multiple items” near the top-left.
If you’re using a different version of Office, you’ll see your version instead.
If you’re using a different version of Office, you’ll see your version instead.
Under “Text encoding,” select MS-DOS. Under “Options,” check the box next to “Insert line breaks. " The other options should be blank.
Right-click the file you created and select Get Info. In the file name, replace . txt with . iqy. When prompted, confirm that you want to change the file extension.
