In this kind of scenario, Excel won't ask you the credentials, it will
However, if the target website is coded as the guest user could see only a part of the content on the page, to view the rest, you need to sign in. Regarding to your 2nd question, if your website require the login before accessing the webpage/data, Excel should prompt you with a window Would suggest you using Word instead of Text Editor. Meanwhile, I've also test on the Text Editor, but seems like none of the save as file formats match the. Please follow the steps I provided and check SampleWebQuery01.iqy ', from my opinion, this is majorly caused of the different text en-coding and the hidden file extension name.
You mentioned ' he only way it worked for me was duplicating a Under File Name & Extension, change the extension name fromĤ.Open Excel, on the top ribbon, click on Data > Get External Data > Run Web Query. txt Plain Text, use MS-DOS coding.Ģ.Locate the txt file which we just created, right click on it > Get Info.ģ. I will elaborate the detailed steps on how to use web query in Excel for Mac:ġ.Open Word application and paste the URL which you want to query, save this document as.
However, based on my knowledge, this is not how Run Web Query in Excel for Mac works. Per your description, you have to use this kind of file Executable file extension for the macOS user.