Run web queries

%3CLINGO-SUB%20id%3D%22lingo-sub-180438%22%20slang%3D%22en-US%22%3ERun%20web%20queries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-180438%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20import%20data%20from%20web%20but%20I%20have%20problems%20to%20use%20it.%20I%20am%20using%20an%20Excel%20version%20of%20Microsoft%20365%20on%20Mac.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20doing%20this%20without%20success%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1%20st)%20Pate%20the%20url%20of%20the%20website%20from%20which%20I%20need%20the%20data%20on%20a%20word%20new%20document%2C%20leaving%20a%20few%20spaces.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20I%20saved%20it%20as%20a%20.txt%20file%20and%20.txt%20file%20with%20the%20.ipy%20at%20the%20end%20of%20the%20name%20of%20the%20document.%20I%20saved%20it%20as%20MS%20or%20OS%20default%20(I've%20tried%20both).%20I%20saved%20it%20in%20the%20queries%20folder.%20%26nbsp%3B(In%20there%2C%20are%202%20.iqy%20documents%20that%20I%20didn't%20create%20it).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3)%20I%20opened%20a%20new%20excel%20file.%20I%20went%20to%20the%20data%20toolbar%20%26gt%3B%20Get%20external%20data%20%26gt%3B%20Run%20web%20query.%3C%2FP%3E%3CP%3EIt%20opened%20the%20Queries%20folder%20where%20appeared%20the%20file%20that%20I%20had%20created%20and%20these%202%20files%20that%20I%20hadn't%20save%20it%20that%20I%20mentioned%20in%202.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20comes%20the%20problem%3A%20I%20can't%20select%20the%20files%20that%20I%20created.%20They%20are%20over%20there%20but%20they're%20impossible%26nbsp%3Bto%20select.%20Though%20I%20can%20select%20these%202%20files%20and%20enter%20the%20data%20that%20are%20in%20it%20in%20my%20excel.%20But%20with%20my%20files%2C%20I%20just%20can't.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20with%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-180438%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-975993%22%20slang%3D%22en-US%22%3ERe%3A%20Run%20web%20queries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-975993%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F135989%22%20target%3D%22_blank%22%3E%40Jos%C3%A9%20Mar%C3%ADa%20Seminara%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHey%20Jose%20Maria%2C%3C%2FP%3E%3CP%3Eyou%20need%20to%20change%20your%20files%2C%20which%20contain%20the%20web-url%20into%20*.iqy.%20Excel%20only%20recognizes%20then%20that%20you%20are%20going%20to%20use%20a%20web%20query%20(and%20are%20not%20importing%20simple%20text%20files%20instead).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%2C%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1726966%22%20slang%3D%22en-US%22%3ERe%3A%20Run%20web%20queries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1726966%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20a%20similar%20problem.%3C%2FP%3E%3CP%3EI'm%20trying%20to%20do%20a%20Power%20(Web)%20Query%20on%20Excel%20for%20Mac.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20select%20the%20URL%20and%20I%20want%20to%20use%20to%20run%20the%20Query%20on%20and%20save%20it%20as%20an%20%22iqy%22%20file%20in%20my%20Queries%20Folder.%3C%2FP%3E%3CP%3EBut%20when%20I%20go%20into%20Excel%20and%20execute%20Data%2FGet%20External%20Data%2FRun%20Web%20Query%2C%20my%20.iqy%20files%20are%20all%20greyed%20out%20and%20I%20can't%20select%20them.%3C%2FP%3E%3CP%3EAny%20idea%20on%20how%20to%20change%20this%3F%3C%2FP%3E%3CP%3EI%20have%202%20Microsoft%20sample%20.iqy%20files%20in%20this%20folder%20which%20I%20can%20access%2C%20but%20these%20are%20just%20random%20samples%20put%20there%20by%20MS%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hi,

 

I am trying to import data from web but I have problems to use it. I am using an Excel version of Microsoft 365 on Mac.

 

I have tried doing this without success:

 

1 st) Pate the url of the website from which I need the data on a word new document, leaving a few spaces.

 

2) I saved it as a .txt file and .txt file with the .ipy at the end of the name of the document. I saved it as MS or OS default (I've tried both). I saved it in the queries folder.  (In there, are 2 .iqy documents that I didn't create it).

 

3) I opened a new excel file. I went to the data toolbar > Get external data > Run web query.

It opened the Queries folder where appeared the file that I had created and these 2 files that I hadn't save it that I mentioned in 2. 

 

Here comes the problem: I can't select the files that I created. They are over there but they're impossible to select. Though I can select these 2 files and enter the data that are in it in my excel. But with my files, I just can't. 

 

Can someone help me with this?

 

 

 

 

 

 

2 Replies

@José María Seminara 

Hey Jose Maria,

you need to change your files, which contain the web-url into *.iqy. Excel only recognizes then that you are going to use a web query (and are not importing simple text files instead).

 

Hope, this helps.

 

I'm having a similar problem.

I'm trying to do a Power (Web) Query on Excel for Mac. 

I select the URL and I want to use to run the Query on and save it as an "iqy" file in my Queries Folder.

But when I go into Excel and execute Data/Get External Data/Run Web Query, my .iqy files are all greyed out and I can't select them.

Any idea on how to change this?

I have 2 Microsoft sample .iqy files in this folder which I can access, but these are just random samples put there by MS