Power Query on Excel for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1731569%22%20slang%3D%22en-US%22%3EPower%20Query%20on%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1731569%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)%20I%20past%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%20then%20change%20the%20file%20extension%20to%20an%20.iqy%20file.%3C%2FP%3E%3CP%3EI%20saved%20it%20as%20MS%20DOS%20file%20with%20line%20spaces.%20%26nbsp%3B%3C%2FP%3E%3CP%3EI%20saved%20it%20in%20the%20queries%20folder.%20(There%20are%20also%202%20sample%20.iqy%20documents%20that%20I%20didn't%20create.%26nbsp%3B%20They%20are%20from%20microsoft.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3)%20I%20opened%20my%20new%20excel%20spreadsheet%20and%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%20MS%20sample%20files%20that%20I%20hadn't%20save%20it%20that%20I%20mentioned%20in%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20comes%20the%20problem%3A%20I%20can't%20select%20the%20.iqy%20files%20that%20I%20created%20because%20they%20are%20%22greyed%20out%22.%3C%2FP%3E%3CP%3EI%20can%20see%20them%20but%20they%20are%20impossible%20to%20select%20since%20they%20are%20greyed%20out.%3C%2FP%3E%3CP%3EThough%20I%20can%20select%20the%202%20sample%20MS%20files%20and%20enter%20the%20data%20that%20are%20in%20it%20in%20my%20excel.%20But%20with%20my%20files%2C%20I%20just%20can't.%3C%2FP%3E%3CP%3EHow%20can%20I%20change%20the%20files%20so%20they%20are%20not%20greyed%20out%3F%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20with%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1731569%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

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) I past 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 then change the file extension to an .iqy file.

I saved it as MS DOS file with line spaces.  

I saved it in the queries folder. (There are also 2 sample .iqy documents that I didn't create.  They are from microsoft.

 

3) I opened my new excel spreadsheet and 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 MS sample files that I hadn't save it that I mentioned in 2.

 

Here comes the problem: I can't select the .iqy files that I created because they are "greyed out".

I can see them but they are impossible to select since they are greyed out.

Though I can select the 2 sample MS files and enter the data that are in it in my excel. But with my files, I just can't.

How can I change the files so they are not greyed out?

Can someone help me with this?

0 Replies