Forum Discussion

Tiboli's avatar
Tiboli
Copper Contributor
Sep 30, 2020

Power Query on Excel for Mac

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?

No RepliesBe the first to reply

Resources